https://bugs.documentfoundation.org/show_bug.cgi?id=163723
--- Comment #11 from Eyal Rozenberg <[email protected]> --- (In reply to Heiko Tietze from comment #10) > In order to make =now() appear as 2024-11-15T14:38:20+01:00 you can change > the number format to JJJJ-MM-TT"T"HH:MM:SS+"01:00". What can we do so that we can, say: 1. Feed Calc an ODT file with cell A1 containing 2024-11-01T18:42:40+01:00 and cell A2 containing 2024-11-01T17:42:40+02:00 2. See those strings on the sheet 3. Enter a formula =A2-A1 into cell A3 4. Get a value of 0 in A3 5. Save the ODT file 6. Still see 2024-11-01T18:42:40+01:00 in A1 and 2024-11-01T17:42:40+02:00 in A2 after the save -- You are receiving this mail because: You are the assignee for the bug.
