Date: prev next · Thread: first prev next last
2013 Archives by date, by thread · List index


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

Context


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.