Re: [libreoffice-users] Re: [SOLVED] Calc sheet freezing

On Wed, 2013-04-10 at 05:49 -0700, Karen DInse wrote:
> V Stuart Foote wrote
> > Several ways of answering this come to mind, but I'll go with the gentler
> > tact.
> >
> > You have some questions to ask yourself (and your collaborators).
> >
> > What is your desired end use--will this Excel 2003 spread sheet continue
> > to be used on Excel 2003?
> >
> > If not will your use be exclusively on LibreOffice or a mix of Apache
> > OpenOffice and LibreOffice?
> >
> > Do you or some number of your users understand what data is being charted
> > and how? Are you (they) familiar with both the Microsoft macros and the
> > LibreOffice macros?
> >
> > Where I'm going is that depending on your intended use, you will need to
> > --port-- the spread sheet either for use in calc.  But likely for use in
> > Excel 2007, or  2010 or 2012-- there is that much variation in the macro
> > scripting between the Microsoft products.
> >
> > Sorry, but without seeing the function and logic of your existing spread
> > sheet, the most we'll be able to do is suggest steps in doing a port.
>
> Thanks for the insight.  Sorry it's taken so long to reply. 
>
> After discussing with 'the powers that be', the decision was to recreate the
> data and graphs in Calc.  Our goal is to get rid of MSO, so we need to move
> forward.  Some users will still use MSO until we can get everyone moved to
> Libre office.  Their concern was in opening 'older. legacy versions' of the
> spreadsheet.  We have that covered for now.
>
> After spending a couple of days working on the spreadsheet in Calc, we have
> not encountered the 'freezing up' problem.  Must have been MSO that was
> acting strange!
>
>
>
> --
> View this message in context: 
> http://nabble.documentfoundation.org/Calc-sheet-freezing-tp4048140p4049026.html
> Sent from the Users mailing list archive at Nabble.com.

I use Calc a lot for various simulation tasks, and with the installation
of F17, I have had numerous new spreadsheets behave very badly with any
graph I put in them.  The hard to believe part is that older
spreadsheets, created with F15 and before all work well.  I have
basically held off on some new work because this is too difficult to
resolve.  Moreover, if I play with various things from time to time I
will get it to run as before, but I cannot get a consistant setup that
makes it so.  I did submit a bugzilla earlier, but have not seen any
response that showed a fix.

Basically any new graph seems to completely refresh the screen and take
a very long time, about 1 or 2 seconds for every cell used in the graph.

If more information will help, ask and I will send what I can.

Regards,
Les Howell.


-- 
For unsubscribe instructions e-mail to: users+help@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted