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
Thanks for the report. Olivier, where do you think such workarounds should live? References pages: https://help.libreoffice.org/24.2/en-US/text/scalc/guide/text_numbers.html https://help.libreoffice.org/24.2/en-US/text/scalc/guide/integer_leading_zero.html
Can't find any section in the documentation that covers this subject.