root/tmp 10GiB cannot cope with size of my Calc spreadsheet

[andy-andyo]

I use big spreadsheets, the one I’m trying to load and add further rows to is 134 Mb file size and currently 70000 rows long by 200 columns wide. The cell formulae are complicated and typically 5 or 6 run to about 10 lines or so.

I keep crashing libreoffice because the file size has exceeded what it can cope with. The cause is the Root Folder which has sub-folder /tmp. The size of Root is10Gig. The ( root) /Tmp folder holds temporary files that are the working files of the spreadsheet when loaded (I am assuming) and these take up about 9.6GiB.

I need this spreadsheet to exceed 100,000 rows.

1. Is it possible to increase the Root partition and thereby the Root folder size to say 50GiB ?
   (taking into account that all the partitions on the computer will have to move over to allow for the creation of 40Gig more space in to Root )
2. Would it solve the problem loading large spreadsheets ?
3. If it could fix the problem, can anyone advise me moving the partitions to create this space ? (As I do not want to destroy my Linux Mint system especially /home partition)

Ref: my Linux system- files=ext4, linux mint 20.1, cpu=Intel i7-8700K cpu @3.70GHz, 1 processor with 6 cores and 12threads, ram=32830488 KiB, graphics 3840 x 2160, GeGTX 1080/PCIe/SSE2 X.Org… Linux kernel 5.4.0-62-generic (x86_64) I believe my partitioning scheme is MBR.

File Systems - -

udev	/dev	0.00 % (15.6 GiB of 15.6 GiB)
tmpfs	/run	0.10 % (3.1 GiB of 3.1 GiB)
/dev/nvme0n1p1	/	19.16 % (7.4 GiB of 9.1 GiB)
/dev/nvme0n1p6	/usr	21.11 % (36.0 GiB of 45.6 GiB)
tmpfs	/dev/shm	0.00 % (15.7 GiB of 15.7 GiB)
tmpfs	/run/lock	0.08 % (5.0 MiB of 5.0 MiB)
tmpfs	/sys/fs/cgroup	0.00 % (15.7 GiB of 15.7 GiB)
/dev/nvme0n1p2	/boot	29.12 % (654.2 MiB of 923.0 MiB)
/dev/nvme0n1p10	/opt	5.40 % (43.1 GiB of 45.6 GiB)
/dev/nvme0n1p5	/home	64.16 % (65.4 GiB of 182.3 GiB)
/dev/nvme0n1p9	/srv	5.44 % (17.2 GiB of 18.2 GiB)
/dev/nvme0n1p11	/usr/local	5.25 % (43.2 GiB of 45.6 GiB)
/dev/nvme0n1p7	/var	73.33 % (4.9 GiB of 18.2 GiB)
tmpfs	/run/user/1000	0.00 % (3.1 GiB of 3.1 GiB)
/dev/sda1	/run/timeshift/backup	15.39 % (775.0 GiB of 915.9 GiB)

(this table edited by ajlittoz to make it readable)

root/tmp is the folder. (Swap partition 12) is 70GB. Extended partition 3 is 470GB and contains partitions 5, 6, 7, 8, 9, 10, 11, 12. Free space 519GB

Sorry about being “Off-Topic” but I see this as being about Calc Spreadsheets and how they operate in the linux system structure.

[anon73440385]

Your question is quite off-topic, since it mostly deals with a filesystem layout question on la GNU/Linux system (aggravated by the fact, that you don’t tell anything about the filesystem type, LVM usage and confusingly using uppercase T in /Tmp while on all GNU/Linux system I’ve ever seen that directory reads /tmp additionally combined with term root. Therefore it is unclear whether you talk about /root/Tmp, /Tmp or /tmp). Anyway, the only advice, I’d give here: Create a separate filesystem for that purpose and change path in LibreOffice using Tools -> Options -> LibreOffice -> Paths -> Type: Temporary files to the new filesystem. Don’t touch / (root - filesystem).

And the answer to the only item related to LibreOffice (2. Would it solve the problem loading large spreadsheets ?) depends on your own analysis. If your analysis is correct, then more disk space will fix it, if not, it won’t.

[ajlittoz]

This does not seem to a be a direct question for LO but rather an OS one.

What is your partitioning scheme? MBR or GPT? Have you created physical partition or logical volumes with LVM? Is there any free space on your disk? How large is your RAM and your swap space?

Please do not use Add Answer but edit your original question to enhance the details of your question (answers are reserved for solutions to a problem on this Q&A site).

[ml9104]

Just create and mount a partition for /tmp with the necessary size.

[andy-andyo]

hi ml9104 - already tried that by mounting partition 8 - had to edit fstab to recognise the mounted partition - but after mounted, whole system went slow, and no spreadsheets could not be opened at all. Used Time shift to go back. To be fair I think the whole process was too complicated for me, don’t really have the knowledge, although I followed instructions to the letter while working in terminal. I don’t think libreoffice or the file system likes the /tmp to be moved partition position. Andy