[Libreoffice-bugs] [Bug 116184] Date acceptance pattern can interfere with entering decimal numbers

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=116184

Oliver Brinzing <oliver.brinzing at gmx.de> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |oliver.brinzing at gmx.de

--- Comment #27 from Oliver Brinzing <oliver.brinzing at gmx.de> ---
i can confirm this too.
for convenience we added "D." to Date acceptance patterns.
this worked by default with AOO 4.1.5, but with LO it has
some side effects.

steps to reproduce:
- Menu Tools/Options/Language Settings/Languages
  -> Locale setting: "German (Germany)"
  -> add to Date acceptance patterns: "D."
- create new spreadsheet
- enable Menu "View/Value Highlighting"
- cell A1, enter: 1.
  -> Date: 01.04.19
- cell B1, enter: -1.234,56
  -> Text: -1.234,56
- Cell B2, enter: =Value(B1)
  -> Err:522

now remove "D." from Date acceptance patterns and 
- create new spreadsheet
- cell A1, enter: 1.
  -> Text: 1.
- cell B1, enter: -1.234,56
  -> Value: -1234,56
- cell B2, format as Text @ and enter: -1.234,56
- cell B3, enter: =Value(B2)
  -> Value: -1234,56

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20190425/13e8c57f/attachment.html>