Open office not reliably saving spreadsheet changes

[jongood]

For years I used Excel but when Windows 10 came along I couldnt get my Office 2000 stuff to work so tried going to Office 365 which kept crashing my PC. To cut a long story short, I used 2000 on an older PC untilit died and then went to Open Office. The problem I'm having with Open Office is that it doesnt consistently save amendments, and frequently crashes when I add new worksheets in. This is a problem because its the way I manage my personal accounts and the few invoices I do ultimately culminating in what I submit to our accountants for "self assessment" .

I dont mind buying something but really want a reliable basic functional spreadsheet. Any recommendations please?

 

[The Wino]

We use google drive. If you create a document or spreadsheet it alters it constantly and saves it on the cloud. If its just personal use you'll never need to buy extra storage and you can access it on any device. It's free

 

[Gellyneck]

I dont mind buying something but really want a reliable basic functional spreadsheet. Any recommendations please?

Dropped OpenOffice in favour of LibreOffice (which was a fork of the former) a number of years ago and never had any problems.

It's Windows and Linux compatible which is also a benefit for me.

Home | LibreOffice - Free and private office suite - Based on OpenOffice - Compatible with Microsoft

Free office suite – the evolution of OpenOffice. Compatible with Microsoft .doc, .docx, .xls, .xlsx, .ppt, .pptx. Updated regularly, community powered.

www.libreoffice.org

 

[Abacist]

I have to use Libre Office to submit charity gift aid reclaims to HMRC as that is the only one they allow so must be adequate. You could always get a Mac and use Numbers!

 

[MisterB]

Is it possible to open an 'open office' file in 'libre office'? I have also found that open office spreadsheets sometimes don't update using new data that has been entered in different sheets within the same file!

^{_{Subscribers  do not see these advertisements}}

 

[Gellyneck]

Is it possible to open an 'open office' file in 'libre office'? I have also found that open office spreadsheets sometimes don't update using new data that has been entered in different sheets within the same file!

From memory OpenOffice has a default file format of .odf which LibreOffice also uses (unless you change it to some other format). So, a workbook \ spreadsheet saved in OpenOffice can be opened and maintained in LibreOffice.

Microsoft Office only recently enable .odf formatted documents to be opened and maintained.

 

[Gellyneck]

I have to use Libre Office to submit charity gift aid reclaims to HMRC as that is the only one they allow so must be adequate. You could always get a Mac and use Numbers!

Or use LibreOffice on a Mac as there is also an iOS version.

 

[Abacist]

That’s it “Open Document Format” files specified by HMRC.

 

[The Wino]

I'm pretty sure you can download Google docs spreadsheets in odf format and excel. Be worth checking first if it's important. We have all our stuff now on the cloud. I know some still like their own files on their own computer but it really useful for us to be able to access from different devices. We're doing the same with the village hall trustees stuff the previous chairman was suddenly ill and sadly died it took ages to access the stuff on his computer. We've told our kids our details so they could log into any documents they might need if we're both unable to help we're also looking at sorting out lpa,s

 

[Gellyneck]

I'm pretty sure you can download Google docs spreadsheets in odf format and excel.

Google Docs has supported ODF documents for about 10 years.

^{_{Subscribers  do not see these advertisements}}

 

[jongood]

We use google drive. If you create a document or spreadsheet it alters it constantly and saves it on the cloud. If its just personal use you'll never need to buy extra storage and you can access it on any device. It's free

How would I get on sending invoices to people? Would they then have access to my whole files? I currently copy a worksheet, save it as a new file and then attach it to an email.

 

[jongood]

Dropped OpenOffice in favour of LibreOffice (which was a fork of the former) a number of years ago and never had any problems.

It's Windows and Linux compatible which is also a benefit for me.

Home | LibreOffice - Free and private office suite - Based on OpenOffice - Compatible with Microsoft

Free office suite – the evolution of OpenOffice. Compatible with Microsoft .doc, .docx, .xls, .xlsx, .ppt, .pptx. Updated regularly, community powered.

www.libreoffice.org

That sounds like a good solution thanks

 

[NicM]

How would I get on sending invoices to people? Would they then have access to my whole files? I currently copy a worksheet, save it as a new file and then attach it to an email.

Would it not be better to save/print to PDF to send to people?

 

[Gellyneck]

How would I get on sending invoices to people? Would they then have access to my whole files? I currently copy a worksheet, save it as a new file and then attach it to an email.

If you do go down the LibreOffice route you can export your spreadsheet as a pdf file which virtually everybody has access to open \ read via their browser or installed app \ software.

 

[cyberyacht]

I have to use Libre Office to submit charity gift aid reclaims to HMRC as that is the only one they allow so must be adequate. You could always get a Mac and use Numbers!

I use Libre Office for the same purpose on my MacBook. Run a couple of simple macros on my own stuff. A you say, at least Libre Office will provide the requisite format spreadsheets. I take it that M$Office still don't. I haven't used it since Office 97.

^{_{Subscribers  do not see these advertisements}}

 

[Gellyneck]

I use Libre Office for the same purpose on my MacBook. Run a couple of simple macros on my own stuff. A you say, at least Libre Office will provide the requisite format spreadsheets. I take it that M$Office still don't. I haven't used it since Office 97.

ODF 1.3 support in current versions of MS Office since middle of last year.