[Bug 158625] Dateformat not preserved in calc
https://bugs.documentfoundation.org/show_bug.cgi?id=158625 --- Comment #16 from QA Administrators --- [Automated Action] NeedInfo-To-Unconfirmed -- You are receiving this mail because: You are the assignee for the bug.
[Bug 158625] Dateformat not preserved in calc
https://bugs.documentfoundation.org/show_bug.cgi?id=158625 --- Comment #15 from Guus Ellenkamp --- It is in all my spreadsheets. The date format is not preserved. I tried 'everything' (and I think I am pretty well versed in computer stuff). I don't know what else to provide. Linux debian 5.10.0-9-amd64 #1 SMP Debian 5.10.70-1 (2021-09-30) x86_64 GNU/Linux LibreOffice 7.0.4.2 00(Build:2) -- You are receiving this mail because: You are the assignee for the bug.
[Bug 158625] Dateformat not preserved in calc
https://bugs.documentfoundation.org/show_bug.cgi?id=158625 BogdanB changed: What|Removed |Added CC||buzea.bog...@libreoffice.or ||g Status|REOPENED|NEEDINFO --- Comment #14 from BogdanB --- Bug status changed as Needinfo based on comment 13. -- You are receiving this mail because: You are the assignee for the bug.
[Bug 158625] Dateformat not preserved in calc
https://bugs.documentfoundation.org/show_bug.cgi?id=158625 --- Comment #13 from m.a.riosv --- Maybe some direct format is producing the issue for you. Clear the cell format with [Ctrl+M] and try again. -- You are receiving this mail because: You are the assignee for the bug.
[Bug 158625] Dateformat not preserved in calc
https://bugs.documentfoundation.org/show_bug.cgi?id=158625 --- Comment #12 from Guus Ellenkamp --- Apparently you are seeing something else than I do. That's why I reported it as a bug as it seems to be related to a specific version. -- You are receiving this mail because: You are the assignee for the bug.
[Bug 158625] Dateformat not preserved in calc
https://bugs.documentfoundation.org/show_bug.cgi?id=158625 --- Comment #11 from ady --- (In reply to Guus Ellenkamp from comment #0) > Steps to Reproduce: > 1. Format cell to date format mm/dd/yy. > 2. Save file. > 3. Open file. > 4. Date changed back to mm-dd-yy. @Guus, I am trying to reproduce your steps using your attachment 191354 (an xlsx spreadsheet file), but I must be misunderstanding something. When I open attachment 191354 I see 2 worksheets. "Sheet2" has nothing relevant to this report. "Sheet1" has a list of dates. The cells containing the dates are already formatted as "MM/DD/YY" and are displayed accordingly, meaning that there is nothing to initially change or re-format (trying to follow your steps), but rather save the file "as-is" (using a different name). Saving the file with the same xlsx format (with a different name), closing and re-opening it, I still see the dates formatted as MM/DD/YY and displayed in the same way. So, there is no "Date changed back to mm-dd-yy" (and it never was). Perhaps we need more specific steps, and/or a different spreadsheet file. It is also possible that I am seeing different things than you are. Or maybe I am misunderstanding something. -- You are receiving this mail because: You are the assignee for the bug.
[Bug 158625] Dateformat not preserved in calc
https://bugs.documentfoundation.org/show_bug.cgi?id=158625 --- Comment #10 from m.a.riosv --- Then please attach another sample file -- You are receiving this mail because: You are the assignee for the bug.
[Bug 158625] Dateformat not preserved in calc
https://bugs.documentfoundation.org/show_bug.cgi?id=158625 --- Comment #9 from Guus Ellenkamp --- I have the same issue now also in other (older) files. Before that worked fine, so it must have to do with some update. -- You are receiving this mail because: You are the assignee for the bug.
[Bug 158625] Dateformat not preserved in calc
https://bugs.documentfoundation.org/show_bug.cgi?id=158625 --- Comment #8 from Guus Ellenkamp --- Created attachment 191358 --> https://bugs.documentfoundation.org/attachment.cgi?id=191358&action=edit Screen shot Now I got something weird. I changed some things cell by cell and the date format in the edit field is mm/dd/yy. But the date formats in some cells are mm-dd-yy. And the other fields are numbers now. -- You are receiving this mail because: You are the assignee for the bug.
[Bug 158625] Dateformat not preserved in calc
https://bugs.documentfoundation.org/show_bug.cgi?id=158625 Guus Ellenkamp changed: What|Removed |Added Resolution|NOTABUG |--- Status|RESOLVED|REOPENED --- Comment #7 from Guus Ellenkamp --- Same result. The format changes from mm-dd-yy to mm/dd/yy when using your suggestion, but after saving and closing and opening again the format changes back to mm-dd-yy. -- You are receiving this mail because: You are the assignee for the bug.
[Bug 158625] Dateformat not preserved in calc
https://bugs.documentfoundation.org/show_bug.cgi?id=158625 m.a.riosv changed: What|Removed |Added Status|REOPENED|RESOLVED Resolution|--- |NOTABUG --- Comment #6 from m.a.riosv --- Liked you or not it is not a bug. Your dates are text dates, so the cell format doesn't change how they are shown. Select the range with dates. Menu/Data/Text to column. Click on data column head. In column type, select DD/MM/YY. Now change the format as you like. https://ask.libreoffice.org/t/date-format/37044 -- You are receiving this mail because: You are the assignee for the bug.
[Bug 158625] Dateformat not preserved in calc
https://bugs.documentfoundation.org/show_bug.cgi?id=158625 Guus Ellenkamp changed: What|Removed |Added Status|RESOLVED|REOPENED Resolution|NOTABUG |--- --- Comment #5 from Guus Ellenkamp --- I don't get it. It doesn't work for me. I don't see a menu Data->Text. And whatever I do, the same thing happens. Even if it is what you say it would still be a bug to me, as when I format a cell as a date with a specific format I would expect that format to be preserved. -- You are receiving this mail because: You are the assignee for the bug.
[Bug 158625] Dateformat not preserved in calc
https://bugs.documentfoundation.org/show_bug.cgi?id=158625 m.a.riosv changed: What|Removed |Added Resolution|--- |NOTABUG Status|NEEDINFO|RESOLVED --- Comment #4 from m.a.riosv --- Those figures are not true spreadsheet dates but text dates. Use Menu/Data/Text to column to convert them in true dates, and format as you like. Doing so works fine for me. -- You are receiving this mail because: You are the assignee for the bug.
[Bug 158625] Dateformat not preserved in calc
https://bugs.documentfoundation.org/show_bug.cgi?id=158625 --- Comment #3 from Guus Ellenkamp --- Version: 7.0.4.2 Build ID: 00(Build:2) CPU threads: 4; OS: Linux 5.10; UI render: default; VCL: gtk3 Locale: en-PH (en_PH.UTF-8); UI: en-US Debian package version: 1:7.0.4-4+deb11u7 Calc: threaded -- You are receiving this mail because: You are the assignee for the bug.
[Bug 158625] Dateformat not preserved in calc
https://bugs.documentfoundation.org/show_bug.cgi?id=158625 --- Comment #2 from Guus Ellenkamp --- Created attachment 191354 --> https://bugs.documentfoundation.org/attachment.cgi?id=191354&action=edit Sample file As requested. -- You are receiving this mail because: You are the assignee for the bug.
[Bug 158625] Dateformat not preserved in calc
https://bugs.documentfoundation.org/show_bug.cgi?id=158625 m.a.riosv changed: What|Removed |Added Status|UNCONFIRMED |NEEDINFO CC||miguelangelrv@libreoffice.o ||rg Ever confirmed|0 |1 --- Comment #1 from m.a.riosv --- Works for me with: Version: 24.2.0.0.alpha1+ (X86_64) / LibreOffice Community Build ID: 0ddd9f7e055a0c1ecb120de3e40c3fdb8373e9dc CPU threads: 16; OS: Windows 10.0 Build 22631; UI render: Skia/Vulkan; VCL: win Locale: es-ES (es_ES); UI: en-US Calc: CL threaded Please attach a sample file, and paste the information in Menu/Help/About LibreOffice, there is an icon to copy. -- You are receiving this mail because: You are the assignee for the bug.