> 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+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ Privacy Policy: http://www.documentfoundation.org/privacy
