https://bugs.freedesktop.org/show_bug.cgi?id=77018
Priority: medium
Bug ID: 77018
Assignee: [email protected]
Summary: PRINTING: Formulas referencing another spreadsheet
incorretly updated when sorted
Severity: normal
Classification: Unclassified
OS: Windows (All)
Reporter: [email protected]
Hardware: Other
Whiteboard: BSA
Status: UNCONFIRMED
Version: 4.2.2.1 release
Component: Spreadsheet
Product: LibreOffice
Created attachment 96861
--> https://bugs.freedesktop.org/attachment.cgi?id=96861&action=edit
Zip file containing 2 sample documents where the error is clearly evident
Problem description:
Formula in cells referencing cells in another linked spreadsheet are
incorrectly updated when these cells are sorted. The formulas are automatically
changed to reference completely different and seemingly unrelated cells in that
other spreadsheet. This bug was also noted when rows are moved or added, but
the issue is demonstrated below when data is sorted.
Steps to reproduce:
1. Download the attached zip file which contains 2 .ods spreadsheets and
extract both files into 1 folder.
2. Open FS.ods and say "Yes" to update links. (Ensure links are updated and no
error is given. The only spreadsheet that is linked is "Bookkeeping.ods")
3. Open tab "IS" (All references to ranges that follow are in reference to this
tab only, unless indicated otherwise)
4. Take mental note of all formulas in the range B12:B24. You will notice they
all reference some cell in row 403 of the "Bookkeeping.ods" spreadsheet.
5. Select range A12:AMJ24 (all rows in the "Operating Expenses" section)
6. Click Data >> Sort
7. Select "Sort key 1" to be Column A and all other sort keys as undefined
(sorting by the first column) and click OK
8. You will now notice that values in range B12:B24 are all changed. On my
machine they are all zero. You will also note that all references to row 403
are now references to various other rows, which is definitely incorrect
behavior.
Current behavior:
See step 8 above.
Expected behavior:
Expected all references to remain the same as before the sort i.e. referencing
some particular cell in Bookkeeping.ods but always row 403. The values should
not change after the sort.
Operating System: Windows 7
Version: 4.2.2.1 release
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
