Ask LibreOffice - RSS feedhttps://ask.libreoffice.org/en/questions/Questions and answers for LibreOfficeenMon, 03 Apr 2017 07:32:13 +0200Show total when selecting cells in Calc?https://ask.libreoffice.org/en/question/68114/show-total-when-selecting-cells-in-calc/Hello all,
I have a calc sheet with a couple of columns that hold different numbers.
I'm selecting an cell outside the filled columns and press the Sum button which gives me the possibility to select multiple cells on one column.
The question is if is there any functionality that I don't know so when I'm selecting the cells also to see the total, like an tooltip or in status bar, like an realtime total of the selected cells so far? If I hit enter the total will be shown in the cell, but until then I see just the SUM formula and the number of the row/columns.
This is helpful for me because I have to add certain rows and to have an total of certain value, which now I only see after I've hit enter on the Sum function.Tue, 12 Apr 2016 17:11:35 +0200https://ask.libreoffice.org/en/question/68114/show-total-when-selecting-cells-in-calc/Answer by erAck for <p>Hello all,</p>
<p>I have a calc sheet with a couple of columns that hold different numbers.
I'm selecting an cell outside the filled columns and press the Sum button which gives me the possibility to select multiple cells on one column.
The question is if is there any functionality that I don't know so when I'm selecting the cells also to see the total, like an tooltip or in status bar, like an realtime total of the selected cells so far? If I hit enter the total will be shown in the cell, but until then I see just the SUM formula and the number of the row/columns.
This is helpful for me because I have to add certain rows and to have an total of certain value, which now I only see after I've hit enter on the Sum function.</p>
https://ask.libreoffice.org/en/question/68114/show-total-when-selecting-cells-in-calc/?answer=68115#post-id-68115The status bar has an area left of the zoom slider where the result of a few predefined functions with selected cells can be displayed, among them is SUM (e.g. Sum=0 displayed). Right mouse click on that status bar area pops up a menu with functions to choose from. Note however that the result is only updated if a cell is not in edit mode, i.e. does not display results while editing a formula.
Tue, 12 Apr 2016 18:04:26 +0200https://ask.libreoffice.org/en/question/68114/show-total-when-selecting-cells-in-calc/?answer=68115#post-id-68115Comment by bp for <p>The status bar has an area left of the zoom slider where the result of a few predefined functions with selected cells can be displayed, among them is SUM (e.g. Sum=0 displayed). Right mouse click on that status bar area pops up a menu with functions to choose from. Note however that the result is only updated if a cell is not in edit mode, i.e. does not display results while editing a formula.</p>
https://ask.libreoffice.org/en/question/68114/show-total-when-selecting-cells-in-calc/?comment=91963#post-id-91963Just note:
Status bar can be switched off display - go to View / Status Bar - to turn it on.Mon, 03 Apr 2017 07:32:13 +0200https://ask.libreoffice.org/en/question/68114/show-total-when-selecting-cells-in-calc/?comment=91963#post-id-91963Answer by Scieri for <p>Hello all,</p>
<p>I have a calc sheet with a couple of columns that hold different numbers.
I'm selecting an cell outside the filled columns and press the Sum button which gives me the possibility to select multiple cells on one column.
The question is if is there any functionality that I don't know so when I'm selecting the cells also to see the total, like an tooltip or in status bar, like an realtime total of the selected cells so far? If I hit enter the total will be shown in the cell, but until then I see just the SUM formula and the number of the row/columns.
This is helpful for me because I have to add certain rows and to have an total of certain value, which now I only see after I've hit enter on the Sum function.</p>
https://ask.libreoffice.org/en/question/68114/show-total-when-selecting-cells-in-calc/?answer=68117#post-id-68117 Thank you for the response, that will do the trick :)Tue, 12 Apr 2016 18:29:37 +0200https://ask.libreoffice.org/en/question/68114/show-total-when-selecting-cells-in-calc/?answer=68117#post-id-68117