Ask Your Question

Status bar SUM not working across sheets properly. [closed]

asked 2015-03-10 12:43:08 +0200

pollat gravatar image

updated 2020-09-14 22:50:15 +0200

Alex Kemp gravatar image

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: : 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?

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2020-09-14 22:50:47.192177

3 Answers

Sort by » oldest newest most voted

answered 2016-11-03 19:52:22 +0200

erAck gravatar image

Filed as bug at tdf#103684.

edit flag offensive delete link more


Thank you very much for recognising the bug and fixing it too. I've downloaded 5.4.1 and the bug does seem to be fixed now. Thanks once again.

u81 gravatar imageu81 ( 2016-12-05 19:37:43 +0200 )edit

answered 2015-03-10 13:27:21 +0200

Lupp gravatar image

updated 2015-03-10 13:29:28 +0200

I don't use that facility on a regular basis, but just tried it with Win versions 3.6.5 (portable), 4.3.5 (portable) and 4.4.1 (installed under Win 8.1). Everyone behaves unchanged wheter or not I switch on Java. Only the one version from the 3.x series is beahving as you expect (with reserve). The 4.x versions only take in account the foreground sheet.

The reserve: Adding sheets to the multiselection or removing sheets from it will not correctly recalculate the SUM (or COUNT or whatever) for the preselected range. You have to select a range anew or change the view selection for the status bar ...

Can we reliably use features of that class (implemented without full responsibility in mind)? I personally much prefer non-existing features over pretentious ones.

edit flag offensive delete link more


Reading your answer inspired me to try 4.4.1 portable on XP machine and yes, it's not working, while 4.5.2 still does. So the problem lies in version number and not my setup.

pollat gravatar imagepollat ( 2015-03-10 16:25:57 +0200 )edit

answered 2016-05-10 18:09:11 +0200

u81 gravatar image

I think you'll get things working correctly up to version 4.2.8 but not thereafter. I have a related issue about copying values in cell A1 on 10 sheets from one file to 10 sheets on another file.

I'm still waiting for that to be attended to as well.

It's also a bug at

edit flag offensive delete link more


Which is completely not an answer to the original question.

erAck gravatar imageerAck ( 2016-05-10 19:01:14 +0200 )edit

Question Tools

1 follower


Asked: 2015-03-10 12:43:08 +0200

Seen: 537 times

Last updated: Nov 03 '16