[Solved] Two instances of Calc

[andIF]

I run Linux Mint currently version 7.3.7.2 Also have LibreOffice Calc loaded. Before I fully install OpenOffice for OO Calc I need to know if I can run each side by side and in that way achieve multithreading. I need to achieve multithreading because my spreadsheets are large and complicated. A small one is 200 columns x 10000rows. Each column being a function or multiple function formulae down the rows. The longest spreadsheet I have is 2.5 million rows over eight separate sheets (100 columns wide).
Not unsurprisingly sometimes a spreadsheet can take upto 20 minutes (or much longer) to Save, so you would think you could go to Write and finish off some text while waiting for the save to complete. No. The whole LibreOffice program is locked doing the Save. you cannot load or do anything else.
So it would be great if Open Office Calc can cope with this problem. If open office can cope with complicated big spreadsheet files while work in Write at same time, or even two instances of Calc at once what a relief that would be ! Can anyone advise me ?

[MrProgrammer]

Also have LibreOffice Calc loaded. Before I fully install OpenOffice for OO Calc I need to know if I can run each side by side and in that way achieve multithreading.

Surely Linux will treat LibreOffice Calc and OpenOffice Calc as separate tasks. The two applications have separate process IDs. Try it and see. Like LibreOffice, OpenOffice can perform only one task at a time. However you should be able to use OpenOffice while LibreOffice is busy.

$ ps -A -o 'pid comm=Application' | { head -n 1; grep 'Office.app'; }
  PID Application
10990 /Applications/OpenOffice.app/Contents/MacOS/soffice
15804 /Applications/LibreOffice.app/Contents/MacOS/soffice

The longest spreadsheet I have is 2.5 million rows over eight separate sheets (100 columns wide).

OpenOffice Calc supports a maximum of 16⁵ = 1,048,576 rows.

If this solved your problem please go to your first post use the Edit ✏️ button and add [Solved] to the start of the Subject field. Select the green checkmark icon at the same time.

[LastUnicorn]

I'm not on Linux but perhaps you might hit a bump in the road given that current incarnations (year 2025) of OpenOffice and LibreOffice use different versions of the ODF standards. OpenOffice uses ODF format version 1.2 Extended (at best). LibreOffice uses ODF format version 1.4 Extended (at best). You might have some leeway in this by adjusting LibreOffice to suit ODF version used by OpenOffice. But in doing that you're maybe tying-down LibreOffice to some extent.

Not sure of this myself — just a thought that you might want to turn over for yourself. This might be hazardous if you are thinking of using the same Calc file between the two suites.

Maybe others with more expertise might want to chip-in on this.

[andIF]

Thanks to Mr Programmer for insight to OpenOffice and LastUnicorn and pointing out possible problem with ODF versions. I may just experiment with this anyway. Am aware of row limit of just over a million per sheet, and my 2.5 million row spreadsheet is spread over 8 sheets but I neglected to say that these are separate file names and not eight sheets running in one single file so the number of rows actually works. Regarding my comment about the the time taken to save big spreadsheet files and the fact that I would like to be typing up some text file in the mean time while waiting - I just tried AbiWord that seems to load ODT file perfectly, although I have not looked into this in any depth yet so don't know if there might be any problems with this. My Intel chip has 6 cores so 12 CPUs, 2 terabytes, memory 32gig, and I have (on system monitor) watched TimeStamp switch on to see 8 CPUs activate to 90% to 100% each, to back up my system; at what appears to be incredible speed. I know TimeStamp is just a copying task but I can imagine it still has complexities to dealt with. I just wish that this level of multithreading was available in the Office programs instead of just one core. I am a complete layman and know nothing about programming, so please forgive my ignorance.

[LastUnicorn]

As chance would have it, The Document Foundation put out a very recent blog piece: What’s new in ODF 1.3 and 1.4. It might be of interest here.

[andIF]

LastUnicorn - Thanks for the info about ongoing development