Conversation

Notices

1. Embed this notice
   Lars Marowsky-Brée 😷 (larsmb@mastodon.online)'s status on Wednesday, 08-Jan-2025 18:58:45 JST Lars Marowsky-Brée 😷

   Bit difficult to believe that #LibreOffice Sheets doesn't have a native function for converting Unix timestamps to dates, or accept "Unix timestamp" as a date format.

   • Embed this notice
     Rocketman (slothrop@chaos.social)'s status on Wednesday, 08-Jan-2025 18:58:41 JST Rocketman

     in reply to

     • lproven
     • Ian Betteridge

     These are the Excel tables that @ianb is talking about: https://support.microsoft.com/en-us/office/overview-of-excel-tables-7ab0bb7d-3a9e-4b56-a3c9-6c94334e492c

     LibreOffice does have a "Tables" menu entry. But that refers to adding another sheet to your workbook; it does NOT provide functionality analogous to Excel´s tables. And I agree that those are an important feature.

     In happier news, LibreOffice definitely does have pivot tables.

     @lproven @larsmb

   • Embed this notice
     lproven (lproven@social.vivaldi.net)'s status on Wednesday, 08-Jan-2025 18:58:42 JST lproven

     in reply to

     • Ian Betteridge

     @ianb @larsmb No no no. Hang on there Ian.

     You are making a big ol' claim there and you're trying to hand-wave it away. Not letting that slide.

     *Yes* LO does tables. You can create and edit tables in LO Writer.
     
     I have no bloody idea what "tables in the same way you have them in Excel" means. Be specific and concrete. I don't know what you do in Excel.

     I stopped using MS Office when Office 2007 came out. No blasted idea what it's done since then. I have been using LO Calc since that time, pretty much exclusively.

     I am happy to say I've never wanted to take a range of a LO Calc spreadsheet and paste it into a LO Writer doc. I've not done that kind of thing since the 20th century. I'd expect it to work, though.

     Are you talking about _pivot tables_ in Excel? For me they have always been part of the extra-20% Pareto Principle bloat: I've never wanted it, never used it, can't imagine why I ever would.

   • Embed this notice
     Ian Betteridge (ianb@mastodon.well.com)'s status on Wednesday, 08-Jan-2025 18:58:42 JST Ian Betteridge

     in reply to

     • lproven

     @lproven @larsmb No, tables, not pivot tables. Excel allows you to mark a data set as a table. This then allows you to sort the data while keeping it coherent, so each line remains the same. (There’s more to it, such as filtering, etc) Make sense? It’s the most commonly used feature in Excel for most people using excel - basically it’s using Excel as a simple database with each line as a “record”.

   • Embed this notice
     Ian Betteridge (ianb@mastodon.well.com)'s status on Wednesday, 08-Jan-2025 18:58:43 JST Ian Betteridge

     in reply to

     • lproven

     @larsmb @lproven unless it’s changed in the past year, yeah, no tables in the same way you have them in Excel. If it’s been added then 🙏🙏🙏

   • Embed this notice
     Lars Marowsky-Brée 😷 (larsmb@mastodon.online)'s status on Wednesday, 08-Jan-2025 18:58:44 JST Lars Marowsky-Brée 😷

     in reply to

     • lproven
     • Ian Betteridge

     @ianb @lproven No tables? I'm pretty sure I've done tables in LO, or is that something I'm misunderstanding?

   • Embed this notice
     Ian Betteridge (ianb@mastodon.well.com)'s status on Wednesday, 08-Jan-2025 18:58:45 JST Ian Betteridge

     in reply to

     • lproven

     @larsmb @lproven Also: doesn't do tables. The single biggest use of Excel for ordinary spreadsheet users.

     (And I have had LibreOffice fans claim this is perfectly fine and people should use a database if they want this. Sigh).

   • Embed this notice
     Ian Betteridge (ianb@mastodon.well.com)'s status on Wednesday, 08-Jan-2025 19:09:57 JST Ian Betteridge

     in reply to

     @slothrop @lproven @larsmb mmm love me some pivot tables

   • Embed this notice
     Rocketman (slothrop@chaos.social)'s status on Wednesday, 08-Jan-2025 19:10:35 JST Rocketman

     in reply to

     • lproven
     • Ian Betteridge

     @ianb Not enough people realise that Excel is essentially the poor person´s low-code platform -- and it´s pretty much universal.

     In any business, people who can code will be a relatively small share of the workforce. But nearly everyone will be familiar with Excel.

     And IT LETS YOU DO STUFF.

     (Corollary: Excel gets used in lots of places where you should really use a specialised tool.)

     @lproven @larsmb