| Summary: | Other: Calc Sort not recalculate cell values in last version 4.1.2.3 resolved in version 4.2.0 | ||
|---|---|---|---|
| Product: | LibreOffice | Reporter: | xanaesx |
| Component: | Calc | Assignee: | Not Assigned <libreoffice-bugs> |
| Status: | RESOLVED WORKSFORME | ||
| Severity: | normal | CC: | jbfaure, lgodard.libre |
| Priority: | medium | ||
| Version: | 4.3.2.2 release | ||
| Hardware: | Other | ||
| OS: | All | ||
| Whiteboard: | BSA | ||
| Crash report or crash signature: | Regression By: | ||
| Attachments: | Attached test files for testing in LibreOffice and images | ||
My analysis (LibO 4.1.2.3 on Win7) : I understand that the light blue columns [A:G] contain the input and output, and that the others [H:R] contain formulas and intermediate results, with the same formula set in each line. When you erase an [A:G] area somewhere, there are no line moves, and only the [H:R] cells of the concerned lines are rightly updated. Should you suppress an area (whole lines) somewhere, all lines below are moved up by area_height lines, the [H:R] formulas are updated, and all remain OK. Now if you sort an area restricted to columns [A:G], the remaining columns are unchanged (correct behaviour ; see bug 65637) : may be undesired, but no matter for you because all lines contain the same formulas in [H:R]. However, it appears a bug (bug 71368) in this case, not exactly your case but somewhat related (Calc messed by a sort and leaving incorrect reference). Analysis to be deepened. Fixed in version 4.2.0 works fine. Resolved in version 4.2.0. Correct status is WorksForMe because we do not know which commit solved the problem. Best regards. JBF Please, do not reopen a closed bug report without giving explanation. Closing again. |
Created attachment 89595 [details] Attached test files for testing in LibreOffice and images Sort not recalculate cell values in last version 4.1.0.4 and 4.1.1.2 and 4.1.2.3 I have a file made in Calc that I do not respect the values calculated in the cells when ordered with the option Tools> Data> Sort. The data entered by the user are in cell range A3: G1002, the other cells are protected and are where are the formulas and calculations are performed. Suppose I delete entries from the range A7: G20 the other cells update their values based on the formulas of each, until completely normal here. Now when I make a Data> Sort selecting the range of cells A2: G1002 used as column labels in the first row of the selection and ordination as Key 1 Client (ascending) and ordination as Key 2 Date CBTE. (ascending) and give runs Sort OK normally but the last rows revise I find I do not respect the values calculated by deleting the range A7: G20 in the above example. In this case the range of 272-285 lines show values not recalculated based on A272 cells: G285 that are empty. This error occurs with versions of LibreOffice version 4.1.0.4 and the latest LibreOffice version: 4.1.1.2 and 4.1.2.3 With version LibreOffice version 4.0.4.2 running good. With Openoffice 4.0.0 and 4.0.1 works well and does not give any errors. Version 4.1.0.4 causes the error described. I wish someone would report if an error or bug in the latest version 4.1.0.4 I tried changing cell formats numeric decimal number etc and does not work. Attached test files for testing in LibreOffice and OpenOffice. Operating System: All Version: 4.1.2.3 release