Problem description: When placing an apostrophe at the beginning of a cell where text or an = sign follows it, the apostrophe should be hidden. Steps to reproduce: 1. Open a new calc document 2. Type the following into three different cells (minus speech marks): "'123" "'=SUM(1,2)" and "'text" Actual behavior: You see this cell layout: 123 '=SUM(1,2) 'text Expected behavior: You see this: 123 =SUM(1,2) text Operating System: Windows XP Version: 4.0.2.2 release
seems related to the locale. I have a Dutch locale, thus a comma as decimal searator Type -> Visible result '77,7 77,7 '77.7 '77.7
Well, I'm on en-GB here, so not sure about that. Should this go on as an MAB or is it not that critical?
I cannot reproduce on Windows XP SP3 32-bit with LibO 4.0.2.2
Not a bug. The ' text enforcer preceding numeric data leads to the numeric data being entered as text instead of number. With any other data it is part of the data.
I think it's a bug or it's a change not documented. In any spreadsheet (Excel and OpenOffice for example) by prefixing the character ' into a cell means that you are going to insert a text field in that cell. There are some examples where you might need to write a text field like =321 (not a formula) JAN (not the month that is affected by the sort lists)
(In reply to comment #5) > I think it's a bug or it's a change not documented. What change?
(In reply to comment #6) > (In reply to comment #5) > > I think it's a bug or it's a change not documented. > > What change? I'm sorry, I'm not English. I wanted to say something like a "new" undocumented feature.
But that is no change, there is no new undocumented feature, it works like this since ages and was the same in OOo.