Created attachment 172431 [details]
Demonstrates hidden rows and columns csv exported with cell content as shown
Calc: File, Save as, Text CSV with Edit filter settings, Save cell content as shown, Quote all text cells saves hidden cells. It is expected Save cell content as shown should not save hidden or no-height rows and columns.
Look at help: https://help.libreoffice.org/7.2/en-US/text/shared/00/00000207.html?System=UNIX&DbPAR=CALC&HID=modules/scalc/ui/imoptdialog/fieldframe#bm_id3154839
Save cell content as shown
Enabled by default, data will be saved as displayed, including applied number formats. If this checkbox is not marked, raw data content will be saved, as in older versions of the software.
I think it's not a bug, the "Save cell content as shown" option is about formats of data, not about filtered rows.
See also https://ask.libreoffice.org/en/question/311625/save-calc-csv-as-displayed-ignoring-hidden-rows-and-columns/
(In reply to raal from comment #1)
> Look at help:
> Save cell content as shown
> Enabled by default, data will be saved as displayed, including applied
> number formats. If this checkbox is not marked, raw data content will be
> saved, as in older versions of the software.
> I think it's not a bug, the "Save cell content as shown" option is about
> formats of data, not about filtered rows.
Disagree, given cell content is not shown because of the format is *exactly* why it is a bug. There is no other way for user to export data as shown without changing it or using macro, both unreasonable.
Agree current functionality is "Save data format as shown" rather than "Save cell content as shown" but the documented intention is clearly to "Save cell content as shown".
Interesting raising filtering which was unintentionally included in example by filtering rows rather than hidden/zero-width rows.
Filtering is inconsistent too:
eg hide A2, zero height A4, filtering out A6, A8, A10
cut and paste
Col1 Col2 Col3 Col4
A1 B1 C1 D1
A2 B2 C2 D2
A3 B3 C3 D3
A4 B4 C4 D4
A5 B5 C5 D5
A7 B7 C7 D7
A9 B9 C9 D9
export as csv
(In reply to flywire from comment #3)
> (In reply to raal from comment #1)
> > I think it's not a bug, the "Save cell content as shown" option is about
> > formats of data, not about filtered rows.
> Disagree, given cell content is not shown because of the format is *exactly*
> why it is a bug.
I disagree, hiding columns/rows is not cell coontent display formatting. It'd be unpleasantly surprising if a *view* option would alter the document *content* without user intend.
> There is no other way for user to export data as shown
> without changing it or using macro, both unreasonable.
And that is why for this there should be an extra option like "Omit hidden/filtered rows and columns" or some such.
(In reply to Eike Rathke from comment #4)
> (In reply to flywire from comment #3)
Agree, a view of data is the right approach. Looking at the cut-and-paste output in Comment 3:
- Hidden data is still in the dataset, just not shown (fix the terminology)
- Filtered data is not in the dataset, like a view of a data table (database query).
The "As formatted (and hidden)" data view (tab delineated) is *exactly* what cut-and-paste returns (see Comment 3). So should csv export (with comma) by default.
BUG: csv export exports data the is not in the filtered view
BUG: label "Save cell content as shown" doesn't reflect functionality
No confirmation. Probably few are aware of the intricacies of this functionality, you never know what you are going to get. Examples below are default (no user-formatting applied):
This thinking would naturally expand to "I have my column 3 cm, but the text in the column is not truncated on "save as shown"" reports. Clear notabug IMO.
I tried with MS Excel 2016, and I found no way to treat hidden cells as absent in CSV export, either.