Summary: | EDITING: Apostrophe ( ' ) text enforcer shows inside the cell | ||
---|---|---|---|
Product: | LibreOffice | Reporter: | crazyskeggy |
Component: | Calc | Assignee: | Not Assigned <libreoffice-bugs> |
Status: | CLOSED NOTABUG | ||
Severity: | major | CC: | cno, crazyskeggy, erack |
Priority: | high | ||
Version: | 4.0.2.2 release | ||
Hardware: | Other | ||
OS: | All | ||
Whiteboard: | BSA | ||
Crash report or crash signature: | Regression By: |
Description
crazyskeggy
2013-04-15 16:27:34 UTC
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. |