https://bugs.documentfoundation.org/show_bug.cgi?id=99789
Bug ID: 99789
Summary: Formula does not calculate due to prior Format Cell as
Text, despite Format Cell as Number
Product: LibreOffice
Version: 5.1.1.3 release
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Details : When a cell is formatted as category Text, it can never again
calculate a formula automatically. Even if you reformat it as Numbers, or Date,
or whatever, it refuses to calculate.
Reproducible? : Yes. Confirmed.
Steps to Reproduce :
1. File / New / Spreadsheet or Ctrl-N to open new spreadsheet.
2. Select cell(s).
3. Press Ctrl-1 to format cell.
4. Choose Category "Text" and click OK.
5. Enter "=SUM(7,5)" or "=sum(7,5)" in a text cell (without quotes).
6. Select cell(s) with formula(e).
7. Press Ctrl-1.
8. Choose Category "Numbers" and click OK.
Actual Results : The text remains as it was, e.g., =SUM(7,5) .
Expected Results : The text formula instantly converts to the result of the
calculated formula (12).
Additional Information : A couple times, I was able to choose Data / Calculate
/ Formula to Value, and got the Expected Results. This did not always work,
however. At other times, Formula to Value was greyed out.
Copy/Paste Only/Formula (or Paste Special) doesn't seem to produce the Expected
Results, either.
My only data is from this system, using Windows 10 (64 bit, running on AMD
A10-7800). I've searched for duplicates, to no avail.
--
You are receiving this mail because:
You are the assignee for the bug._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
