The Aspose.Cells.copyCellRange does not update formulas in the same way as the corresponding "manual" operations in Excel. Moreover, copyCellRange and copyColumn seems to update formulas in an "inconsistent" manner.
- Aspose.Cells.copyColumn gives the expected result (i.e. same behaviour as Excel).
- Aspose.Cells.copyRow does not update references that refer to other rows than the current row. Seems like references to other than the current row are treated as absolute.
- Aspose.Cells.copyCellRange behaves in the same way as Aspose.Cells.copyRow when cells are copied from one row to another, but behaves differently from Aspose.Cells.copyColumn when copying from one column to another. References to other than the current column are treated as absolute.
Is there any way I can get the Aspose.Cells.copy* methods to behave in the same way as the correspondin "manual" operations in Excel (I'm using a recent version og Aspose.Cells for Java)?
Example
A | B | C | D | |
---|---|---|---|---|
12 | 10.5 | |||
13 | 5.25 | =B13*C12 | ||
14 |
Result of manual operations in Excel; copy C13 to D13, copy C13 to C14:
A | B | C | D | |
---|---|---|---|---|
12 | 10.5 | |||
13 | 5.25 | =B13*C12 | =C13*D12 | |
14 | =B14*C13 |
Using Aspose.Cells.copyColumn; copy column C to column D:
A | B | C | D | |
---|---|---|---|---|
12 | 10.5 | |||
13 | 5.25 | =B13*C12 | =C13*D12 | |
14 |
Using Aspose.Cells.copyRow; copy row 13 to row 14:
A | B | C | D | |
---|---|---|---|---|
12 | 10.5 | |||
13 | 5.25 | =B13*C12 | ||
14 | =B14*C12 |
Using Aspose.Cells.copyCellRange; copy C13 to D13, copy C13 to C14:
A | B | C | D | |
---|---|---|---|---|
12 | 10.5 | |||
13 | 5.25 | =B13*C12 | =B13*D12 | |
14 | =B14*C12 |