On 09/24/2016 03:19 PM, Larry Evans wrote:
On 01/07/2016 11:23 AM, Harv wrote:
Please ignore this note. I found the problem.
Please enlighten us. I'm just now having a similar problem.\
I've tryed =TEXT(b3,"###.##") and just the formula appears in the cell.
I've tried =ABS(b3) and just the formula appears in the cell.
I'm guessing there's some switch to change from displaying formula
to displaying result; however, I've no clue where to look :(
It finally dawned on me that the column was formatted as Text.
When that was changed to Category=All, Format=General, things
started working.
I don't know how, but there should be some way to hint to
the user what to do when a cell which looks like a formula
is not a formula.
-regards,
Larry
--
To unsubscribe e-mail to: [email protected]
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/
All messages sent to this list will be publicly archived and cannot be deleted
