Have a question please

[Cindy Wardle <ci...@mepotelco.net>]

Hi,

I have Openoffice and have loved it for several years now.  But just 
recently when I went to open up my saved document spreadsheet it takes 
about 5 minutes to open up my saved copies.  They are just stand 
spreadsheets with a description line, cost, sold, fees and ending 
total.  The entire file so far this year is 2.0 MB.

Once it does open up and type any more information to it and then click 
Save..........it takes that same length of time to save the information.

On the community forum they want me to upload the file but I don't want 
to share all of that information.  Any ideas of what else could be wrong 
that I could check on my end?

Thanks for your time,
Cindy

Re: Have a question please

[Martin Groenescheij <ma...@groenescheij.com>]

On 21/10/18 12:33 pm, Cindy Wardle wrote:
> Hi,
>
> I have Openoffice and have loved it for several years now.  But just 
> recently when I went to open up my saved document spreadsheet it takes 
> about 5 minutes to open up my saved copies.  They are just stand 
> spreadsheets with a description line, cost, sold, fees and ending 
> total.  The entire file so far this year is 2.0 MB.

OpenOffice saves the documents as zipped files, when you open the 
spreadsheet OpenOffice will unzip the file which will take some time.
But this will not take 5 minutes, so I assume there could be something 
else that slowdown the process. It could be the complexity of the
calculations it need to perform. If you link to an other spreadsheet it 
will update (refresh) the links in your working document.
There are a few test you can do to see where the bottleneck could be.
1. Under Tools -> Cells uncheck the AutoCalculate option and see if that 
speedup the saving process.
2. Under Edit -> Links you can disable the Auto Update function (only if 
you have linked documents)

>
> Once it does open up and type any more information to it and then 
> click Save..........it takes that same length of time to save the 
> information.
>
> On the community forum they want me to upload the file but I don't 
> want to share all of that information.  Any ideas of what else could 
> be wrong that I could check on my end?
>
> Thanks for your time,
> Cindy
>


---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@openoffice.apache.org
For additional commands, e-mail: users-help@openoffice.apache.org

Re: Have a question please

[Maurice Howe <ma...@gmail.com>]

If you take R. Funnell's advice BE DAMNED SURE YOU MAKE THOSE CHANGES TO A
*C*O*P*Y* (not the original) !!!!!!!

On Sun, Oct 21, 2018 at 12:06 AM W. Robert J. Funnell, Prof. <
robert.funnell@mcgill.ca> wrote:

> On Sun, 21 Oct 2018, Cindy Wardle wrote:
>
> > Hi,
> >
> > I have Openoffice and have loved it for several years now.  But just
> recently
> > when I went to open up my saved document spreadsheet it takes about 5
> minutes
> > to open up my saved copies.  They are just stand spreadsheets with a
> > description line, cost, sold, fees and ending total.  The entire file so
> far
> > this year is 2.0 MB.
> >
> > Once it does open up and type any more information to it and then click
> > Save..........it takes that same length of time to save the information.
> >
> > On the community forum they want me to upload the file but I don't want
> to
> > share all of that information.  Any ideas of what else could be wrong
> that I
> > could check on my end?
> >
> > Thanks for your time,
> > Cindy
>
> It is possible to remove your private information before uploading the
> file. For example, in Find & Replace, make sure 'Regular expressions'
> are enabled and ask it to replace all '[a-z]' by 'x'. All of the
> lowercase letters will be replaced by 'x'. You can also replace
> '[A-Z]' and '[0-9]' if you want. Make sure the problem still occurs
> after doing it.
>
> - Robert
>

Re: Have a question please

["W. Robert J. Funnell, Prof." <ro...@mcgill.ca>]

On Sun, 21 Oct 2018, Cindy Wardle wrote:

> Hi,
>
> I have Openoffice and have loved it for several years now.  But just recently 
> when I went to open up my saved document spreadsheet it takes about 5 minutes 
> to open up my saved copies.  They are just stand spreadsheets with a 
> description line, cost, sold, fees and ending total.  The entire file so far 
> this year is 2.0 MB.
>
> Once it does open up and type any more information to it and then click 
> Save..........it takes that same length of time to save the information.
>
> On the community forum they want me to upload the file but I don't want to 
> share all of that information.  Any ideas of what else could be wrong that I 
> could check on my end?
>
> Thanks for your time,
> Cindy

It is possible to remove your private information before uploading the 
file. For example, in Find & Replace, make sure 'Regular expressions' 
are enabled and ask it to replace all '[a-z]' by 'x'. All of the 
lowercase letters will be replaced by 'x'. You can also replace 
'[A-Z]' and '[0-9]' if you want. Make sure the problem still occurs 
after doing it.

- Robert

Re: Have a question please

[Luis Iglesias <lu...@vigo.org>]

----- Mensaje original -----
> De: "Cindy Wardle" <ci...@mepotelco.net>
> Para: users@openoffice.apache.org
> Enviados: Domingo, 21 de Octubre 2018 3:33:29
> Asunto: Have a question please

> Hi,
> 
> I have Openoffice and have loved it for several years now.  But just
> recently when I went to open up my saved document spreadsheet it takes
> about 5 minutes to open up my saved copies.  They are just stand
> spreadsheets with a description line, cost, sold, fees and ending
> total.  The entire file so far this year is 2.0 MB.
> 
> Once it does open up and type any more information to it and then click
> Save..........it takes that same length of time to save the information.
> 
> On the community forum they want me to upload the file but I don't want
> to share all of that information.  Any ideas of what else could be wrong
> that I could check on my end?
> 
> Thanks for your time,
> Cindy

Well, maybe the problem is about file format you are using. Are you using ods or maybe xls or xlsx?
If you are using xls or xlsx, I'd suggest you to save it as ODF Spreadsheet (*.ods)
If you are already using ODS format then I'd suggest you to select only the cells with content and paste them into a new spreadsheet. Save that new spreadsheet with a different file name and test if it opens faster.
If I can't take a look at your spreasheet there's nothing more I can say.
Good luck!

---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@openoffice.apache.org
For additional commands, e-mail: users-help@openoffice.apache.org