Formulae not working in Calc

English
#1

Formulae will not work for me in Calc.
e.g.
I enter =SUM(C61-C72) in a cell. When I move from that cell, the answer is not there, but the cell I have moved the cursor to (G63 in this example) is entered at the end of the formula in the original cell into which I entered the formula:

=SUM(C61:C72)G63

Alternatively I can highlight the cells to be sumated, click the Sigma symbol and use this SUM function to add up cells it works and the cell under the column of cells contains the sum of the figures in the cells and the input line contains =SUM(C61:C72)

Version: 24.8.2.1 (X86_64) / LibreOffice Community
Build ID: 0f794b6e29741098670a3b95d60478a65d05ef13
CPU threads: 8; OS: Windows 11 X86_64 (10.0 build 22631); UI render: Skia/Raster; VCL: win
Locale: en-GB (en_GB); UI: en-GB
Calc: threaded

Edition Windows 11 Home
Version 23H2
Installed on ‎23/‎10/‎2022
OS build 22631.4317
Experience Windows Feature Experience Pack 1000.22700.1041.0

#2

arrow
use Tab or Enter to validate your cell.

or F2 to modify the text of your formula, the arrow keys will move the cursor within.

2 Likes
#3

And just to add a little context - this is needed because when you are creating/editing a formula, the assumption is that using the mouse or arrow keys will be for the purpose of adding a reference to one or more cells into that formula. It’s much easier to do so that way than it is to have to visually find the row/column and then type that in.

Enter and Tab on the keyboard, and the checkbox button in the formula bar, specifically indicate that you are finished with editing that formula and are ready to select something else in the sheet.

#4

nope. arrow keys don’t select in Cell Edit Mode

Q: if someone has an official reference for the “Creating mode”, welcome :wink:

Side note : Selecting Multiple Cells

#5

In Formula Cell Edit Mode after having pressed F2 once more, (shift+) arrow keys and mouse select, same as when creating a formula cell. F2 again toggles.

1 Like
#6

documented somewhere ?

(called " References Edit Mode " here : Calc/Cell Edition Modes - Apache OpenOffice Wiki )

#7

Diolch, thankyou. Sorted.

Impressum (Legal Info) | Datenschutzerklärung (Privacy Policy)   Content on this site is licensed under a Creative Commons Attribution Share Alike 3.0 license.