OpenOffice VS Google Sheets, any benefits?

Discuss the spreadsheet application

OpenOffice VS Google Sheets, any benefits?

Postby xuzo » Sun Apr 14, 2019 4:55 am

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
xuzo
 
Posts: 5
Joined: Sun Apr 14, 2019 4:08 am

Re: Open Office VS Google Sheets, any benefits?

Postby erbsenzahl » Sun Apr 14, 2019 10:53 am

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
OpenOffice 3.4.1 and 4.1.7 on LinuxMint 19-64 Mate, rarely W7-64 pro and W10-64 pro; LibreOffice current versions
(author is no native speaker)
erbsenzahl
Volunteer
 
Posts: 156
Joined: Tue Apr 18, 2017 8:23 am
Location: Germany

Re: OpenOffice VS Google Sheets, any benefits?

Postby ainventor » Mon Apr 06, 2020 5:26 pm

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
ainventor
 
Posts: 2
Joined: Mon Apr 06, 2020 5:20 pm

Re: OpenOffice VS Google Sheets, any benefits?

Postby Zizi64 » Mon Apr 06, 2020 6:03 pm

I suppose that you can not use any macros in the Google sheets.
Tibor Kovacs, Hungary; LO6.1.6, 6.2.8 /Win7-10 x64Prof.
PortableApps/winPenPack: LO3.3.0-6.4.3;AOO4.1.7
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.
User avatar
Zizi64
Volunteer
 
Posts: 9226
Joined: Wed May 26, 2010 7:55 am
Location: Budapest, Hungary

Re: OpenOffice VS Google Sheets, any benefits?

Postby ainventor » Mon Apr 06, 2020 6:13 pm

I'm not sure. I don't use macros in my ods file.
OpenOffice 4.1.5 on windows 10
ainventor
 
Posts: 2
Joined: Mon Apr 06, 2020 5:20 pm


Return to Calc

Who is online

Users browsing this forum: No registered users and 9 guests