https://bugs.documentfoundation.org/show_bug.cgi?id=156676
Bug ID: 156676
Summary: Spreadsheet: converting formulas formatted as text to
show formula result
Product: LibreOffice
Version: 7.3.7.2 release
Hardware: x86-64 (AMD64)
OS: Linux (All)
Status: UNCONFIRMED
Severity: enhancement
Priority: medium
Component: Documentation
Assignee: libreoffice-bugs@lists.freedesktop.org
Reporter: p.wri...@kcl.ac.uk
CC: olivier.hal...@libreoffice.org
Description:
The documentation should explain how to deal with a formula entered as text
that the user wants to display the result. There are several cases where the
user might end up in this position unwittingly. Even if done deliberately, it
is not obvious how to reverse it.
There are two clues in the current docs, but it is not immediately obvious how
they apply to this problem and they would not come up on a search:
1. The entry for "Formatting Numbers as Text" explains that changing the
formatting does not apply to numbers already entered, only when they are edited
or reentered. The same applies to formulas, so changing a formula as text from
text to number format will not have the immediate effect of changing the cell
content to the formula result.
2. The entry for "Entering a Number with Leading Zeros" describes how to force
Calc to modify all the cells and thus update the formatting. A similar approach
for formulas would be to find and replace "=" with "=".
It would be useful if there was an entry on converting cells with formulas
formatted as text to show the formula results. This could also cover the
View->Show formula (CTRL+`) option.
Steps to Reproduce:
This relates to documentation, so n/a.
Actual Results:
This relates to documentation, so n/a.
Expected Results:
This relates to documentation, so n/a.
Reproducible: Always
User Profile Reset: No
Additional Info:
Version: 7.3.7.2 / LibreOffice Community
Build ID: 30(Build:2)
CPU threads: 16; OS: Linux 5.19; UI render: default; VCL: gtk3
Locale: en-GB (en_GB.UTF-8); UI: en-GB
Ubuntu package version: 1:7.3.7-0ubuntu0.22.04.3
Calc: threaded
--
You are receiving this mail because:
You are the assignee for the bug.
