Hi Gabriele,
one thing that could have been misunderstood. I wrote that there is only
one way to get a formula working when you enter the formula string into
a text cell: change the format to some number format and eliminate the
single quote.
Of course the other way round is possible. If there already is a formula
in a number cell you can change the cell format to text and so only
format the formula's output.
But Thomas evidently had inserted the formula string into a text cell.
So I didn't mention all the rest.
Happy Easter
Volker
Am 17.04.25 um 13:59 schrieb Gabriele Bertolucci:
First test:
A1: format: Number (default)
input: 2
shows: 2
B1: format: Number
input: the string "=A1" (without the quotes)
shows: 2
Me too. Expected.
Second test:
C1: format changed to Text
input: the string "=A1"
(without the quotes, manually or pasted from the clipboard)
shows: =A1
format changed to Number
shows: '=A1
change the content to =A1
shows: 2
Me too. Completely unexpected.
I need to reset myself......
--
To unsubscribe e-mail to: [email protected]
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy
