We will be migrating from Ask to Discourse on the first week of August, read the details here

Ask Your Question

What is the maximum number of characters in a Calc cell? [closed]

asked 2013-09-09 17:15:20 +0200

JimB gravatar image

updated 2020-08-08 23:29:12 +0200

Alex Kemp gravatar image

In LibreOffice Calc, what is the maximum number of characters in a cell? (In comparison: the xls format has 32,767 characters, and it seems .xlsx also has that limit). I'd like to programmatically create Calc files and would like to know the limit (if any) and whether it is likely to change.

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2020-08-08 23:30:05.168139


How to increase cell maximum length 32768 to 50000

Imirisoft gravatar imageImirisoft ( 2017-09-19 12:51:54 +0200 )edit

3 Answers

Sort by » oldest newest most voted

answered 2013-09-09 17:54:04 +0200

horst gravatar image

You might find some answershere.

edit flag offensive delete link more


The Q&A topic linked here is very old and the given information is no longer valid.

Lupp gravatar imageLupp ( 2020-05-23 16:53:22 +0200 )edit

answered 2019-12-19 22:44:31 +0200

Lupp gravatar image

updated 2020-05-23 16:51:13 +0200

Reopened for... The answers to this question formerly given are no longer valid.

For many versions the maximum number of characters per Cal cell was 65535 (=2^15 - 1) (=2^16 - 1) [rectified 2020-05-23].

As of today, tested with LibreOffice V 6.3.3, there is no longer a relevant limit to that number.
I couldn't find release notes for any version clearly stating the number, but got experimentally that it now is 268435455 (= 2^28 - 1). This means you can easily keep the text string of all "The Song of Ice and Fire" in a single cell of a Calc spreadsheet.
You may, however, get "bad allocation" problems If you try to come near that maximum with many cells or to work with such a cell in a formula needing to move the string to memory..

edit flag offensive delete link more


Some spreadsheet functions though may still be limited to process only up to 64k characters per cell.

erAck gravatar imageerAck ( 2020-05-26 02:22:43 +0200 )edit

answered 2020-04-13 14:18:48 +0200

This is not correct. The limit is somewhere under 1,316,350. That is the character count in Writer for a log file I tried to open in Calc and failed because the cell character limit was exceeded. It was exceeded because calc fails to continue to parse the delimiter after 108 lines for some reason and puts the rest in one cell.

edit flag offensive delete link more


Mike Kaganski gravatar imageMike Kaganski ( 2020-04-13 14:23:18 +0200 )edit

Thanks for that, bummer the FAQ doesn't seem to come up in searches. Now if I could figure out why it stops parsing the delimiter...

ebonweaver gravatar imageebonweaver ( 2020-04-13 14:32:35 +0200 )edit

Probably the data is malformed for CSV and opens a quoted field that is never closed, thus the remainder correctly is all read into one cell. In the raw file search for a sequence of ," (if the field separator is comma) and see if that quoted field is closed, i.e. either by ", or a single " at line end.

erAck gravatar imageerAck ( 2020-05-26 02:20:33 +0200 )edit

Question Tools



Asked: 2013-09-09 17:15:20 +0200

Seen: 11,317 times

Last updated: May 23 '20