At 09:18 07/04/2020 +0000, Nobody Noname wrote:
I've got some csv files to work with. They contain fields which are
quite long, and opening them with LO results in very large columns,
which are difficult to handle. Setting the column width by hand also
has me enabling line wrapping to show the full cell content. I'm
looking for a way to open those files by specifying my intended
column width and by enabling line wrapping.
I think there is a workaround, which may or may not be helpful.
o Start a fresh spreadsheet.
o Adjust the column widths as desired.
o Format relevant cells to "Wrap text automatically".
o Save as a template.
o Open CSV fie normally.
o Select all (Edit | Select All, or Ctrl+A, or click the rectangle at
top left where the row and column headers meet) or relevant cell range.
o Open new spreadsheet based on template.
o Click cell A1 or select all (as above).
o Paste, but using Edit | Paste Special (or Ctrl+Shift+V) instead of
normal Paste. In the Paste Special dialogue, ensure that Formats is
I trust this helps.
To unsubscribe e-mail to: email@example.com
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
- Re: [libreoffice-users] Open .csv by specifying column widths on command line · Brian Barker
Impressum (Legal Info)
: Unless otherwise specified, all text and images
on this website are licensed under the
Creative Commons Attribution-Share Alike 3.0 License
This does not include the source code of LibreOffice, which is
licensed under the Mozilla Public License (MPLv2
"LibreOffice" and "The Document Foundation" are
registered trademarks of their corresponding registered owners or are
in actual use as trademarks in one or more countries. Their respective
logos and icons are also subject to international copyright laws. Use
thereof is explained in our trademark policy