Formula ="A1" is converted to ="R[-1]C[0]" on export to ML

Aspose.Cells Product Family
1

We found a problem in the ML conversion process where text strings (or even substrings) in formulas that look like A1 references are converted to RC format on export to ML.

We are on 4.5.1 (.NET).

It crashes when we use a formula like this.

= HYPERLINK("http://office.microsoft.com/en-us/excel/HP052090421033.aspx", "DATE")

As the HP### is treated as the HP column and some large row reference.

This could be related to an earlier case where we saw this problem occuring with Named Ranges that reference formulas instead of range addresses.

Please help as this problem permeates through out our solution.

Thanks

Brett

2

Hi,

Thank you for Considering Aspose.

Since you are using the old version of Aspose.Cells, please try the attached latest version (V4.5.1.19).If you still face this problem, please post your template file and we will figure it out soon.

Thank you & Best Regards,

3

Hi,

Thank you for considering Aspose.

We have tested your issue with the latest version (Attached in my previous Post) and we also found this issue in that version. We will fix it soon.

Thank you & Best Regards,

4

Hi,

Please try the attached fix.

Thank you.

5

The issues you have found earlier (filed as 6701) have been fixed in this update.

This message was posted using Notification2Forum from Downloads module by Laurence.