From 7d08444f187ddea8a983565fc2c7fb8b2a38176c Mon Sep 17 00:00:00 2001 From: Olivier Hallot Date: Tue, 17 Oct 2023 17:14:51 -0300 Subject: tdf#155876 UI cmds Calc (04) + refactoring + Edit - cell edit mode Change-Id: I43bcbd6f0467f0e923450a3b74b197b7166db15c Reviewed-on: https://gerrit.libreoffice.org/c/help/+/158095 Tested-by: Jenkins Reviewed-by: Olivier Hallot --- source/text/scalc/00/00000402.xhp | 6 ++++++ source/text/scalc/01/SetInputMode.xhp | 36 +++++++++++++++++++++++++++++++++++ source/text/scalc/main0102.xhp | 1 + 3 files changed, 43 insertions(+) create mode 100644 source/text/scalc/01/SetInputMode.xhp (limited to 'source/text/scalc') diff --git a/source/text/scalc/00/00000402.xhp b/source/text/scalc/00/00000402.xhp index 670c386a3a..5fc250c4ff 100644 --- a/source/text/scalc/00/00000402.xhp +++ b/source/text/scalc/00/00000402.xhp @@ -154,6 +154,12 @@ Choose Edit - Select - Select Visible Columns. +
+ + Choose Edit - Cell Edit Mode. + + F2 +
Choose Insert - Headers and Footers. Choose Insert - Headers and Footers - Header and Footer tabs. diff --git a/source/text/scalc/01/SetInputMode.xhp b/source/text/scalc/01/SetInputMode.xhp new file mode 100644 index 0000000000..1c4d0418ae --- /dev/null +++ b/source/text/scalc/01/SetInputMode.xhp @@ -0,0 +1,36 @@ + + + + + + + Cell Edit Mode + /text/scalc/01/SetInputMode.xhp + + + + + + cell edit mode + F2;cell edit mode + +
+

Cell Edit Mode

+ Enable direct cell content editing. +
+
+ +
+ The cell edit mode enabled on a cell with formula displays the formula expression instead of the result of the formula calculation. + In this mode, references to other cells are displayed in colors and the referenced cells have their borders highlighted with the same color. The highlighted cell displays handles on the corners to allow by dragging the handles, to extend the highlighted reference. The formula is automatically updated with the expression of the reference. + For example, a cell with formula =A1+B1 displays A1 in color 1 and B1 in color 2 (colors are defined internally). The cell A1 is highlighted in color 1 and B1 is highlighted in color 2. + Press Enter to end the cell edit mode. + + diff --git a/source/text/scalc/main0102.xhp b/source/text/scalc/main0102.xhp index 4e83358605..74c251bae1 100644 --- a/source/text/scalc/main0102.xhp +++ b/source/text/scalc/main0102.xhp @@ -46,6 +46,7 @@ + -- cgit