Description: 1.The problem is visible when several fields are added in the "Data field". 2.I move the "Data" field to a higher position (in the "Column field" area), but it has no effect. 3.When I go back to the pivot table properties, the "Data" field returns to the bottom automatically. This happens when installing Libreoffice 24.2.5.2 (X86_64), when I reinstall my previous version (7.6.7.2 (X86_64)) I do not have the problem. Some measures taken without any effect: - Restart in "Safe mode". - Uninstall and delete installation files from disk C and then reinstall the program. Steps to Reproduce: 1.Create a pivot table with two fields in "Column field" and two fields in "Data field". 2.Go to "Column field" and move the "Data" field to the top. 3.Click on OK. Actual Results: - The pivot table groups the data as if the "Data" field was at the bottom. - When returning to pivot table properties, the "Data" field automatically returned to the bottom. Expected Results: - The "Data" field should be kept in the chosen position (start, intermediate or end). Reproducible: Always User Profile Reset: Yes Additional Info: ---Version with the problem. Version: 24.2.5.2 (X86_64) / LibreOffice Community Build ID: bffef4ea93e59bebbeaf7f431bb02b1a39ee8a59 CPU threads: 12; OS: Windows 10.0 Build 19045; UI render: Skia/Raster; VCL: win Locale: es-PE (es_PE); UI: es-ES Calc: threaded ---Version without the problem. Version: 7.6.7.2 (X86_64) / LibreOffice Community Build ID: dd47e4b30cb7dab30588d6c79c651f218165e3c5 CPU threads: 12; OS: Windows 10.0 Build 19045; UI render: Skia/Raster; VCL: win Locale: es-PE (es_PE); UI: es-ES Calc: threaded
Created attachment 195790 [details] Sample problem file. - File created in version 24.2.5.2. - A pivot table has been created where the problem is observed.
Reproduced using attachment 195790 [details]. Works as expected in LO 7.6.6, but fails in LO 24.2.4 > Regression. In LO 24.2.4, dragging the fields within the Properties dialog seems to work at first (within the dialog), but the change is not reflected in the resulting PT (after pressing OK). OTOH, clicking the field directly in the PT works the same way in both LO 7.6 and LO 24.2: click on field > it moves to the first position.
I think we should raise the importance to critical, because it implies a change of the results, changing the results of formulas or graphs that depend on it. Reproducible also with Version: 25.2.0.0.alpha0+ (X86_64) / LibreOffice Community Build ID: bf07fa341a72838bd42ea54ce5d09925d75ce700 CPU threads: 16; OS: Windows 11 X86_64 (10.0 build 22631); UI render: Skia/Raster; VCL: win Locale: es-ES (es_ES); UI: en-US Calc: CL threaded
(In reply to m_a_riosv from comment #3) > I think we should raise the importance to critical, because it implies a > change of the results, changing the results of formulas or graphs that > depend on it. I don't see a change on results on cells; just that the normal procedure to set the position of fields is not working. OTOH, directly clicking on the relevant fields on the PT itself (first on the field that should end at the third position, then on the "second" field, and finally on the "first" field) should at least provide the desired positions. As for the importance (i.e. severity + priority) of the report, IMHO this is not as high as critical (because a work-around is possible), but any non-trivial regression should rather have some higher-than-normal priority, generally speaking.