Bug 160344

Summary: FILESAVE .ods to .csv
Product: LibreOffice Reporter: proulxmichel0
Component: CalcAssignee: Not Assigned <libreoffice-bugs>
Status: RESOLVED WORKSFORME    
Severity: normal CC: miguelangelrv
Priority: medium    
Version: 24.2.1.2 release   
Hardware: ARM   
OS: macOS (All)   
Whiteboard:
Crash report or crash signature: Regression By:
Attachments: When this file is saved as .csv I do not obtain same as .ods but the original data file before filtering

Description proulxmichel0 2024-03-24 21:33:57 UTC
Created attachment 193275 [details]
When this file is saved as .csv I do not obtain same as .ods but the original data file before filtering

An .ods data file is filtered using Data ---> More filters---> Standard filter and select colomn "Mx" =>  0.50%Cu to elimanate all data under this value and then saved as .ods file. New .ods file is open and then saved as .csv.

When this new .csv file is open it gives the original .ods file before filtering.

I have tried with  7.6.4.1 version too and also obtain same result.

Many thanks for help!
Comment 1 m_a_riosv 2024-03-25 01:15:54 UTC
Because LibreOffice saves in the csv the raw data of the sheet.

What you can do is to send the filtered data with the standard filter to a second sheet and save that sheet as csv
Comment 2 proulxmichel0 2024-03-25 14:27:41 UTC
(In reply to m_a_riosv from comment #1)
> Because LibreOffice saves in the csv the raw data of the sheet.
> 
> What you can do is to send the filtered data with the standard filter to a
> second sheet and save that sheet as csv

Thank you Miguel now you have resolved my problem!