Le 25/07/2011 13:10, George R. Kasica a écrit :
OK..that gets the file in, but the first 4 rows that are always locked with Headers get replaced as well even if I say from Line 4, and I've tried both before and after sheet options. Also there are some calc lines at the bottom that in Excel are automatically moved down if there is more data than what is there now. With Calc it blows them away and replaces them with data, BIG problem as some of the formulas are quite time consuming to reenter and there's at least one and possibly as much as 3 for each column (Max, Min, etc)
In such a situation, I import into a file (always named identically) which I then use as a source for an external worksheet where the actual computations are done. This way, the import never breaks anything.
-- Jean-Francois Nifenecker, Bordeaux -- Unsubscribe instructions: E-mail to users+h...@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