Ask Your Question
1

How to make the amount in columns?

asked 2018-06-01 11:45:15 +0100

DimkaInc gravatar image

Hello! In previous versions (earlier than 5.x, for ex., 4.2.5), there was a convenient feature: selecting several rows and columns with figures and empty line at the bottom of selection, and then clicking the "sum" button (on the buttons panel), gave the total for each column in selection at the bottom line (see Example 1 below). Now these totals become increased by the total, calculated for the column from the left of the current one (see Example 2).

Is it possible to get the totals as before, only by the columns?

Example 1 - Previous version

1   2   3
2   3   4
3   4   5
---------
6   9  12

Example 2 - Current version

1    2    3
2    3    4
3    4    5
-----------
6   15   27
edit retag flag offensive close merge delete

Comments

1

Works fine with Version: 6.0.4.2 (x64) Build ID: 9b0d9b32d5dcda91d2f1a96dc04c645c450872bf CPU threads: 12; OS: Windows 10.0; UI render: GL; Locale: ru-RU (ru_RU); Calc: CL

Mike Kaganski gravatar imageMike Kaganski ( 2018-06-01 11:55:42 +0100 )edit

what is your version of LibreOffice? I agree with Mike, it just works fine as you wrote

kompilainenn gravatar imagekompilainenn ( 2018-06-01 12:37:19 +0100 )edit

2 Answers

Sort by » oldest newest most voted
1

answered 2018-06-01 14:07:10 +0100

erAck gravatar image

There was a bug tdf#116215 in 5.4.x that was fixed for 5.4.7, 6.0.3 and 6.1/master. Please upgrade. To get the desired behaviour with the affected 5.4.x versions select only the cells in the row where the sum results are to be placed.

edit flag offensive delete link more
0

answered 2018-06-01 14:12:47 +0100

DimkaInc gravatar image

Thank you, Mike! My version of LibreOffice 5.4.4 was old. I've installed new version. It works!

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2018-06-01 11:45:15 +0100

Seen: 41 times

Last updated: Jun 01 '18