I’m trying to copy info from a calc spreadsheet into a base table. Here is what happens:
out of memory./connectivity/source/drivers/jdbc/object.cxx:175
Version: 7.3.7.2 / LibreOffice Community
Build ID: 30(Build:2)
CPU threads: 4; OS: Linux 5.15; UI render: default; VCL: gtk3
Locale: en-US (en_US.UTF-8); UI: en-US
Ubuntu package version: 1:7.3.7-0ubuntu0.22.04.7
Calc: threaded
Description: Ubuntu 22.04.5 LTS
Hope you can help, thanks
Just for starters, are you trying to copy the Calc data directly into an existing base table? or are you importing a calc spreadsheet into base as a new table? The first is not supported (without a few macros), but if the second method is used… at what point of the import process does the error occur? A few more specific details will go a long way in resolving your problem!
If I mark a sheet in Calc (Ctrl-A), select copy, then in Base use “Paste” from context menu of the destination Table an assistant opens to help importing my data. No macro needed.
.
But if I read " out of memory" my first question is: What number of records do you copy / size of records / contents of spreadsheet ?
and
Have you tried to import a small number of rows first?
Have you imported anything successfully this way? (As in: Is this a problem of size, or a general problem?)