Skip Navigation
techsupport @lemmy.world
InternetCitizen2 @lemmy.world

Date format bug?

cross-posted from: https://lemmy.world/post/33569521

Does anyone know why the "render" of the data would be wrong? I changed it from the US format to the ISO 8601.

Edit: Adding some spaces in the equation helped.

techsupport @sopuli.xyz
InternetCitizen2 @lemmy.world

Date format bug?
LibreOffice @discuss.tchncs.de
InternetCitizen2 @lemmy.world

Date format bug?
3 comments

  • Libre Office Version and OS?

    • I seemed to have solved my problem by adding spaces in the function as such =func(x, y, z). It is not clear to me why that matters, but I guess.

       
          
Version: 25.2.5.2 (X86_64) / LibreOffice Community
Build ID: 03d19516eb2e1dd5d4ccd751a0d6f35f35e08022
CPU threads: 8; OS: Linux 6.12; UI render: default; VCL: gtk3
Locale: en-US (en_US.UTF-8); UI: en-US
Flatpak
Calc: threaded

      • Me: Oh, I've been bitten by something like that in code, I bet it's a subtle timezone issue where applying the current timezone to the 00:00:00-timestamped datetime encoding of the date, and then truncating it back to the date only, winds up shifting...

        Me, after reading: What the FUCK, why