Comment on LibreOffice criticizes EU Commission over proprietary XLSX formats

jdr@lemmy.ml ⁨2⁩ ⁨months⁩ ago

• Quill7513@slrpnk.net ⁨2⁩ ⁨months⁩ ago

  i will also accept LibreOffice’s format for formula purposes

  source
• ranzispa@mander.xyz ⁨2⁩ ⁨months⁩ ago

  CSV does not allow storing formulas, just results. It is a good format to share data, but it is not a good format to store spreadsheets which very often contain such formulas.

  source

  • jdr@lemmy.ml ⁨2⁩ ⁨months⁩ ago

    Formulas are just strings, no reason you couldn’t store over in a CSV.

    Maybe your software doesn’t want you to do that, but that’s a problem with that specific software.

    source

    • ranzispa@mander.xyz ⁨2⁩ ⁨months⁩ ago

      Do you know of any software which stores formulas in CSV?

      source

      • jdr@lemmy.ml ⁨2⁩ ⁨months⁩ ago

        It’s an option when saving in LibreOffice Calc.

        Would be a pretty straightforward macro to (un)quote the formulas in Excel or Google Sheets etc.

        source

        • -> View More Comments
  • raspberriesareyummy@lemmy.world ⁨2⁩ ⁨months⁩ ago

    you can store anything in CSV, it’s just not always very practical ;)

    source

    • rollin@piefed.social ⁨2⁩ ⁨months⁩ ago

      I don’t think you can have spreadsheets with multiple “sub sheets” (can’t think of an unambiguous name for them - basically the equivalent of browser tabs)

      Pretty sure there’s no way to have graphical charts either.

      source

      • tristan@tarte.nuage-libre.fr ⁨2⁩ ⁨months⁩ ago

        The technical term is sheet. The many sheets form a workbook (your file).

        source
      • raspberriesareyummy@lemmy.world ⁨2⁩ ⁨months⁩ ago

        technically you could do both, it’s just not practical at all :)

        source
    • Theoriginalthon@lemmy.world ⁨2⁩ ⁨months⁩ ago

      Just like opening a .doc file in notepad, technically all the information is there

      source
• testaccount372920@piefed.zip ⁨2⁩ ⁨months⁩ ago

  csv is a pretty good data sharing format, but not very well suited for spreadsheets. Just because you can shove anything you want in there doesn’t mean you should.

  source

  • jdr@lemmy.ml ⁨2⁩ ⁨months⁩ ago

    I think it’s perfectly well suited to spreadsheet. It’s more-or-less perfect for tabular human-readable data. If you want to embed fancy things like OLE objecta and ActiveX controls and helpful animated characters then you may well be better served with another format.

    source
• flying_sheep@lemmy.ml ⁨2⁩ ⁨months⁩ ago

  Death it is, CSV is horrible effectively unstandardized trash that has led to uncountable hours of efforts wasted due to subtly corrupted data through incompatible serialization settings.

  It actively makes the world a worse place by existing.

  source

  • jdr@lemmy.ml ⁨2⁩ ⁨months⁩ ago

    No, you

    source