[Libreoffice-bugs] [Bug 152877] Dates are getting formatted as dollar amounts and can't change
https://bugs.documentfoundation.org/show_bug.cgi?id=152877 --- Comment #5 from Stéphane Guillou (stragu) --- Using the en-US locale, I wasn't able to reproduce the date-to-currency issue with the following steps: 1) create a sheet in 6.x 2. add a date in MM/DD/YY format (which is automatically recognised as a date) 3. save 4. reopen in 7.x and use the date formatting button off and on (number format is expected when off) Versions I tried: file created in 6.0.0.3 or 6.4.7.2 -> opened in 7.3.7.2 or 7.4.6.2 Without an example file, it will be very difficult to figure out what the issue is. Lesline, what exactly did you see as a result in your tests? (Please keep in mind that Calc displaying a number when date formatting is turned off is an expected behaviour. Wrong behaviour would be dates displayed as dates in one version, dollars in another.) -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 152877] Dates are getting formatted as dollar amounts and can't change
https://bugs.documentfoundation.org/show_bug.cgi?id=152877 ady changed: What|Removed |Added See Also||https://bugs.documentfounda ||tion.org/show_bug.cgi?id=15 ||4286 -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 152877] Dates are getting formatted as dollar amounts and can't change
https://bugs.documentfoundation.org/show_bug.cgi?id=152877 keith hayden changed: What|Removed |Added Status|NEEDINFO|UNCONFIRMED Ever confirmed|1 |0 -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 152877] Dates are getting formatted as dollar amounts and can't change
https://bugs.documentfoundation.org/show_bug.cgi?id=152877 --- Comment #4 from keith hayden --- correction on previous comment where I said "Unfortunately, After I upgraded to 7.5" I meant to say "7.4.3". I have not tried any version since that. I had to stop using Calc and move to Google sheets because this bug made Calc totally unusable for what I needed it for. -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 152877] Dates are getting formatted as dollar amounts and can't change
https://bugs.documentfoundation.org/show_bug.cgi?id=152877 --- Comment #3 from keith hayden --- (In reply to eisa01 from comment #2) > So this would likely not be macOS specific > > It is also not a bug that spreadsheets store Dates as numbers, that's > standard behavior > > For the ods from 6.x series in 7.4.3, does that corruption still happen with > the new 7.5? > > If so, can you upload a sample document that shows fine in 6.x, but not in > 7.5? So not the document you may have saved in 7.5 I am aware and agree that storing the date as a number isn't unusual, but the displaying it as one is. Unfortunately, After I upgraded to 7.5, none of my ods files are correct, even when downgrading back to 6.x. So I no longer have a "document that shows fine in 6.x, but not in 7.5". Also, I didn't need to save the doc in 7.x for this to occur, simply had to open it in 7.x and it happened. After downgrading back to 6.x, it was happening there too. I even tried completely uninstalling and reinstalling, nothing worked anymore. -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 152877] Dates are getting formatted as dollar amounts and can't change
https://bugs.documentfoundation.org/show_bug.cgi?id=152877 eisa01 changed: What|Removed |Added OS|macOS (All) |All Status|NEW |NEEDINFO --- Comment #2 from eisa01 --- So this would likely not be macOS specific It is also not a bug that spreadsheets store Dates as numbers, that's standard behavior For the ods from 6.x series in 7.4.3, does that corruption still happen with the new 7.5? If so, can you upload a sample document that shows fine in 6.x, but not in 7.5? So not the document you may have saved in 7.5 -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 152877] Dates are getting formatted as dollar amounts and can't change
https://bugs.documentfoundation.org/show_bug.cgi?id=152877 QA Administrators changed: What|Removed |Added Whiteboard| QA:needsComment| -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 152877] Dates are getting formatted as dollar amounts and can't change
https://bugs.documentfoundation.org/show_bug.cgi?id=152877 Lesline changed: What|Removed |Added Status|UNCONFIRMED |NEW Ever confirmed|0 |1 CC||leslinetest...@gmail.com --- Comment #1 from Lesline --- Hello Keith. Thank you for reporting the bug. I can confirm that I was able to reproduce it using the following versions: Version: 7.6.0.0.alpha0+ (X86_64) / LibreOffice Community Build ID: d07b1cc8148140bd3a78103da668d002b9d266ab CPU threads: 8; OS: Windows 10.0 Build 19044; UI render: Skia/Raster; VCL: win Locale: en-US (en_US); UI: en-US Calc: threaded Version: 7.4.3.2 (x64) / LibreOffice Community Build ID: 1048a8393ae2eeec98dff31b5c133c5f1d08b890 CPU threads: 8; OS: Windows 10.0 Build 19044; UI render: Skia/Raster; VCL: win Locale: en-US (en_US); UI: en-US Calc: threaded For clarity: This bug was reproduced using the steps provided. When the right click command is used to format the date, this error does not occur. Kind Regards -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 152877] Dates are getting formatted as dollar amounts and can't change
https://bugs.documentfoundation.org/show_bug.cgi?id=152877 QA Administrators changed: What|Removed |Added Whiteboard|| QA:needsComment -- You are receiving this mail because: You are the assignee for the bug.