Bug 65158

Summary: Add an option "do not modify formulas" in the data>sort dialog
Product: LibreOffice Reporter: chtfn <stephane.guillou>
Component: SpreadsheetAssignee: Not Assigned <libreoffice-bugs>
Status: RESOLVED DUPLICATE QA Contact:
Severity: enhancement    
Priority: medium CC: jorendc, stephane.guillou
Version: 4.0.3.3 release   
Hardware: All   
OS: All   
Whiteboard: BSA
i915 platform: i915 features:

Description chtfn 2013-05-30 06:25:32 UTC
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
Comment 1 Jorendc 2013-05-30 12:28:27 UTC
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
Comment 2 Kohei Yoshida (inactive) 2014-07-18 01:24:16 UTC
Bug 81309 should address this problem.

*** This bug has been marked as a duplicate of bug 81309 ***
Comment 3 chtfn 2014-07-18 08:30:43 UTC
Great, thanks Kohei!
Comment 4 stephanie park 2014-10-29 02:56:56 UTC
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.

Use of freedesktop.org services, including Bugzilla, is subject to our Code of Conduct. How we collect and use information is described in our Privacy Policy.