https://bugs.documentfoundation.org/show_bug.cgi?id=168088
Bug ID: 168088
Summary: Cannot change cell formula
Product: LibreOffice
Version: 24.8.7.2 release
Hardware: x86-64 (AMD64)
OS: Linux (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
When editing a formula, the formula irreversibly reverts to a text string.
Keyword: EDITING
Steps to Reproduce:
1. Create a new Calc document
2. In cell A1 type: =NOW()
3. Select cells A1 to F6
4. Click Format >> Autoformat styles...
5. Select Box List Blue
6. Click OK
7. Select cell A1
8. Press F2 to edit the cell
9. Change the cell contents to: =TEXT(NOW(), "dd-mmm-yyyy")
10. Press Enter.
Actual Results:
The cell shows the literal text: =TEXT(NOW(), "dd-mmm-yyyy")
Expected Results:
Cell contents show the current date.
Reproducible: Always
User Profile Reset: No
Additional Info:
Not change a formula for a text string. There doesn't seem to be a way to
remove any leading ' character either.
Version: 24.8.7.2 (X86_64) / LibreOffice Community
Build ID: 480(Build:2)
CPU threads: 12; OS: Linux 6.16; UI render: default; VCL: gtk3
Locale: en-CA (en_CA.UTF-8); UI: en-US
24.8.7-5
Calc: CL threaded
--
You are receiving this mail because:
You are the assignee for the bug.
