Bug 137830 - Implement export/import of Calc sheets into/from text tables
Summary: Implement export/import of Calc sheets into/from text tables
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
3.3.0 release
Hardware: All All
: medium enhancement
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: CSV-Dialog
  Show dependency treegraph
 
Reported: 2020-10-28 17:26 UTC by smntov
Modified: 2023-04-21 14:57 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:


Attachments
A screenshot with a text table... (18.20 KB, image/png)
2020-10-28 17:28 UTC, smntov
Details

Note You need to log in before you can comment on or make changes to this bug.
Description smntov 2020-10-28 17:26:49 UTC
Description:
Please implement export/import of Calc sheets into/from text tables in plain text files.

See an example of such tables here:
https://ask.libreoffice.org/en/question/273783/how-to-save-a-sheet-as-a-text-table/

As far as I know only Emacs can create such text tables. It would be nice if LO would be able to do it as well.

Pandoc's grid_tables extension might be used as a reference:
https://pandoc.org/MANUAL.html


Steps to Reproduce:
1. In Calc: File -> Export as...
2. In Calc: File -> Import as...
3.

Actual Results:
No option "Text table"

Expected Results:
There should be a "Text table" for both - export and import


Reproducible: Always


User Profile Reset: No



Additional Info:
Pandoc's grid_tables extension might be used as a reference:
https://pandoc.org/MANUAL.html
Comment 1 smntov 2020-10-28 17:28:21 UTC
Created attachment 166813 [details]
A screenshot with a text table...
Comment 2 Heiko Tietze 2020-11-17 10:00:40 UTC
Would be a nice enhancement. But as stated on ask, realizing per macro/extension is perhaps more flexible- and faster implemented.

I would not think about an import filter but restrict it to export.
Comment 3 smntov 2020-11-18 12:55:35 UTC
Export is definitely more important, but in the long run - if you implement only export - then you cause a sort of data loss, because you can't edit your plain text tables anymore in LO. CSV works both ways... I think this enhancement is close to CSV export/import... It would be very convenient to store such readable tables in git.

Anyway - Heiko, thank you for considering this enhancement. Does the status change means this will be implemented in the next release?