Re: [libreoffice-users] Cannot make formula work

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: users+unsubscribe@global.libreoffice.org
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