• the Daily hi thread just say hi :)
  • All contentious threads including politics, religion, crime, immigration, laws, elections etc are banned & will be removed. There is still a Gun Related Politics section for relevant topics.

Open Office spreadsheets

Dag

Dag

Super member
Joined
Jul 7, 2022
Messages
870
Reaction score
1,793
Location
Leatherhead, Surrey
Can anyone help with advice re Open Office?
I have Windows 10 and I'm using a Microsoft Office 2007 spreadsheet for club competition results. As that is now 17yrs old and no longer supported by Microsoft I'm thinking of replacing it but without the expense of Microsoft 365.
I've had Libre and Apache Open Office suggested but have never used either.
Does anyone have experience of either of these, and as it is mainly spreadsheets I use is one better than the other?
Thanks,
Jim
 
Dag said:
Can anyone help with advice re Open Office?
I have Windows 10 and I'm using a Microsoft Office 2007 spreadsheet for club competition results. As that is now 17yrs old and no longer supported by Microsoft I'm thinking of replacing it but without the expense of Microsoft 365.
I've had Libre and Apache Open Office suggested but have never used either.
Does anyone have experience of either of these, and as it is mainly spreadsheets I use is one better than the other?
Thanks,
Jim
Click to expand...
I have used LibreOffice on Windows 10 for a number of years without issues (It did hang up once but that was solved by simply installing an updated version). This was for spreadsheets and documents. I didn't like the drawing tool however.
 
I've been using LibreOffice and have no quibbles with the word processor part. It's a tad slow to load but that might be (probably is) just my PC. The best thing is that you can try it for nothing and discard it if it doesn't suit your needs.
 
  • Like
Reactions: Dag
In my experience - though it is some time since I used open office - Excel is best (but if you are used to the 2007 version it is pretty old now so will be missing quite a few tweaks that 365 will have)

Open office was very good but couldn't do everything Excel could (though I guess it matches Excel 2007 now!)

Google Sheets I found slow, irritating and lacking lots of the maths functionality I want/need - if you want the best and need the more unusual featurs then it's Excel - but I would try Open Office and see if it can't do something you want. If that happens, check if 365 can - if so, then you need tomake a choice
 
  • Like
Reactions: Dag
I have used Libre in the past and found it easy to use. Worth a try.
There is a free version of Microsoft 365 that is web based if your used to using Microsoft office.
 
  • Like
Reactions: Dag
The spreadsheet may no longer be supported but it can be saved as a later version. I still save many things in the 2003 version!
Libre Office and Open Office have little difference. You get word processor, spreadsheet and Powerpoint equivalent.
I've used both. I would prefer their menu structure to the latest Microsoft sheer tripe which is hard to navigate, fills half the screen with useless pictorial "aids" and deeply buries what functionality they have left in. You have to know or find too many shortcuts and basic tasks are well hidden. Compare the latest "Paint" program to the earlier XP version and see what has been taken out!
I suggest you install either of them, then try opening the spreadsheet. Nothing lost
 
  • Like
Reactions: Dag
My experience is that either would do the job for you and you’d have no problems getting used to the spreadsheets.
 
  • Like
Reactions: Dag
Does this mean As-Easy-As is no longer a thing... 🤣
 
Steve_lyt said:
if your not doing anything fancy , any spreadsheet should do
Click to expand...
Very true Steve and my needs are simple given it’s just straightforward home accounts and competition scores from club competitions.
The most complex features needed are totals, averages , max and min scores, and std deviations - all of which are easily done with any of these it seems.
Thanks to everyone for their suggestions and I have now saved all my work into Libre Calc and while I get used to it I’m also saving additional back-ups in Excel.
Cheers!
Jim (y)
 
You can still get non 365 versions of MS Office, I have a 2019 version on this laptop, and I think I have MS Office 2021 on the Wife's laptop. Some are download versions, some are physical disc so will need a disc drive. My ones were digital DL via Amazon I think.
Quick google should bring up a few links, stick to reputable sites, eg: amazon, etc.
 
pjgtech said:
You can still get non 365 versions of MS Office, I have a 2019 version on this laptop, and I think I have MS Office 2021 on the Wife's laptop. Some are download versions, some are physical disc so will need a disc drive. My ones were digital DL via Amazon I think.
Quick google should bring up a few links, stick to reputable sites, eg: amazon, etc.
Click to expand...
^^^ Exactly this^^^

I bought MS Office 2021 and Product Key for less than £20.00 from Amazon. It should last a good few years before it's obsolete. I was a bit sceptical that it was all legit; which is why I bought off Amazon; but it was and works perfectly.
 
Last edited:
My last one, the Wife's, 2021 version of MS Office, would not activate after I installed it. But, a call to customer support, who then routed me to a guy in the US who had it activated and working in minutes, very good customer service, and I think I only paid about £20 or so too. As above, should be supported for few years yet, so its all good.
I've personally used MS Office since it came out, (Used Word Perfect before that, anyone remember that one!) so its what I know and what I'm used to.
Word, Excel, Powerpoint, Sharepoint, Teams, etc were all things I had to use at work as our designated Software too.
When I had an android based laptop few years back I tried Open Office and Libre Office, both good and easy to use, but I found neither had the full functionality of MS Office? but maybe its just cos its what I'm used to?
 
I originally used MS OS with Word and Excel, but swtiched to Linux Mint after MS went off the rails. Ever since then it's been Linux Mint and Libreoffice. I would would choose them over MS every time.
 
I've been using Libre Office for a couple of years with no issues. It will also open .xls files but some formatting may not be 100% e.g. cell colours may be slightly different
 
I've been using LibreOffice for about 6 years, it's really very good and quick now. I've used both 'Calc' and 'Writer' extensively.

There are some minor differences in where things are in the menus and how to set things up, but 'google is your friend' for that.

Plus it will work with any MS Office file format and it's FREE.
 
You must log in or register to reply here.
Back
Top