Created attachment 204196 [details] Data Provider added Transformation Delete Rows +++ This bug was initially created as a clone of Bug #169596 +++ PRECONDITION: new Calc spreadsheet Data > Define Range = e.g. DataRangeForDataProvider.ods from #169514: https://bugs.documentfoundation.org/attachment.cgi?id=204066 Data > Data Provider select DBrange, CSV, URL 5x3numbersN.csv from #169570 https://bugs.documentfoundation.org/attachment.cgi?id=204142 PROBLEM DESCRIPTION: Data Provider Transformations: Delete Rows [Add] Parameters: Lookup value n, Column index 4 save Calc file --> attached DataProvider-Transformation-DeleteRows.ods transformation is not saved in the file this means that Data > Refresh Data Provider does not fill the expected data no data-transformations in content.xml: <calcext:data-mappings> <calcext:data-mapping xlink:href="file:///home/micha/LibreOffice/bugreports/169570_5x3numbersN__8x16.csv" calcext:provider="org.libreoffice.calc.csv" calcext:frequency="0" calcext:id="org.libreoffice.calc.csv" calcext:database-name="DBrange"> <calcext:data-transformations/> </calcext:data-mapping> </calcext:data-mappings> EXPECTED BEHAVIOR: transformation Delete Rows shall be saved to content.xml Version: 26.2.0.0.alpha0+ (X86_64) / LibreOffice Community Build ID: 480ef73deef62c458e5735cd496a1d74ef408ed8 CPU threads: 2; OS: Linux 6.8; UI render: default; VCL: gtk3 Locale: de-DE (de_DE.UTF-8); UI: en-US Calc: threaded
To make sure, that the problem is not connected to the fact, that the mentioned csv file has no header row, I have tested it with a csv file having first row as header row. I confirm, that the transformation is not saved. Tested with Version: 26.2.0.0.alpha1+ (X86_64) / LibreOffice Community Build ID: f8224b9625c26a7c92a289573765d4a201678d68 CPU threads: 32; OS: Windows 11 X86_64 (build 26100); UI render: Skia/Vulkan; VCL: win Locale: en-US (de_DE); UI: en-US Calc: threaded
Created attachment 204202 [details] comma separated with first row header The file used to confirm the bug report.