https://bugs.documentfoundation.org/show_bug.cgi?id=164914
--- Comment #12 from Kohei Yoshida <[email protected]> --- The cells in question have the following code: <Cell ss:StyleID="d01"> <Data ss:Type="DateTime">2024-11-01T00:00:00.000</Data> </Cell> <Cell ss:StyleID="d01"> <Data ss:Type="DateTime">2025-11-30T00:00:00.000</Data> </Cell> They both reference the style ID of "d01", which has <Style ss:ID="d01"> <Alignment ss:Vertical="Top"/> <NumberFormat ss:Format="yyyy/mm/dd;@"/> <Font ss:FontName="Calibri" x:Family="Swiss" ss:Size="10" x:Color="#000000"/> </Style> The number format value is what's relevant here. Since the format code is `yyyy/mm/dd;@`, it is correct to use the YYYY/MM/DD format to display the date value. The Data element <Data ss:Type="DateTime">2024-11-01T00:00:00.000</Data> only specifies the raw date time value stored in the cell; this itself does not dictate how the value is to be displayed. If you manually change the format code in the style 'd01' structure to, say, yyyy-mm-dd, then Calc will display the values accordingly. To me, this is working as intended. -- You are receiving this mail because: You are the assignee for the bug.
