How to save a sheet as a text table?

stov · October 28, 2020, 10:41am

How can I save a regular sheet as a text table in a plain text file? Like this:

+---------------+---------------+--------------------+
| Left aligned  | Right aligned | Centered           |
+:==============+==============:+:==================:+
| Cats          | $500          | - black            |
|               |               | - white            |
+---------------+---------------+--------------------+
| Dogs          | $700          | - grey             |
|               |               |                    |
|               |               | Mixed colors       |
|               |               | available          |
+---------------+---------------+--------------------+

igorlius · October 28, 2020, 11:06am

I dont think LO has such an option “build-in”. (Markdown exprot might be a nice addon or feature)

How improtant is the correct width of the seperators (dashes) for you?

I think i could write up a macro quickly if you are ok with a static number of “-” dashes (e.g. ----------)
A version which would dynamically calculate the number of dashes might be a little harder to do.

stov · October 28, 2020, 11:14am

could you, please, give an example of an imperfect output with a static number of “-” dashes?
do you think that this functionality would be of general interest so I open an enhancement request? Emacs has ability to generate/manipulate(shrink, extend, navigate, etc) such text tables on the fly…

igorlius · October 28, 2020, 11:40am

This would be the simplest version i could create, which is similar to a CSV export

+---+---+---+
|Cats|$500|- black\n- white|
+---+---+---+
|Dogs|$700|- grey \n\nMixed colors available|
+---+---+---+

Handling newlines or dyanmic seperate length differently is possible, but that would be a little™ more effort.

2) Maybe?! You can first look and see if such an feature requests already exists.
https://bugs.documentfoundation.org and if not just propose it.