Free Support Forum - aspose.com

Formulas

Received : 2007/11/29 08:46:55
Message : I have a template excel spread sheet which I'm using to getnerate a report. I'm manually updating formulas to make it process faster. In most cases this works fine, however when I have a formula =SUM(A$11:O$11) in the template, at run time aspose.cells transposes it to =SUM(A1$1:O$11) (R1C1Formula ="=SUM(R[-10]C[-17]R1:R11C[-3])"). When output to the new result spreadsheet it un-transposes it correctly, but I have logic to find cell references so that I can update them and it gets thrown off by the swapping of the 1 and $.


This message was posted using Aspose.Live 2 Forum

Hi,

Thanks for considering Aspose.

We found the problem you have mentioned. We will figure your issue soon.

Thank you.

Please try this attached fix.

This works. Thanks for the quick response! Will this fix be included in the next version?

Hi,

Well, you can use this fix without any problem. And, yes all the fixes (including this fix), other optimization, feature additions and enhancement will be included in our next official release.

Thank you.