You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@openoffice.apache.org by Michael Cleary <ri...@yahoo.co.uk> on 2013/10/20 12:03:07 UTC
Version 4.1
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
Re: Version 4.1
Posted by Rory O'Farrell <of...@iol.ie>.
On Sun, 20 Oct 2013 11:03:07 +0100 (BST)
Michael Cleary <ri...@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 <of...@iol.ie>
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@openoffice.apache.org
For additional commands, e-mail: dev-help@openoffice.apache.org
Re: Version 4.1
Posted by Ian Lynch <ia...@gmail.com>.
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 <ri...@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 <of...@iol.ie> wrote:
>
> On Sun, 20 Oct 2013 11:03:07 +0100 (BST)
>
> Michael Cleary <ri...@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=74&t=12426
>
> --
> Rory O'Farrell <ofarrwrk@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
Posted by Michael Cleary <ri...@yahoo.co.uk>.
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 <of...@iol.ie> wrote:
On Sun, 20 Oct 2013 11:03:07 +0100 (BST)
Michael Cleary <ri...@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=74&t=12426
--
Rory O'Farrell <ofarrwrk@iol.ie
>
Re: Version 4.1
Posted by Rory O'Farrell <of...@iol.ie>.
On Sun, 20 Oct 2013 11:03:07 +0100 (BST)
Michael Cleary <ri...@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=74&t=12426
--
Rory O'Farrell <of...@iol.ie>
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@openoffice.apache.org
For additional commands, e-mail: dev-help@openoffice.apache.org
Re: Version 4.1
Posted by Ian Lynch <ia...@gmail.com>.
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 <ro...@apache.org> wrote:
> On Sun, Oct 20, 2013 at 6:03 AM, Michael Cleary <ri...@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-unsubscribe@openoffice.apache.org
> For additional commands, e-mail: dev-help@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
Posted by Rob Weir <ro...@apache.org>.
On Sun, Oct 20, 2013 at 6:03 AM, Michael Cleary <ri...@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-unsubscribe@openoffice.apache.org
For additional commands, e-mail: dev-help@openoffice.apache.org
Re: Version 4.1
Posted by Ian Lynch <ia...@gmail.com>.
Take a look at
http://forum.openoffice.org/en/forum/viewtopic.php?f=9&t=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 <ri...@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.