| Summary: | Add an option "do not modify formulas" in the data>sort dialog | ||
|---|---|---|---|
| Product: | LibreOffice | Reporter: | Stéphane Guillou (stragu) <stephane.guillou> |
| Component: | Calc | Assignee: | Not Assigned <libreoffice-bugs> |
| Status: | RESOLVED DUPLICATE | ||
| Severity: | enhancement | CC: | jorendc, stephane.guillou |
| Priority: | medium | ||
| Version: | 4.0.3.3 release | ||
| Hardware: | All | ||
| OS: | All | ||
| Whiteboard: | BSA | ||
| Crash report or crash signature: | Regression By: | ||
I can confirm this is a valid request. Thanks for reporting! Tested so far: * Open Calc * enter: A1 : 1 A2: 2 ... A5: 5 * create a formula in B1: =A1 * create a formula in B2: =$A$1 * Data > Sort * sort 'Column A', Descending Result: both B1 and B2 shows value 5. Kind regards, Joren Great, thanks Kohei! How about 4.3? 4.4 wasn't even working on Windows for the past month and as of Version: 4.3.2.2, Calc is still corrupting users spreadsheets. |
Problem description: At the moment, there is no option to sort cells depending on the results of formulas without breaking the formulas as the cells get reorganised. Steps to reproduce: 1. Write several formulas which result depend on values contained in other cells throughout the sheet 2. Try to reorganise the cells thanks to the data>sort dialog Current behavior: Cells are reorganised but loose their value as formulas now refer to different cells. Expected behavior: There should be an option to conserve the formulas when sorting data. Operating System: Ubuntu Version: 4.0.3.3 release