While evaluating Aspose.cells for Java and I am experiencing bad behavior of RepeatDynamicFormula using an “IF” function which should return a string.
Although this works: &=&=IF(A{r}>=70,1,0)
…this does not: &=&=IF(A{r}>=70,”yes”,”no”)
Attached are a designer spreadsheet and a java class which demonstrate the problem.
Hi,
Thank you for your quick response!
I have verified that after creating the template using Excel, the Java code works as expected. Unfortunately after creating the template using LibreOffice Calc, the Java code fails to work properly.
Opening the LibreOffice-generated XLSX file in Excel and re-saving it does not improve the situation.
Although I can not “see” the difference between the spreadsheets created by Excel and LibreOffice Calc, I will discontinue testing with LibreOffice Calc.
Thanks again!
Hi,
Thanks for your feedback.
It’s good to know that your code is working fine with template file created by Ms-Excel.
You can post your template file created by LibreOffice Calc for us to investigate this issue further.
We will look into your issue and help/advise you asap.
The template file created by LibreOffice Calc is attached to the first post in this thread.
Thanks again!
Hi,
Thanks for using Aspose.Cells for Java.
We have looked into your issue. We were able to notice your mentioned issue and we will investigate and fix this issue later.
For the time being, you can use Ms-Excel generated file as a workaround.
Sorry for the inconvenience caused to you.