https://bugs.freedesktop.org/show_bug.cgi?id=83652
Priority: medium
Bug ID: 83652
Assignee: [email protected]
Summary: EDITING After sort , column not in sort modified
Severity: major
Classification: Unclassified
OS: Windows (All)
Reporter: [email protected]
Hardware: x86-64 (AMD64)
Status: UNCONFIRMED
Version: 4.3.1.2 release
Component: Spreadsheet
Product: LibreOffice
Create a spreadsheet with 3 column
Column one used for sort purpose
fill 5 row with A,C,E,G and I
Column 2 content numbers
fill with 1,2,3,4,5
Column 3 formula : Sum (column 3 previous row,column 2 own row)
first row filled with 1 , then =SUM(C1+B2),(C2+B3)......
Now add row 6 with values : B 6 ,column C becomes = C5+B6
Now sort area A1:B6 en see the result , formula in column C are changed
e.g. : C2 was =C1+B2, it becomes =C1+B3 and so on
So results are not more accurates
Open Office work ok (version 4.1.1)
So switched temporarly to openoffice
--
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
