3 ms·

> I sadly still need to use Excel in a VM sometimes Any reason for not using Google sheets or similar?

by miyuru 4y ago

samtho 4y ago
Sometimes it’s not up to the user if the company they work/contract for requires it.
dzink 4y ago
It is woefully behind if you have real number crunching to do.
- YurgenJurgensen 4y ago
  If you need to be doing 'real number crunching', you probably shouldn't be using any spreadsheet. Excel is not MySQL or Jupyter.
  - michaelt 4y ago
    I think the Google Sheets devs would agree with you that spreadsheets shouldn't be used for anything serious. That's why it's missing such basic features as an X/Y scatter plot with a line - which is trivial in any other spreadsheet program. Personally when I have a few dozen data points and I want an X/Y plot with a line, I find a spreadsheet is a better tool than MySQL.
    - anthk 4y ago
      Gnuplot.
    - oneeyedpigeon 4y ago
      Yup, I pretty much guarantee that Google Sheets is not intended for people who need X/Y scatter plots. I would theorise that 99% of Excel users don't require that feature either.
  - Takennickname 4y ago
    MySQL and Jupyter don't have data visualization. Or are you saying the options are a) use google sheets, or b) learn to program
    - empyrrhicist 4y ago
      Jupyter absolutely includes data visualization, or rather all the major languages it supports do. But honestly, yes. Complicated work in excel is programming, it's just completely undebuggable since the logic is spread out invisibly in multiple grid dimensions, sheets, and macros. Give me a Jupyter notebook written in a language I don't yet know any day before you give me a complicated excel monstrosity.
      - tracker1 4y ago
        Not a Python guy at all, but a couple of my coworkers use Jupyter notebooks a lot, and it's definitely very cool.
fxtentacle 4y ago
I need to send out Excel files to clients and they need to display 100% perfect when the client opens them with their Microsoft Excel. So using Google Sheets or LibreOffice is a risk, because while they work 99% of the time, they tend to break with power-user Excel features like integrated resource links.

> I sadly still need to use Excel in a VM sometimes Any reason for not using Google sheets or similar?

by miyuru 4y ago

> I sadly still need to use Excel in a VM sometimes Any reason for not using Google sheets or similar?

samtho 4y ago

Sometimes it’s not up to the user if the company they work/contract for requires it.

dzink 4y ago

It is woefully behind if you have real number crunching to do.

YurgenJurgensen 4y ago
If you need to be doing 'real number crunching', you probably shouldn't be using any spreadsheet. Excel is not MySQL or Jupyter.
- michaelt 4y ago
  I think the Google Sheets devs would agree with you that spreadsheets shouldn't be used for anything serious. That's why it's missing such basic features as an X/Y scatter plot with a line - which is trivial in any other spreadsheet program. Personally when I have a few dozen data points and I want an X/Y plot with a line, I find a spreadsheet is a better tool than MySQL.
  - anthk 4y ago
    Gnuplot.
  - oneeyedpigeon 4y ago
    Yup, I pretty much guarantee that Google Sheets is not intended for people who need X/Y scatter plots. I would theorise that 99% of Excel users don't require that feature either.
- Takennickname 4y ago
  MySQL and Jupyter don't have data visualization. Or are you saying the options are a) use google sheets, or b) learn to program
  - empyrrhicist 4y ago
    Jupyter absolutely includes data visualization, or rather all the major languages it supports do. But honestly, yes. Complicated work in excel is programming, it's just completely undebuggable since the logic is spread out invisibly in multiple grid dimensions, sheets, and macros. Give me a Jupyter notebook written in a language I don't yet know any day before you give me a complicated excel monstrosity.
    - tracker1 4y ago
      Not a Python guy at all, but a couple of my coworkers use Jupyter notebooks a lot, and it's definitely very cool.

fxtentacle 4y ago

I need to send out Excel files to clients and they need to display 100% perfect when the client opens them with their Microsoft Excel. So using Google Sheets or LibreOffice is a risk, because while they work 99% of the time, they tend to break with power-user Excel features like integrated resource links.