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