Hello, I am new to LO. I have a large spreadsheet (90K rows, 30 columns) which includes long data strings in one column. It opens in Calc, but I cannot import the data into Base. When I try to, I get the following error:
Runtime Error!
Program: C:…\soffice.bin
This application has requested the Runtime to terminate it in an unusual way. Please contact the application’s support team for more information.
LO then crashes and has to recover the Calc and Base files before proceeding (recovery has not caused issues).
I can import the column headers and the first 100 or so rows (haven’t tried to see how far down I can import), but cannot import the entire dataset. Same is true if I delete the column with the long data strings.
To import, I am copying all of the data in Calc, pressing the “Table” button in Base, and selecting Edit / Paste.
Is there anything I need to be doing to be able to import all of the data in my spreadsheet into Base?
Thanks in advance!
-Sam