When publishing reports containing both MS Excel 2007 built-in formulas along with repeat dynamic formulas, I receive errors.
I have attached a screenshot of the error when uploading the attached .rdl file received from reporting services as well as the MS Excel Designer File.
We are currently using Aspose.Cells for Reporting Services v1.7.0.36.
It appears MS Excel formulas cannot be used in conjuction with repeat dynamic formulas but according to your documentation "Dynamic formulas allow you to insert MS Excel's formulas into cells even when a formula must reference rows that will be inserted during the export process."
Has the latest version of Aspose.Cells for Reporting Services changed the way it handles MS Excel Formulas?
Your assistance is required to resolve this issue.
Functions such as VLOOKUP, EOMONTH, SUMIF, SUMIFS, ISNA, IF, DATE, ROUNDUP, etc, are standard MS Excel formulas which we use extensively in our Excel Spreadsheets which we would like exported as a report. They are native to Excel and should have no bearing with SSRS.
Your Aspose help document states "Dynamic formulas allow you to insert MS Excel's formulas into cells even when a formula must reference rows that will be inserted during the export process." If SSRS did not support/recognise Standard Excel Formulas, then your document and the whole purpose for using Aspose is pointless!
I have been able to export an Excel Report containing formula's including VLOOKUP, EOMONTH, SUMIF, SUMIFS, ISNA, IF, DATE, ROUNDUP with the Dynamic Formula Smart Marker extracting data from a dataset populated from a Stored Procedure using Aspose v1.5.3. Aspose v1.5.3 however, has other issues.
If SSRS did not support Standard Excel Formulas then previous versions of Aspose would never have worked, Dynamic formulas would be redundant and there would be no benefit in using Aspose!
Please clarify why reports generated with Aspose v1.5.3 using formulas like VLOOKUP publish within SSRS and can be exported but reports generated with Aspose v1.7.0.36 cannot be published ???
Thank you for your support. We have found the issues.
Aspose.Cells for Reporting Services v1.5.3 can publish excel formulas functions like VLOOKUP because the cells value for RepeatDynamicFormula regard string when it publishes report.
Now, the latest version cannot publish because the cells value for RepeatDynamicFormula regard function. So this issue appears.
We will fixed the issues ASAP.
But you cannot view accurate value for RepeatDynamicFormula cell at Reporting Services Report Page.