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.
> -----Original Message-----
> From: John Godfrey [mailto:[email protected]]
> Sent: Friday, April 22, 2016 17:50
> To: [email protected]
> Subject: Re: Excell 2003+
>
> Hi.
> Thanks for your response.
> 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.
> Just wonderinig why,
> Thanks,
> John
>
>
> On 4/22/2016 11:49 AM, Mechtilde wrote:
> > Hello
> >
> > Am 22.04.2016 um 20:34 schrieb John Godfrey:
> >> Hi all.
> >> I am a user, but not a developer.
> >> I was recently sent an excell.xlsx file AOO could not open. the
> sender
> >> told me it was generated by Excel 2003. Will there be an update to
> >> facilitate these files?
> > Excel 2003 can only save as *.xls. Only versions >= 2007 can save
> files
> > as *.xlsx and normaly AOO can open as *.xls as *.xlsx.
> >
> > Regards
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: [email protected]
> For additional commands, e-mail: [email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
