Created attachment 85127 [details]
Sort not recalculate cell values in last version 4.1.0.4 and 4.1.1.2
Sort not recalculate cell values in last version 4.1.0.4 and 4.1.1.2
Created attachment 85128 [details]
Sort not recalculate cell values in last version 4.1.0.4 and 4.1.1.2
Created attachment 85129 [details]
Sort not recalculate cell values in last version 4.1.0.4 and 4.1.1.2
Created attachment 85132 [details]
Sort not recalculate cell values in last version 4.1.0.4 and 4.1.1.2
Created attachment 85133 [details]
Sort not recalculate cell values in last version 4.1.0.4 and 4.1.1.2
Created attachment 85134 [details]
Sort not recalculate cell values in last version 4.1.0.4 and 4.1.1.2
Created attachment 85135 [details]
Sort not recalculate cell values in last version 4.1.0.4 and 4.1.1.2
(Hoping to be useful...) Same problem with version 4.1.1.2 on Windows XP SP3 (italian version) and 4.1.0.4 on Fedora 19 (english version). So it seems not platform dependent. Fixed in version 4.2.0 works fine Resolved in version 4.2.0 Fixed in version 4.2.0 works fine. |
Created attachment 85126 [details] Sort not recalculate cell values in last version 4.1.0.4 and 4.1.1.2 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 With version LibreOffice version 4.0.4.2 running good. With Openoffice 4.0.0 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.