Announcing Python in Excel: Combining the power of Python and the flexibility of Excel.
techcommunity.microsoft.com
Since its inception, Microsoft Excel has changed how people organize, analyze, and visualize their data, providing a basis for decision-making for the..

Since its inception, Microsoft Excel has changed how people organize, analyze, and visualize their data, providing a basis for decision-making for the flying billionaires heads up in the clouds who don’t give a fuck for life offtheline

  • Eheran@lemmy.worldEnglish
    231·
    10 months ago

    Holy shit Excel is still like it was 20 years ago. And now, when they want to add such a useful feature, it comes with that bag of crap with it? Fucking hell. I know why I switched all non-trivial stuff to python.

    Defining reusable functions? Diagrams with parametric ranges? (Only the title can be a cell reference, nothing else) Zooming in diagrams? More than 1 x axis? More than 2 y axis? …

    • ChaoticNeutralCzech@feddit.deEnglish
      52·
      10 months ago

      Even a basic thing like XY scatter plots is absolutely terrible. I had made dozens of them before but in 365, when I selected the data and clicked “Scatter Plot”, it refused to assign the left column to X and the right to Y. I fought for 10 minutes with “Chart Series” and then gave up to look up the solution. Also very few trendline functions are available, the default axes look like crap and min/max is broken for logarithmic charts.

      Not to mention that one third of all options is in a keyboard-unfriendly, laggy “responsive” UI while the rest is in windows that barely changed since 1995, and are completely missing in the web version. Localization has only become sloppier and you want centimeters rather than inches in Office Online? Fuck you.

      • Aatube@kbin.socialOP
        2·
        10 months ago

        I agree with the rest but I think the ribbon concept itself is nice and they actually updated the UI for Windows 11

        • ChaoticNeutralCzech@feddit.deEnglish
          2·
          10 months ago

          I like Ribbon too but the Home tab keeps getting used to give spotlight to rather unimportant new features. Also, the Windows 11 redesign is horrible, the buttons are spaced out too far. At home, I use my old legal copy of Office 2007 via Wine of I need to correctly open Office files while getting used to the messy icons and dropdowns of LibreOffice.

          • Aatube@kbin.socialOP
            4·
            10 months ago

            LibreOffice also has a ribbon. Just go to View → User Interface and select “Tabbed Bar” or something like that. I like contextual groups (which needs experimental features enabled, unfortunately) better since it’s like the MS office “group descriptions” but it isn’t fully suited for Impress yet so groupedbar (non-compact version also experimental) is a nice middle ground.

      • Eheran@lemmy.worldEnglish
        31·
        10 months ago

        Oh those numbers? That is a date. I will delete the original numbers and replace it with something else. Good luck.

        Excel is one of those examples of a software that is only used everywhere because it used to be the best and it is overall not bad. So “everyone” already knows it and the incentive to move to something else is fairly small, because it would only be so much better. But still, why are they not developing it further? Completely crazy.

        • BastingChemina@slrpnk.netEnglish
          1·
          10 months ago

          I feel like excel is still used everywhere because it’s the kind of Jack of all trades.

          There is a better alternative for all the applications excel is used for but no alternative that can do all at once.

          • Aatube@kbin.socialOP
            21·
            10 months ago

            LibreOffice? I mean some features are missing but I don’t see why you’d need them

            • barfplanet@lemmy.worldEnglish
              2·
              10 months ago

              Maybe it’s because I’m so accustomed to Excel, but Libreoffice Calc is so painful to use. Not the app that’s going to win people over.

        • ChaoticNeutralCzech@feddit.deEnglish
          1·
          10 months ago

          Not developing it further? They are bound to their shortsightedly developed xlsx format and they need to make sure legacy stuff doesn’t break… However, the Win11-style redesign is a regression, and the Czech spell checker has been flagging a completely normal verb class as ancient for years, and the heavily-touted Web Sources cannot even parse JSON. They also keep adding shit like Online Images (with Bing), automatic image recognition that I imagine collects shitloads of AI training data and of course support links that only open in Edge even though it works no better than your default browser. I wonder where the prosecutors who brought M$ to court for bundling IE with W95 are today.

          • Aatube@kbin.socialOP
            2·
            10 months ago

            Unfortunately that case only ended in an order for Microsoft to share its API for at least 5 years and for the DOJ to have full access to MS stuff including source code during this time