Summary: | EDITING: interpretation of date input | ||
---|---|---|---|
Product: | LibreOffice | Reporter: | Elmar <roberg> |
Component: | Spreadsheet | Assignee: | Not Assigned <libreoffice-bugs> |
Status: | NEW --- | QA Contact: | |
Severity: | normal | ||
Priority: | medium | CC: | jbfaure |
Version: | 4.3.0.4 release | ||
Hardware: | Other | ||
OS: | Linux (All) | ||
Whiteboard: | BSA PossibleRegression | ||
i915 platform: | i915 features: |
Description
Elmar
2014-08-06 04:31:41 UTC
Did you try to config the date acceptance patterns in Tools > Options > Language settings > Languages ? Set status to NEEDINFO. Please set it back to UNCONFIRMED once you have provided requested informations. Thank you for your understanding. Best regards. JBF Date acceptance patterns looks like this: Y/M/D; M/D; D.M.Y; D.M; Y-M-D; M-D; (I have added spaces for readability) I cannot add a pattern to enter 6aug (I do this in Excel and found that it worked in LO in the previous versions) Also, if I enter a date (6 Aug) as 6.8 displays as 05/01/1900 19:12:00 entry of 8-6 (M-D) for 6 Aug displays in edit bar as 08/06/2014 i.e 8 Jun) entry 14-8-6 (Y-M-D) displays in edit bar as 14/08/2006 ( but is actually 8 Jun) i have to enter 2014-8-6 in order to get 6 Aug entry 5.7.14 or 5.7.2014 displays as text input what am I doing wrong? (In reply to comment #0) > I used to be able to input a date in the format dMMMyy (e.g. 6aug or 6aug14) > - it would then convert the text to date. This issue has been independently reported in this forum thread: http://ask.libreoffice.org/en/question/38501/ It appears to be a regression in behaviour from v4.2.6.2. Under GNU/Linux using: - v4.3.0.4 Build ID: 62ad5818884a2fc2e5780dd45466868d41009ec0 - v4.4.0.0.alpha0+ Build ID: aa0e3701aad1a8a955773e869d9a6b59eac51e72 TinderBox: Linux-rpm_deb-x86_64@46-TDF, Branch:master, Time: 2014-08-10_07:00:01 ... entering 03SEP into a cell with default format or with a pre-existing format code of DDMMM results in "03SEP" displayed and treated as text by formula. Under v4.2.6.2 the results of entry are: - 03/09/14 (default cell format for en-AU locale) - 03SEP (DDMMM format code) ... both are treated as dates by formula referencing the cell. Status set to NEW. |
Use of freedesktop.org services, including Bugzilla, is subject to our Code of Conduct. How we collect and use information is described in our Privacy Policy.