3 ms·

If this is true then it will be amazing and very widely adopted. Pandas in Excel would be cool. Fingers crossed.

andsoitis 3y ago
> If this is true https://techcommunity.microsoft.com/t5/excel-blog/announcing-python-in-excel-combining-the-power-of-python-and-the/ba-p/3893439 https://techcommunity.microsoft.com/t5/excel-blog/announcing...
qntty 3y ago
I'd be happy if I could just represent integers with more than 15 digits without rounding (e.g. 64-bit primary keys)
- xxs 3y ago
  64bit can hold 20 digits (decimal), 20 (sortof) 19 completely
  - mkl 3y ago
    64 bit integers can. Excel uses 64 bit floating point. Try the formula =1 = (1+1e-16) and you'll get TRUE.
diffeomorphism 3y ago
Why? Libreoffice calc had python for years now and nobody cared: https://help.libreoffice.org/6.3/en-US/text/sbasic/python/python_programming.html https://help.libreoffice.org/6.3/en-US/text/sbasic/python/py...
- alexriddle 3y ago
  For someone working outside IT but who has coding skills, it's great. My previous work computers have been tightly controlled by IT and installing libreoffice on them wouldn't have been permitted.
- codetrotter 3y ago
  Because the world runs Excel, not LibreOffice Calc.
- pasc1878 3y ago
  Beacuse anyone with a budget had Excel already - and had to use Excel to be able to use other peoples' spreadsheets. LibreOffice is not bug compatible with Excel. Look what Excel had tro do to replace Lotus 1-2-3. Including making 1900 a leap year beacuse Lotus had the error.
- bafe 3y ago
  I love free software as much as anyone, but when I'm forced to use a spreadsheet I'm glad we get office at work. The UI/UX of LibreOffice could use a lot of improvements
xxs 3y ago
> it will be amazing and very widely adopted. The calculations in the cloud?
- narcraft 3y ago
  Why would the vast majority of Excel users even notice or care about this?
  - kbelder 3y ago
    The ones that use python would. It being cloud-based makes it a pretty useless feature for anything that I was using Python & Pandas for. If it was on the client side, I'd be rolling it out to users the moment it was available.
  - pasc1878 3y ago
    Because they have financial data on it and putting financial information outside computers your company controls is a massive risk.
debitcredit 3y ago
We're working on this at op (https://opapp.io https://opapp.io). Pandas in a spreadsheet, just not an excel spreadsheet if you're able to jump ship.
skolos 3y ago
Here you go: https://blog.adaptiverisk.com/post/2023-08-22-dataslicer/ https://blog.adaptiverisk.com/post/2023-08-22-dataslicer/ Calculations are local, not in the cloud.

> If this is true https://techcommunity.microsoft.com/t5/excel-blog/announcing-python-in-excel-combining-the-power-of-python-and-the/ba-p/3893439 https://techcommunity.microsoft.com/t5/excel-blog/announcing...

qntty 3y ago

I'd be happy if I could just represent integers with more than 15 digits without rounding (e.g. 64-bit primary keys)

xxs 3y ago
64bit can hold 20 digits (decimal), 20 (sortof) 19 completely
- mkl 3y ago
  64 bit integers can. Excel uses 64 bit floating point. Try the formula =1 = (1+1e-16) and you'll get TRUE.

diffeomorphism 3y ago

Why? Libreoffice calc had python for years now and nobody cared: https://help.libreoffice.org/6.3/en-US/text/sbasic/python/python_programming.html https://help.libreoffice.org/6.3/en-US/text/sbasic/python/py...

alexriddle 3y ago
For someone working outside IT but who has coding skills, it's great. My previous work computers have been tightly controlled by IT and installing libreoffice on them wouldn't have been permitted.
codetrotter 3y ago
Because the world runs Excel, not LibreOffice Calc.
pasc1878 3y ago
Beacuse anyone with a budget had Excel already - and had to use Excel to be able to use other peoples' spreadsheets. LibreOffice is not bug compatible with Excel. Look what Excel had tro do to replace Lotus 1-2-3. Including making 1900 a leap year beacuse Lotus had the error.
bafe 3y ago
I love free software as much as anyone, but when I'm forced to use a spreadsheet I'm glad we get office at work. The UI/UX of LibreOffice could use a lot of improvements

xxs 3y ago

> it will be amazing and very widely adopted. The calculations in the cloud?

narcraft 3y ago
Why would the vast majority of Excel users even notice or care about this?
- kbelder 3y ago
  The ones that use python would. It being cloud-based makes it a pretty useless feature for anything that I was using Python & Pandas for. If it was on the client side, I'd be rolling it out to users the moment it was available.
- pasc1878 3y ago
  Because they have financial data on it and putting financial information outside computers your company controls is a massive risk.

debitcredit 3y ago

We're working on this at op (https://opapp.io https://opapp.io). Pandas in a spreadsheet, just not an excel spreadsheet if you're able to jump ship.

skolos 3y ago

Here you go: https://blog.adaptiverisk.com/post/2023-08-22-dataslicer/ https://blog.adaptiverisk.com/post/2023-08-22-dataslicer/ Calculations are local, not in the cloud.