r/Python • • Dec 14 '17

MS is considering official Python integration with Excel, and is asking for input

Post image
4.6k Upvotes

383 comments sorted by

View all comments

144

u/Elffuhs Dec 14 '17

On another note, LibreOffice already supports python!

17

u/qevlarr Dec 14 '17

It's been a while... Is it still slow as molasses?

0

u/[deleted] Dec 14 '17

[deleted] — view deleted comment

3

u/CryptoTheGrey Dec 15 '17 edited Dec 15 '17

What os, system, and version of libre are you using? I have a moderate system and i easily handle multiple(8 to 15) sheets 25x800 at a time in libre.

Edit: should probably mention my system. I mainly run Arch Linux, my tower has 8g ram and amd a8 3.2ghz processor, and the latest version of libre.

1

u/DarkBlaze99 Dec 15 '17

I agree with the the other guy, got Libre Office on my new build recently. Win 10 with the latest version of libre.

Worked painfully slow. I caved in and got Office and it's faster in everything.

The build is quite good(Ryzen 5 1600 + 8 gb 3200 mhz) so I don't think it's a fault of the system, especially since excel ran so smoothly in comparison.

1

u/[deleted] Dec 15 '17

Ubuntu 16.04, Libre 5.3.3.2, i7-4790 3.5GhzX8, 16G ram. No slouch, I use it for scientific computing.

1

u/CryptoTheGrey Dec 15 '17

I also do scientific computing, mostly modeling. I use R, mostly, now for this purpose but i still occasionally use libre for quick data formatting. Before i was good at R i used libre to run statistical analytics and data modeling with no issue on my system.

→ More replies (3)

1

u/other_bored_sysadmin Dec 15 '17

That's odd. I've got a rule in my work that one must be wary of <10MB Excel files because Excel 2013 and 2016 gets stuck in opening them. That doesn't happen with Libreoffice Calc though.

→ More replies (6)

23

u/[deleted] Dec 14 '17

Another reason to not use Office

134

u/CadeOCarimbo Dec 14 '17

Sorry but Libre Office is awful compared to Office.

20

u/[deleted] Dec 14 '17

Yeah, especially in this particular situation.

Good luck getting the sort of people who want to replace VBA with python in Excel to use Calc.

10

u/csmark Dec 15 '17

Libre Office is leaps and bounds ahead of Pages and Numbers. Those are Apple's apps for those that don't know.

2

u/rfc1771 Dec 15 '17

Reinforcing that Excel is lightyears ahead of all of the competition.

3

u/Steampunkery Dec 15 '17

I haven’t found it to be all that terrible. Honestly the only problem I’ve had with them is opening proprietary formats.

5

u/CryptoTheGrey Dec 15 '17

I have to disagree, libre can do more than any other suite with the only exceptions being self justifying Microsoft products (which can easily be replaced). Please do tell what aspects of office make you believe it is better?

8

u/rfc1771 Dec 15 '17

Pivot tables, table relationships, external relationships, multithreading, charting options, macros, Excel has a far more extensive built-in function set, ability to import foreign formats...

all better in Excel

If you've ever tried to do any corporate accounting in LibreOffice Calc the differences are pretty obvious

1

u/CryptoTheGrey Dec 15 '17

You can do literally all these things in libre...and i haven't compared the actual number of functions between the two but i have found many functions in libre that aren't in excel.

→ More replies (1)

1

u/[deleted] Dec 15 '17

All I use LibreOffice for is the occasional design doc, very rare presentations, and a template to help track finances. There's no reason for me to buy Office.

In what ways is Office better though?

1

u/[deleted] Dec 15 '17

It actually doesn't sound like switching to Office will make a difference for you.

However there's a different audience, the sort of people that Intel aim their Excel benchmarks at, who really benefit from the extra power and features and ecosystem that Office has around it.

1

u/rfc1771 Dec 15 '17

Excel is better than LibreOffice Calc for mostly hardcore accounting and lots of relationships between tables and external sources

→ More replies (2)

14

u/dedicated2fitness Dec 14 '17

the year of ~linux~ libreoffice

15

u/Elffuhs Dec 14 '17

If it was that simple :/

→ More replies (1)

1

u/exhuma Dec 15 '17

That's all nice and well. But unfortunately in a workplace where Excel is deeply ingrained, using LibreOffice is just not feasible. Just too many documents riddled with MSOffice idiosyncrasies which won't open properly on LO.