I am running the latest flatpak on Linux Mint (updated today). All seems fine, but I have noticed that the spreadsheet desktop editor runs MUCH more slowly than LibreOffice when calculating a large number of SUMIF formulae.
To see this, simply create 2 columns and 10,000 rows. The first column simply stores a sequential number from 1 to 10,000; the second has a SUMIF running down column A, with the criteria that the number is less than 5000.
OnlyOffice handles this fine, but it takes about 10 seconds to calculate on my i3 8100. Using LibreOffice, it takes about 1 second.
I’m not complaining,.I hasten to add! I love OnlyOffice. I just wondered if there is a problem with my setup or something obvious that I could do to improve performance with large files like this?
I have tested described scenario in the manner as above:
Created new spreadsheet;
Used macro above to populate 10000 cells in the column A with incremental values:
let doc = Api.GetActiveSheet();
for (let i = 0; i < 10000; i++) {
doc.GetRangeByNumber(i, 0).SetValue(i)
}
In the cell C1 added formula =SUMIF(A1:A10000,">5000").
Even on a low-end VM the calculation took a split-second to complete. Can you run the same test on your device to confirm that it produces the same delay?
Thanks for replying. The key difference is that I added the formula "SUMIF(A1:A10000, “>5000”, A1:10000) in every cell in the range C1:C10000, not just in cell C1.
That made it slow down a LOT compared to LibreOffice, which still manages the formula in a split second.
Can you try this and confirm please? If helpful, I could upload a file?
I have tried simplifying the workflow with macros for both Desktop Editors and LibreOffice. Here are the scripts:
Desktop Editors (in JS):
(function()
{
let doc = Api.GetActiveSheet();
for (let i = 0; i < 10000; i++) {
doc.GetRangeByNumber(i, 0).SetValue(i)
}
for (let i = 0; i < 10000; i++) {
doc.GetRangeByNumber(i, 2).SetValue('=SUMIF(A1:A10000,">5000")')
}
})();
LibreOffice (in compatible VBA):
Sub Sample()
Dim oDoc As Object
Dim oSheet As Object
Dim cellArr As Long
Dim oCell As Object
oDoc = ThisComponent
oSheet = oDoc.Sheets.getByName("Sheet1")
For cellArr = 0 To 10000
oCell = oSheet.getCellByPosition(0, cellArr)
oCell.Value = cellArr
Next cellArr
For cellArr = 0 To 10000
oCell = oSheet.getCellByPosition(2, cellArr)
oCell.Formula = "=SUMIF(A1:A10000;"">5000"")"
Next cellArr
End Sub
The results in completion are quite similar. Also, manually entering iterative values in the column A and setting up a formula in the column C did not produce any significant difference in my case.
I believe it’d be useful. You can upload a video to any cloud storage and share a link to it for review. As soon as you get next trust level, you will be available to attach videos and files to your reply. For more information please refer to my post here: Community rules - #14 by Constantine
Sorry for the delay in preparing a video. I’ve simplified the test down to merely copying a formula that adds 1 to the previous result, down 10,000 rows. It works instantly on LibreOffice but takes c. 13 seconds in OnlyOffice Desktop Editor. Is this normal or something specific to me?
I’m running OnlyOffice as a flatpak in Linux Mint (i3 8100, 8GB RAM).
PS - I’ve also tried this in FreeOffice. It works instantly, like LibreOffice. So it does seem to be a problem that is specific to OnlyOffice. Do you see the same issue when you follow the steps I took in the video please?
I’ve now added a video that adds a more complex formula (SUMIF) down 10,000 rows, comparing OnlyOffice to FreeOffice. FreeOffice recalculates almost instantly. OnlyOffice freezes for 30 seconds, making it almost unusable.
Please could you confirm if this is a general issue with OnlyOffice, or something specific to my Linux Mint setup? I’m struggling to believe this is normal performance, because if it is, the spreadsheet module is essentially unusable for anything except very small, basic tasks.
If that is the case, it would be a huge shame. I love OnlyOffice, but if I can’t use it for larger spreadsheets, its use to me is greatly diminished
Hi - does anyone else see these performance issues please? I just really want to know if it’s an “OnlyOffice” issue or just something specific to my PC, and I have no other way to test it. Thanks!
I’ve also tested it on my machine (Windows 11 + AMD Ryzen 5 7600X) and didn’t notice any noticeable delay when recalculating the formulas. So the slowdown seems to be more pronounced on certain configurations (like your Linux Mint + i3 setup).
I’ve passed your full info (including the configuration details and videos) to the development team. They’re very grateful for the clear reproduction steps — it really helps a lot!
Thanks for the reply. Ironically, today I finally managed to get hold of a laptop to test OnlyOffice’s desktop editor spreadsheet performance, to see if it is as poor as my i3-8100 setup.
The laptop is running Zorin OS and the OnlyOffice version is again 9.3.1.8 (flatpak). Its CPU is an Intel® Core™ i7-8550U CPU @ 1.80GHz (boosts to 4GHz). It has 4 cores and 8 threads in total.
The performance is essentially the same as on the i3. I’ve been working on a spreadsheet prototype of a “match engine” for a football game. There are a lot of cells - 90 columns * 300 rows - but the formulae are not especially complex. Calculation is actually not too bad, but copying lots of cells at one time is incredibly painful. I had to give up and switch to LibreOffice, which does everything instantly.
It’s all very odd. I really hope you can fix it and will watch this thread with great interest.
PS - According to Google, the Ryzen 5 7600X is 275% faster for office tasks than an i3-8100. So you would expect it to be a lot faster in any test. In addition, your PC is running Windows, unlike my PC. I’d really like to know what performance you get if you run it on a comparable Linux PC to my i3-8100?
Thanks for the extra details and the new test on the i7 laptop — noted.
I’ve added all your information to the internal disscussion.
Unfortunately, I don’t have the possibility right now to set up a second Linux system on my machine for direct comparison, but I’ve passed everything to the QA/testing team so they can check it on similar hardware.
I’ll keep you updated in this thread as soon as we have more findings or improvements.
Appreciate your continued testing and feedback!
The delay in pasting just a few cells is awful. As a result, OnlyOffice is rated as the second worst spreadsheet available on Linux. Which - given the awful state of Linux office suites - is almost impressive, in a completely depressing way.
