OpenOffice VS Google Sheets, any benefits?

Discuss the spreadsheet application
Post Reply
xuzo
Posts: 7
Joined: Sun Apr 14, 2019 4:08 am

OpenOffice VS Google Sheets, any benefits?

Post by xuzo »

I've been dabbling in Google sheets, and since it's online, seems to be a lot of JS , scripts and so on, makes them slow.

Does open office calc have the same functionality as Google sheets?

Are there any benefits to using Calc vs Google sheets?

I don't need any collaboration tools, this is all for me, and actually I prefer to work offline.
Windows 10, 64 Bit
Open Office 4.1.6
erbsenzahl
Volunteer
Posts: 254
Joined: Tue Apr 18, 2017 8:23 am
Location: Germany

Re: Open Office VS Google Sheets, any benefits?

Post by erbsenzahl »

xuzo wrote:Are there any benefits to using Calc vs Google sheets? ... I don't need any collaboration tools, this is all for me, and actually I prefer to work offline.
The answer for your last statement is obvious. Use Calc of OpenOffice or LibreOffice.

Benefits? There are some differences, see incompatibility comparison of Excel|GDocs|LibreCalc in a German Libre forum thread: https://www.libreoffice-forum.de/viewto ... excel+calc
In short:
German: Blau: möglich, Rot: nicht möglich, Schwarz: nicht bekannt oder Kommentar
English: Blue: possible, Red: not possible, Black: unknown or comment
Formulae are in German Language, for better understanding ask specific questions in this forum...

Cheers
LibreOffice current versions 7 and OpenOffice 4.1.15
on LinuxMint 20 - 21 Mate, W10-64 pro
ainventor
Posts: 2
Joined: Mon Apr 06, 2020 5:20 pm

Re: OpenOffice VS Google Sheets, any benefits?

Post by ainventor »

I have a huge ods file created and it takes for ever to add anything. But after I get it added, I upload it to my drive account. From there I open the file in Google Sheets, and the file becomes very fast and responsive to use. Hope this helps. Not sure if it works in the Cloud.
OpenOffice 4.1.5 on windows 10
User avatar
Zizi64
Volunteer
Posts: 11345
Joined: Wed May 26, 2010 7:55 am
Location: Budapest, Hungary

Re: OpenOffice VS Google Sheets, any benefits?

Post by Zizi64 »

I suppose that you can not use any macros in the Google sheets.
Tibor Kovacs, Hungary; LO7.5.8 /Win7-10 x64Prof.
PortableApps/winPenPack: LO3.3.0-7.6.2;AOO4.1.14
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.
ainventor
Posts: 2
Joined: Mon Apr 06, 2020 5:20 pm

Re: OpenOffice VS Google Sheets, any benefits?

Post by ainventor »

I'm not sure. I don't use macros in my ods file.
OpenOffice 4.1.5 on windows 10
Post Reply