You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@openoffice.apache.org by John Godfrey <jd...@shaw.ca> on 2016/04/22 20:34:56 UTC
Excell 2003+
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?
Thanks,
john
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@openoffice.apache.org
For additional commands, e-mail: dev-help@openoffice.apache.org
Re: Excell 2003+
Posted by toki <to...@gmail.com>.
On 22/04/2016 18:34, John Godfrey wrote:
> the sender told me it was generated by Excel 2003.
I'm guessing you made a typo for Excel 2013,
If it really is Excel 2003, and it really is an .xlsx file, then no the
issue will not fixed, because it can not be fixed. (IIRC, this is the
.xlsx version whose file format can't be shared with other computers,
with a subsequent patch from Microsoft removing that functionality.)
> Will there be an update to facilitate these files?
That depends upon why it won't open. Potential reasons are:
* The file is password protected;
* The file is encrypted;
* The file requires VBA libraries that AOo does not have access to;
* There is something in the file format that AOo doesn't understand, but
is otherwise valid;
* The file itself is corrupt. Try opening it with Excel, and see what
happens;
* Something else;
My guess is that the issue is VBA Libraries are not accessible. I might
be using the wrong name. These are the libraries used for the macro
language that Excel can understand.
jonathon
FW: Excell 2003+
Posted by "Dennis E. Hamilton" <de...@acm.org>.
> -----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
RE: Excell 2003+
Posted by "Dennis E. Hamilton" <de...@acm.org>.
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.
> -----Original Message-----
> From: John Godfrey [mailto:jdgodfrey@shaw.ca]
> Sent: Friday, April 22, 2016 17:50
> To: dev@openoffice.apache.org
> 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: dev-unsubscribe@openoffice.apache.org
> For additional commands, e-mail: dev-help@openoffice.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@openoffice.apache.org
For additional commands, e-mail: dev-help@openoffice.apache.org
Re: Excell 2003+
Posted by John Godfrey <jd...@shaw.ca>.
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: dev-unsubscribe@openoffice.apache.org
For additional commands, e-mail: dev-help@openoffice.apache.org
Re: Excell 2003+
Posted by Mechtilde <oo...@mechtilde.de>.
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
--
Mechtilde Stehmann
## Apache OpenOffice
## Debian
## Loook, calendar-exchange-provider, libreoffice-canzeley-client
## PGP encryption welcome
## Key-ID 0x141AAD7F