Unable to open csv file on libreoffice error shown is (the data could not be loaded because maximum no characters per cell was exceeded)?)

asked 2020-05-23 10:46:29 +0200

ankit30 gravatar image

Using libreoffice 6.1 on fedora 29.It worked fine suddenly started showing the (data could not be loaded because maximum no characters per cell was exceeded) error on CSV file .Please help.

edit retag flag offensive close merge delete

Comments

Well, given the message, reduce the amount of characters per cell.

gabix gravatar imagegabix ( 2020-05-23 14:03:36 +0200 )edit

Hmm - taking https://wiki.documentfoundation.org/Faq/Calc/022 into account, I'd state that 2^31 is a rather large number (though I admit that it's not clear, which LibreOffice version started to allow such high number).

Opaque gravatar imageOpaque ( 2020-05-23 14:10:49 +0200 )edit
1

Just a thought: could it be that you're choosing the wrong delimiter when opening the .CSV? The default might have changed, you never know...

ml9104 gravatar imageml9104 ( 2020-05-23 23:12:51 +0200 )edit