https://bugs.freedesktop.org/show_bug.cgi?id=83391
Priority: medium
Bug ID: 83391
Assignee: libreoffice-bugs@lists.freedesktop.org
Summary: EDITING: formula reference changed after partial rows
reordering
Severity: normal
Classification: Unclassified
OS: Windows (All)
Reporter: o.tal...@gmail.com
Hardware: Other
Whiteboard: BSA PossibleRegression
Status: UNCONFIRMED
Version: 4.3.1.2 release
Component: Spreadsheet
Product: LibreOffice
Created attachment 105590
--> https://bugs.freedesktop.org/attachment.cgi?id=105590&action=edit
a spreadshheet to reproduce the bug
Problem description:
In some columns of a spreadsheet, A to K, I load some values.
In subsequent columns, L to Q, there are formulas that make some simple
computation on the cells of the columns A to K.
The cells in columns A to K are not protected. The cells in columns L to Q are
protected.
Now, I select a rectangular block of value cells (some rows, columns A to K),
and make a row reordering (based on some value in a column from A to K): the
formulas in the columns L to Q change reference. They "follow" the "value"
cells, instead of being unchanged. To have no errors I must unprotect the
spreadsheet and select all the columns for the row reordering.
Steps to reproduce:
1. Load and open the test file I have loaded
2. Select from column A to column K, from row 5 to row 14
3. Select Data, Order, choose column J as order key, and order
Current behavior:
The formulas in the columns from L to Q change the reference to the
corresponding cells. For instance formula in cell L5 becomes H14-I14, and so
on.
Expected behavior:
Cells in columns L to Q should be unchanged. For instance, after reordering,
cell L5 should be H5-I5, as before partial ordering.
The only way to reorder without errors is select all the columns for row
reorder.
Operating System: Windows XP
Version: 4.3.1.2 release
Last worked in: 4.1.6.2 release
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
