We're sorry Aspose doesn't work properply without JavaScript enabled.

Free Support Forum - aspose.com

Sorting with absolute cell references

Hi,

In one of my spreadsheets, I create rows of data, and with a final column that contains a formula with a mixture of relative and absolute cell references (i.e. with a '$'prefix)

This works fine, until I do a sort on the whole datarange against one of the data columns. The relative cells ref's are fine in the new formulae, but the absolute cell ref's have been changed.

I would expect the latter would remain the same?

Am I doing something wrong, or is this the expected behaviour?

Cheers,

Furbster

Hi Furbster,

Could you create a sample test code with the template file to reproduce the issue you have mentioned. We will check it soon.

Thank you.

Amjad,

Hi, thanks for the response. I can put some code together, but it will take a while (there is no template- I start with a blank spreadsheet). However, before I do that, can you confirm that this is not the expected behaviour?

Cheers,

Steve

Hi,

Well, we normally follow MS Excel standards, if MS Excel does not do that, Aspose.Cells would follow it.

Thank you.

Hi,

After checking this in MS Excel, we find MS Excel do not change absolute cell references. We will support it soon.Thanks for your patience.

Hi,

Please try the attached fix.

Thank you.

Cool, that worked great!

Thanks for your help,

Steve