User-Agent: Mozilla/5.0 (Windows NT 6.1; rv:41.0) Gecko/20100101 Firefox/41.0 Build Identifier: LibreOffice 5.0.1.2 (WIN) && 4.3.7.2 (LINUX) [Intro: English isn't my native language && I don't know the correct descriptions/menue entries as I use the german Version!] If I want to give a cell a 'special' format based on the function `=JETZT()` (NOW??) the result isn't as expected nor is it as written in LibreOffice-Help. I want to give the cell the (german!) format "JJMMTT-ssmm" which _should_ be YEAR-MONTH-DAY--SECOND-MINUTE the result ist *always* YEAR-MONTH-DAY--SECOND-MONTH !!?? (plz don't ask WTF/WTH ... -- it is required for an "identifier" of an report!) Reproducible: Always Steps to Reproduce: NN (see above!?) (happens under Windows && happens under Linux) Expected Results: As I know that "... it is working in E****!" doesn't mean that E**** is always working correct: IMHO is this something that /should/ be corrected (for the need of interoperability?). Especially as HELP shows ...minutes as 0-59 m ...minutes as 00-59 mm ...seconds as 0-59 s ...seconds as 00-59 ss [Information automatically included from LibreOffice] Locale: de Module: SpreadsheetDocument [Information guessed from browser] OS: Windows (All) OS is 64bit: no Reset User Profile?No
Please attach a sample document and then set the bug back to UNCONFIRMED. Thanks Also exclamation marks, WTF, etc... are entirely unhelpful and don't motivate anyone to work on your bug. Personal suggestion is to refrain from the extraneous punctuation/words and just stick to the issue in a clear and concise manner. Thanks
Created attachment 120116 [details] Example file with comments
Not specific to German but for all locales having twice the M code (for month and minute). Pretty all "Latin alphabet" language except Finnish... Happens when "mm" is not preceded by "hh" or followed by "ss". Surprisingly DDMMYY-SS[MM] showd the minutes (not month) but unfortunely show also the brackets...
Additional info: ~~~~~~~~~~~~~~~ Version: 5.1.0.3 Build-ID: 5e3e00a007d9b3b6efb6797a8b8e57b51ab1f737 CPU Threads: 4; OS Version: Windows 6.2; UI Render: default; Gebietsschema: de-DE (de_DE) ~~~~~~~~~~~~~~~ Problem still exists. -- Greetings from Germany
(In reply to GerardF from comment #3) > Not specific to German but for all locales having twice the M code (for > month and minute). Pretty all "Latin alphabet" language except Finnish... > > Happens when "mm" is not preceded by "hh" or followed by "ss". That's right. Simply enter mm as format, and it is recognized as month and not minutes. Simplest steps to reproduce: 1. Format > Cells > Number 2. Enter mm as format 3. OK 4. Format > Cells > Number Actual behavior: Format has been changed to MM Expected behavior: Format should be kept to what user entered mm
Code pointer: http://opengrok.libreoffice.org/xref/core/svl/source/numbers/zforscan.cxx#ScanType It seems that same key is used for M or m and MM or mm.
Laurent Balland-Poirier committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=c9ed6e832213129cc579c1c309ce9dbd3593c57a tdf#95339 Extend test to distinguish minute/month It will be available in 5.2.0. The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Laurent Balland-Poirier committed a patch related to this issue. It has been pushed to "libreoffice-5-1": http://cgit.freedesktop.org/libreoffice/core/commit/?id=d31f8efabd895ae0f14ae64e6caf1cfc78bf53a5&h=libreoffice-5-1 tdf#95339 Extend test to distinguish minute/month It will be available in 5.1.4. The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Laurent Balland-Poirier committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=93874236610dd50a46b6db229e022ae364af582a tdf#97835 tdf#61996 tdf#95339 Add qa unit test It will be available in 5.3.0. The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.