Re: Version 4.1
Hi Michael, We have tested the file you sent and we can't replicate the problem. The sheet is very simple and if there was a bug in the software it would certainly be affecting many other people. So all I can think is that it is something in the way your system is set up. We know that a partial download can result in these symptoms. Did you check that the downloaded file was the full size it should be before installing it? It should be around 150 MB. If you have checked that and are sure it is not that, can you get a friend with a similar computer to download and install AOO and try it. If it works on their computer you can look for any differences between the two systems. On 20 October 2013 20:03, Rob Weir robw...@apache.org wrote: On Sun, Oct 20, 2013 at 6:03 AM, Michael Cleary ringolum...@yahoo.co.uk wrote: Good morning, As I was invited to upgrade to version 4.1, I did so. I am not a computer expert and struggle with the formulae on my homemade banking spread sheets but as they were functioning perfectly well before and now every cell shows an error 509. I have spent 2 hours this morning which I really can't afford, and I know I should try harder but frustration (and bad temper) is setting in, so can you please advise me as to what has caused (and the remedy please) these very simple formulae to now be incorrect as they were previously fine. They are very basic arithmetic formulae, nothing complex at all. Sorry to be a pain, Hi Michael, Thanks for letting us know. Would it be possible to get a simplified spreadsheet document that demonstrates the bug? (I assume you don't want to share your banking data). I'd be interested in trying this with an older version of OpenOffice and see if I can reproduce what you are seeing. Or, 9if you are not able to share a spreadsheet, can you narrow down exactly what part of the calculation changed? Regards, -Rob Very frustrated, Mike Cleary - To unsubscribe, e-mail: dev-unsubscr...@openoffice.apache.org For additional commands, e-mail: dev-h...@openoffice.apache.org -- Ian Ofqual Accredited IT Qualifications https://theingots.org/community/faq#7.0 Headline points in the 2014 and 2015 school league tables www.theINGOTs.org +44 (0)1827 305940 The Learning Machine Limited, Reg Office, Unit 4D Gagarin, Lichfield Road Industrial Estate, Tamworth, Staffordshire, B79 7GN. Reg No: 05560797, Registered in England and Wales.
Re: Version 4.1
On Sun, 20 Oct 2013 11:03:07 +0100 (BST) Michael Cleary ringolum...@yahoo.co.uk wrote: Good morning, As I was invited to upgrade to version 4.1, I did so. I am not a computer expert and struggle with the formulae on my homemade banking spread sheets but as they were functioning perfectly well before and now every cell shows an error 509. I have spent 2 hours this morning which I really can't afford, and I know I should try harder but frustration (and bad temper) is setting in, so can you please advise me as to what has caused (and the remedy please) these very simple formulae to now be incorrect as they were previously fine. They are very basic arithmetic formulae, nothing complex at all. Sorry to be a pain, Very frustrated, Mike Cleary The version upgrade was to 4.0.1 If you are getting error 509, look to see are arguments separated by commas and replace them with semicolons. -- Rory O'Farrell ofarr...@iol.ie - To unsubscribe, e-mail: dev-unsubscr...@openoffice.apache.org For additional commands, e-mail: dev-h...@openoffice.apache.org
Re: Version 4.1
Take a look at http://forum.openoffice.org/en/forum/viewtopic.php?f=9t=45671 Someone here had a similar problem due to an incomplete download. Try reinstalling to be sure you have the full software. You are not subscribed to the list so I have ccd the message to you as you won't see replies that are to the list only. On 20 October 2013 11:03, Michael Cleary ringolum...@yahoo.co.uk wrote: Good morning, As I was invited to upgrade to version 4.1, I did so. I am not a computer expert and struggle with the formulae on my homemade banking spread sheets but as they were functioning perfectly well before and now every cell shows an error 509. I have spent 2 hours this morning which I really can't afford, and I know I should try harder but frustration (and bad temper) is setting in, so can you please advise me as to what has caused (and the remedy please) these very simple formulae to now be incorrect as they were previously fine. They are very basic arithmetic formulae, nothing complex at all. Sorry to be a pain, Very frustrated, Mike Cleary -- Ian Ofqual Accredited IT Qualifications https://theingots.org/community/faq#7.0 Headline points in the 2014 and 2015 school league tables www.theINGOTs.org +44 (0)1827 305940 The Learning Machine Limited, Reg Office, Unit 4D Gagarin, Lichfield Road Industrial Estate, Tamworth, Staffordshire, B79 7GN. Reg No: 05560797, Registered in England and Wales.
Re: Version 4.1
On Sun, 20 Oct 2013 11:03:07 +0100 (BST) Michael Cleary ringolum...@yahoo.co.uk wrote: Good morning, As I was invited to upgrade to version 4.1, I did so. I am not a computer expert and struggle with the formulae on my homemade banking spread sheets but as they were functioning perfectly well before and now every cell shows an error 509. I have spent 2 hours this morning which I really can't afford, and I know I should try harder but frustration (and bad temper) is setting in, so can you please advise me as to what has caused (and the remedy please) these very simple formulae to now be incorrect as they were previously fine. They are very basic arithmetic formulae, nothing complex at all. Sorry to be a pain, Very frustrated, Mike Cleary If this is happening with all formulae it is worth trying the universal (first case) OpenOffice cure for oddities, namely to delete or rename the User Profile http://forum.openoffice.org/en/forum/viewtopic.php?f=74t=12426 -- Rory O'Farrell ofarr...@iol.ie - To unsubscribe, e-mail: dev-unsubscr...@openoffice.apache.org For additional commands, e-mail: dev-h...@openoffice.apache.org
Re: Version 4.1
Hiya, Have looked at the link and I'm sorry but just not able to sort this out. As I said, I'm not an expert and do not follow most of the terminology. That said, I'm most grateful to you guys for taking the time to help, thanks. Guess I'd better just get the pencil sharpener out. Thanks once again, Mike On Sunday, 20 October 2013, 13:09, Rory O'Farrell ofarr...@iol.ie wrote: On Sun, 20 Oct 2013 11:03:07 +0100 (BST) Michael Cleary ringolum...@yahoo.co.uk wrote: Good morning, As I was invited to upgrade to version 4.1, I did so. I am not a computer expert and struggle with the formulae on my homemade banking spread sheets but as they were functioning perfectly well before and now every cell shows an error 509. I have spent 2 hours this morning which I really can't afford, and I know I should try harder but frustration (and bad temper) is setting in, so can you please advise me as to what has caused (and the remedy please) these very simple formulae to now be incorrect as they were previously fine. They are very basic arithmetic formulae, nothing complex at all. Sorry to be a pain, Very frustrated, Mike Cleary If this is happening with all formulae it is worth trying the universal (first case) OpenOffice cure for oddities, namely to delete or rename the User Profile http://forum.openoffice.org/en/forum/viewtopic.php?f=74t=12426 -- Rory O'Farrell ofarr...@iol.ie
Re: Version 4.1
Have you tried uninstalling AOO, downloadong it again from http://www.openoffice.org/download/ and reinstalling? Chances are that if this error was a bug, other people would have reported it. So be sure you have the complete downlaod and installation running first. Back up any files first just to be sure they are safe and secure, uninstall AOO, download 4.01 from the AOO web site and install it. Open the files and see if the problem is still there. If it is send me a copy of a file and I can check it works here. If it does it is definitely something peculiar about your system set up if not you found a bug that needs to be fixed. On 20 October 2013 13:21, Michael Cleary ringolum...@yahoo.co.uk wrote: Hiya, Have looked at the link and I'm sorry but just not able to sort this out. As I said, I'm not an expert and do not follow most of the terminology. That said, I'm most grateful to you guys for taking the time to help, thanks. Guess I'd better just get the pencil sharpener out. Thanks once again, Mike On Sunday, 20 October 2013, 13:09, Rory O'Farrell ofarr...@iol.ie wrote: On Sun, 20 Oct 2013 11:03:07 +0100 (BST) Michael Cleary ringolum...@yahoo.co.uk wrote: Good morning, As I was invited to upgrade to version 4.1, I did so. I am not a computer expert and struggle with the formulae on my homemade banking spread sheets but as they were functioning perfectly well before and now every cell shows an error 509. I have spent 2 hours this morning which I really can't afford, and I know I should try harder but frustration (and bad temper) is setting in, so can you please advise me as to what has caused (and the remedy please) these very simple formulae to now be incorrect as they were previously fine. They are very basic arithmetic formulae, nothing complex at all. Sorry to be a pain, Very frustrated, Mike Cleary If this is happening with all formulae it is worth trying the universal (first case) OpenOffice cure for oddities, namely to delete or rename the User Profile http://forum.openoffice.org/en/forum/viewtopic.php?f=74t=12426 -- Rory O'Farrell ofarr...@iol.ie -- Ian Ofqual Accredited IT Qualifications https://theingots.org/community/faq#7.0 Headline points in the 2014 and 2015 school league tables www.theINGOTs.org +44 (0)1827 305940 The Learning Machine Limited, Reg Office, Unit 4D Gagarin, Lichfield Road Industrial Estate, Tamworth, Staffordshire, B79 7GN. Reg No: 05560797, Registered in England and Wales.
Re: Version 4.1
On Sun, Oct 20, 2013 at 6:03 AM, Michael Cleary ringolum...@yahoo.co.uk wrote: Good morning, As I was invited to upgrade to version 4.1, I did so. I am not a computer expert and struggle with the formulae on my homemade banking spread sheets but as they were functioning perfectly well before and now every cell shows an error 509. I have spent 2 hours this morning which I really can't afford, and I know I should try harder but frustration (and bad temper) is setting in, so can you please advise me as to what has caused (and the remedy please) these very simple formulae to now be incorrect as they were previously fine. They are very basic arithmetic formulae, nothing complex at all. Sorry to be a pain, Hi Michael, Thanks for letting us know. Would it be possible to get a simplified spreadsheet document that demonstrates the bug? (I assume you don't want to share your banking data). I'd be interested in trying this with an older version of OpenOffice and see if I can reproduce what you are seeing. Or, 9if you are not able to share a spreadsheet, can you narrow down exactly what part of the calculation changed? Regards, -Rob Very frustrated, Mike Cleary - To unsubscribe, e-mail: dev-unsubscr...@openoffice.apache.org For additional commands, e-mail: dev-h...@openoffice.apache.org