Sorting with absolute cell references

Aspose.Cells Product Family
1

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

2

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.

3

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

4

Hi,

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

Thank you.

5

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.

6

Hi,

Please try the attached fix.

Thank you.

7

Cool, that worked great!

Thanks for your help,

Steve