Re: [libreoffice-users] Cannot make formula work

> The reason why I asked is that if you enter a formula into a cell that
> is formatted as text, that formula will end up as simple text. It
> doesn't matter if you had copied the formula from some other cell's
> content or if you write it by hand.

Sorry, I don't agree with you.

One thing is what you type in the formula bar.
A different one s how you instruct the cell to diplay its content: this 
last one is done via formatting choice.

If you insert a formula in the formula bar, that will always be 
interpreted as a formula, regardless the formatting choice.

The problem may arise is you enter the formula in the formula bar, 
inserting a single apex in front of it: these way you are telling LO 
that what you typed is not a formula, but simple text, regardless the 
formatting choice.

Only after you confirm the input in the formula bar, LO tries to format 
is in accordance with your formatting choice.

> There will be a difference if you copy a cell to another one. Then the
> references will be adjusted. So I think that you simply copied the cell
> content and produced simple text.

Right.

You can mitigate this issue by using absolute references for ranges, but 
this could not be what you desire.

-- 
Gabriele Bertolucci


-- 
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