LibreOffice Calc CSV Wrap\Width

asked 2019-09-30 19:47:36 +0200

Gorko gravatar image

Hi,

If i open a csv file with Calc some of the longer columns aren't wrapped nor do i have the ability to do so, the only way i found i can make them shorter is by changing the column width but that not default.

What's the solution to this situation?

edit retag flag offensive close merge delete

Comments

Why are you not able to set Format ->Cells -> Tab: Alignment -> Option: Wrap text automatically?. Generally this can be done, though it makes not much sense on a flat file format like .csv. (besides you use that to save as .ods afterwards).

Opaque gravatar imageOpaque ( 2019-09-30 20:07:20 +0200 )edit

Like i said that doesn't work on said column it doesn't fold

Gorko gravatar imageGorko ( 2019-10-01 09:58:58 +0200 )edit

Sigh .. please, can you understand that help/solution may depend on a good problem description.

Either

  • "It does not work, since I cannot make the setting mentioned above"

or

  • "I can make the setting but it does not wrap afterwards automatically"

or

  • "I have selected all rows, and double clicked on a row border to force an optimal row height adaption, but it does not wrap, though I made the setting mentioned in the comment."

or

  • "I have selected the whole sheet using the square at the intersection of rows and columns and used Format -> Rows -> Optimal height and that doesn't initiate the wrap, though I made the setting mentioned in the comment.

?

Opaque gravatar imageOpaque ( 2019-10-01 10:19:42 +0200 )edit

I'm sorry, i wasn't aware it's so unclear... (not kidding)

I can make the setting but it does not wrap afterwards automatically

And

If I have selected all rows, and double clicked on a row border to force an optimal row height adaption, but it does not wrap, though I made the setting mentioned in the comment

Apart from Column Width (not optimal but regular) and setting it to a low number nothing else affects or works on the text at hand, just wanted to add it's a generated CSV so it's create by python if that makes any difference.

Gorko gravatar imageGorko ( 2019-10-01 14:04:40 +0200 )edit

Apart from Column Width ..

??? It is a matter of row height and not of column width. Try to change manually just to see whether text will be wrapped and thus setting is honored.

It should not matter in any way which application creates the file, if it is really a flat csv file.

Opaque gravatar imageOpaque ( 2019-10-01 14:43:33 +0200 )edit

Changing the row height works, same as as column width but it's irrelevant here. what i have is columns and i want them all to fit the same screen so controlling rows doesn't help me. Sure i can do it with column width but it's manually and i don't understand why it doesn't work automatically.

Gorko gravatar imageGorko ( 2019-10-02 13:20:56 +0200 )edit

??? I need to assume, that you don't actually understand what wrap means - It never, ever adjusts the column width. To wrap means: Adjust the row height to fit a text into a cell with given column width. Anything else would require an answer to: "How many wraps would you like me to insert so I can adjust the column width accordingly" and thus an input would be required.

Opaque gravatar imageOpaque ( 2019-10-02 13:36:02 +0200 )edit

You mean there is no Warp for columns? what if the text is so long the column is long, isn't it warped to fit into the cell?

Gorko gravatar imageGorko ( 2019-10-02 16:24:17 +0200 )edit

Please everything is said: Wrap for columns simply makes no sense. Wrap means what I wrote above. To adapt a row height so that text fits into a cell - please try to formulate a sentence like this one for what you mean. And finally you would end up in what LibreOffice does on very long line -> you get very broad column. There is no function Wrap to 3 visible lines of text and adjust column width accordingly.

Opaque gravatar imageOpaque ( 2019-10-02 16:39:19 +0200 )edit

Yes, Warp is wrong what i'm looking for is probably AutoFit (Excel) but for LibreOffice that would be OptimalWidth? still somehow it doesn't work What i want is the same as https://www.youtube.com/watch?v=2e2Ge... For some reason OptimalWidth adds more width instead of adjusting it, WHY... It works on the shorter columns but not on the longer ones, i can only manually adjust them as i mentioned before. Any other ideas?

Gorko gravatar imageGorko ( 2019-10-03 07:59:26 +0200 )edit