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

Hi :)
I find that stuff converted from MSO formats is not always as good as a fresh re-write or rather 
create a new document and then copy&paste all the old stuff in from the older document but use 
Shift v
and paste in as "Unformatted text".  MSO likes to hide all sorts of weird nasty coding and 
formatting into their documents so a fresh start can be a huge step forwards and even odd extras 
such as reduced file-sizes a little bit.  

Office workers used to start new documents by grabbing an old one and deleting everything out of it 
and then starting from there.  All sorts of information about previous authors and ancient systems 
logged in the coding.  It would not surprise me to find documents mentioning Win95 and Word 
Perfect.  Decluttering is a good move.
Regards from 
Tom :)  





> ________________________________
> From: les <hlhowell@pacbell.net>
> To: Karen DInse <kdinse@rrwrd.dst.il.us> 
> Cc: users@global.libreoffice.org 
> Sent: Wednesday, 10 April 2013, 17:34
> Subject: 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
-- 
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