Re: [libreoffice-users] Re: Formulas in text instead of result - LO Calc

Hi Brian,

Thanks again for your help.


On Fri, 13 Sep 2013 19:33:48 +0100
Brian Barker <b.m.barker@btinternet.com> wrote:

> At 20:09 13/09/2013 +0200, Paul Steyn wrote:
> > There still seems to be a bug in 4.1.1.2 in that entering a formula 
> > into a cell formatted as text gives you a blank cell until you make 
> > a change to the spreadsheet (add a column, change the cell format, 
> > something like that), and then like magic the formula value suddenly 
> > appears in the cell.
>
> Is this just a display problem?  What happens, for example, if you 
> minimise and then restore the Calc window: does that do anything?
Yep, just a display problem. Minimising and restoring Calc makes it
show up.

> > I see that preceding formulae with "'" makes the "'" appear in the 
> > cell, irrespective of the cell format. Seems this is no longer a 
> > text mark character. I'm sure it used to be, or is in Excel, as I've 
> > used it before.
>
> Surely it still works?  There are a couple of points that may be 
> confusing you here.
>
> o If you have custom ("smart") quotes set in your AutoCorrect 
> options, the apostrophe you type will be converted into an open 
> single quote and will not fulfil its intended function.  To correct 
> this, either disable custom quotes or - more easily - just go to Edit 
> | Undo (or Ctrl+Z) immediately after typing the apostrophe: this will 
> undo the autocorrection to leave the intended apostrophe.
Hitting ctrl-z right after entering it doesn't change it, it removes
all the typing. The menu item has "Undo: Input", so it doesn't look
like an autocorrect is happening. I don't actually know where to set
this smart quotes you speak of. I had a look under AutoCorrect Options,
but nothing obvious leapt out at me. The Localized Options tab has
check boxes to replace single and double quotes, but the double quotes
one is ticked and the single quotes one is unticked for me.

Of course, when I try it with 0.00, it works. Entering 0.00 on its own
changes the value to just 0 (both in the cell and in the input line),
but entering '0.00 shows 0.00 in the cell ('0.00 is kept in the input
line). So it appears to be the way to enter numbers as text, but
doesn't perform the same function for formulae. Strange.

Regards

Paul

-- 
To unsubscribe e-mail to: users+unsubscribe@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/
All messages sent to this list will be publicly archived and cannot be deleted