Description: Importing a CSV file where the value of a single cell exceeds 65536 characters fails with error message: "The data could not be loaded completely because the maximum number of characters per cell was exceeded". However, copying the exact same value to a cell succeeds. Steps to Reproduce: 1. Open csv file containing a "cell" with a value of at least 65537 chars in Calc Actual Results: Error: "The data could not be loaded completely because the maximum number of characters per cell was exceeded" File is loaded, but cells with values over 65536 chars length are cropped. Expected Results: Calc should be able to load the file correctly since 65537 chars doesn't exceed the cell limit (can be pasted into cell). Reproducible: Always User Profile Reset: No Additional Info: Version: 24.2.7.2 (X86_64) / LibreOffice Community Build ID: 420(Build:2) CPU threads: 24; OS: Linux 6.8; UI render: default; VCL: x11 Locale: en-US (C.UTF-8); UI: en-US Ubuntu package version: 4:24.2.7-0ubuntu0.24.04.4 Calc: threaded
Created attachment 202714 [details] example csv file that leads to error This file was kindly provided by u/Tex2002ans
Created attachment 202715 [details] Example file that does NOT lead to error This file was kindly provided by u/Tex2002ans on reddit
Could confirm the behavior, but might be it is intended: CSV-data will be often used for import to database. VARCHAR-fields are limited in many databases to 2^16=65536 characters. …but also could be an old limit of cells in Calc… Tested with Version: 25.8.0.4 (X86_64) Build ID: 48f00303701489684e67c38c28aff00cd5929e67 CPU threads: 6; OS: Linux 6.4; UI render: default; VCL: kf5 (cairo+xcb) Locale: de-DE (de_DE.UTF-8); UI: de-DE Calc: threaded
by Wiki likely 2^31 is the programmatic limit; tested to accept 70 million characters, although worked exceptionally laggy