Bug 160344 - FILESAVE .ods to .csv
Summary: FILESAVE .ods to .csv
Status: RESOLVED WORKSFORME
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
24.2.1.2 release
Hardware: ARM macOS (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2024-03-24 21:33 UTC by proulxmichel0
Modified: 2024-03-25 18:47 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:


Attachments
When this file is saved as .csv I do not obtain same as .ods but the original data file before filtering (40.25 KB, application/vnd.oasis.opendocument.spreadsheet)
2024-03-24 21:33 UTC, proulxmichel0
Details

Note You need to log in before you can comment on or make changes to this bug.
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!