SUM which is located in status bar, on the right side (where you can choose between sum, average, count, etc) is not working correctly on some PCs I have.
At my workplace I have winXP SP3 with Libre Office Version: 4.2.5.2 :
When I select any cell with multiple sheets selected - it shows me the sum of that cell from every sheet. This is super useful behaviour.
At my home, with latest (as of 25/2/2015) version of Libre Office and windows 8.1 fresh install (also tried windows 10 tech preview) it counts the sum only on a single sheet, ignoring the rest of them.
Only difference between OS version that I could think of - XP machine has Java installed. I could’ve just installed Java on those home machines but I RATHER NOT, if it can be avoided.
For now I know I can make SUM(Sheet1.C33:Sheet3.C33) and etc, but thats not as nearly useful.
Any insights? Is it Java?