paste limits in calc

asked 2019-09-19 09:13:35 +0200

Burnsie gravatar image

I am trying to paste large ammounts of data into calc, but can only enter 65536 rows, even if I do 2 cut and pastes no rows above 65536 are paste into the worksheet.

I have a workround but wondered if this was a system problem or finger trouble.

I am using;

Version: 6.2.6.2 (x64) Build ID: 684e730861356e74889dfe6dbddd3562aae2e6ad

edit retag flag offensive close merge delete

Comments

paste from where?

kompilainenn gravatar imagekompilainenn ( 2019-09-19 17:21:50 +0200 )edit

I am pasting from a web based app.

BUT - the work round I use is to past into a text editor, then save as a csv text file and load the data that way.

By doing this I can load all the records ( about 120,000 rows )

Burnsie gravatar imageBurnsie ( 2019-09-20 15:50:35 +0200 )edit

your web apps based on Excel?

kompilainenn gravatar imagekompilainenn ( 2019-09-20 17:26:26 +0200 )edit

Not as far as I know. Is there a problem copying from excel then? I normally load .xlsx files directly into LO

Burnsie gravatar imageBurnsie ( 2019-09-20 17:43:27 +0200 )edit

I believe the problem is in the data source, Calc has a capacity of 10048576 rows and 1024 columns.

Gilberto Schiavinatto gravatar imageGilberto Schiavinatto ( 2019-09-20 18:27:05 +0200 )edit

yep, there is a problem with copy/paste from Excel to Calc. Now when you use direct pasting cells from Excel to Calc you'll get only 65536 cells with data in Calc =( If you just open XLSX file with more than 65536 data cels in Calc then it will open good with all data. Problem is only with pasting

kompilainenn gravatar imagekompilainenn ( 2019-09-20 19:03:30 +0200 )edit

Then save the excel file to ods and then copy and paste.

Gilberto Schiavinatto gravatar imageGilberto Schiavinatto ( 2019-09-20 21:33:20 +0200 )edit