> -----Original Message----- > From: John Godfrey [mailto:[email protected]] > Sent: Tuesday, April 26, 2016 07:34 > To: [email protected] > 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 [email protected]. 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: [email protected] For additional commands, e-mail: [email protected]
