openoffice-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Dennis E. Hamilton" <dennis.hamil...@acm.org>
Subject FW: Excell 2003+
Date Tue, 26 Apr 2016 19:35:02 GMT
> -----Original Message-----
> From: John Godfrey [mailto:jdgodfrey@shaw.ca]
> Sent: Tuesday, April 26, 2016 07:34
> To: dennis.hamilton@acm.org
> Subject: Re: Excell 2003+
> 
> Problem solved.
> Thanks,
> John
> 
> 
> On 4/23/2016 9:40 AM, Dennis E. Hamilton wrote:
> > Please explain this part with more detail:
> >
> >> I employed a programmer to write script to enter data from a text
> file
> >> to an AOO spreadsheet saved as Excel. he did all the coding using
> Open
> >> XML SDK and the xlsx file he returned to me AOO will not open.
> >   0. First thing to try: Open the Excel document in a current version
> of Excel and do a Save As ... to any/all of .xls, .xlsx, and .ods and
> see how those come across to OpenOffice Calc.  We cannot help you with
> regard to Excel formats produced by other means, including the Open XML
> SDK.
> >
> >   1. If you want an AOO spreadsheet, that is, one in its native
> OpenDocument Spreadsheet format (.ods), it would seem to be the best
> thing to do is to use ODF (.ods) and not OOXML (.xlsx).
> >      1.1 The Open XML SDK won't work for that, however.
> >      1.2 You could explore the various ways of constructing a text
> file that can then be imported into OpenOffice Calc and saved as an
> .ods.
> >      1.3 Recent versions of Excel will also open Calc ODF documents,
> although you should experiment to be confident that the features of your
> spreadsheet are preserved properly when read this way by Excel.
> >
> >   2. If your specific requirement is to have an Excel Spreadsheet that
> works correctly, the easy way is to also construct a text file (as in
> 1.2, of CVS format) that can be imported into Excel and then, after any
> additional formatting, saved as either an .xls or .xlsx (OOXML) file.
> This is more likely to also be readable in OpenOffice Calc.  This is
> also one that we might be able to troubleshoot with respect to Apache
> OpenOffice (as in 0, above).
> >
> >   3. Please be aware that OpenOffice Calc was never designed to be a
> workalike substitute for Microsoft Office Excel and not all features of
> either are preserved by the other even though each support ODF and OOXML
> to some extent.
> >
> > I may have provided more information than is useful to you.  A lot
> will depend on case (0) above.  Start there.
> >
> >   - Dennis
> >
> > PS: Please continue this discussion on dev@openoffice.apache.org.  Any
> direct communication to me will be understood to include permission to
> post to dev@ as I see fit and all replies from me will go there also.
> >
[ ... ]


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


Mime
View raw message