| Summary: | EDITING After sort , column not in sort modified | ||
|---|---|---|---|
| Product: | LibreOffice | Reporter: | Jean Vermeulen <id027102> |
| Component: | Calc | Assignee: | Not Assigned <libreoffice-bugs> |
| Status: | RESOLVED DUPLICATE | ||
| Severity: | major | CC: | jbfaure |
| Priority: | medium | ||
| Version: | 4.3.1.2 release | ||
| Hardware: | x86-64 (AMD64) | ||
| OS: | Windows (All) | ||
| Whiteboard: | |||
| Crash report or crash signature: | Regression By: | ||
| Attachments: | test file as described in bug description | ||
Hi.. That behavior is by design (changed by fixing of Bug 81309) since LO 4.3.1 and 4.2.7. You can temporarily use LO 4.3.0.4 or 4.2.6.3 to avoid this behavior. But this behavior is configurable by Bug 81633 fixing, currently available in master (4.4 daily build). *** This bug has been marked as a duplicate of bug 81633 *** Created attachment 107630 [details]
test file as described in bug description
Note: in this case the configuration option in LO 4.4 does not allow _today_ to keep the standard behavior of versions ≤ 4.2.6
Added a test file for further tests.
Best regards. JBF
|
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