https://bugs.documentfoundation.org/show_bug.cgi?id=99789
--- Comment #15 from Eike Rathke <[email protected]> ---
For clarification: if a cell is already formatted to Text, any new cell input
is forced to text content, no number, date or formula recognition is attempted.
This is on purpose and works similar across major spreadsheet applications.
As changing the cell format does not change the cell content, to force a new
interpretation of content as formula first select the cell range in question,
then change the cell format to General, then, with the selection still in
place, use Find&Replace (Ctrl+H):
Find: =
Replace: =
verify that under Options the Selection only is checked
and hit Replace All.
--
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
