You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@openoffice.apache.org by "Dean.Webber" <20...@student.sit.ac.nz> on 2021/03/01 01:29:10 UTC

Re: What happens if you save a Calc file as Microsoft Excel 2003 XML (.xml) in Windows

Hi Everyone,

What happens if you 'save as' any basic calc file as "Microsoft Excel 2003 XML (.xml)" when using AOO in Windows. Does it crash?

Are the XML filters not installed by default? If not, they should be.

Source; OpenOffice on Windows 7 with Java (View topic) • Apache OpenOffice Community Forum<https://forum.openoffice.org/en/forum/viewtopic.php?f=15&t=104591&p=507213>

It is fine on my system - LMDE 4 Debbie using AOO 4.5.0, and "OpenJDK 11.0.9.1" (java-11-openjdk-amd64)

Thanks 🙂

Re: What happens if you save a Calc file as Microsoft Excel 2003 XML (.xml) in Windows

Posted by Pedro Lino <pe...@mailbox.org.INVALID>.
Hi all

My findings are exactly the same as those from Francis. Copying the contents to a new spreadsheet saves in XML 2003 without any issues. It is this specific ODS file that has a problem.

Curiously, the file saved as XML 2003 will not open correctly in OpenOffice...

Regards,
Pedro

> On 03/01/2021 7:29 PM F Campos Costero <fj...@gmail.com> wrote:
> the forum post saved as Microsoft Excel 2003 XML. However, I can't
> reproduce the error if I copy the file contents into a new file. I also
> tried reducing the original file to just the numbers 1,2,3,4 in A1:A4 and
> it still failed to save. I suspect a file-specific problem.
> regards,
> Francis
> 
> On Mon, Mar 1, 2021 at 11:56 AM Matthias Seidel <ma...@hamburg.de>
> wrote:
> 
> > Hi Francis,
> >
> > Am 01.03.21 um 05:10 schrieb F Campos Costero:
> > > I do not get a crash saving in the  "Microsoft Excel 2003 XML (.xml)"
> > > format using AOO 4.1.9 on Windows 10. I tested with a very simple file
> > > containing only a few numbers.
> >
> > I did tests with some simple spreadsheets and could save them as MS
> > Excel 2003 XML.
> >
> > But with test.ods [1] provided in the forum it fails even on Windows 10
> > for me.
> >
> > Can you confirm?
> >
> > Regards,
> >
> >    Matthias
> >
> > [1] https://forum.openoffice.org/en/forum/download/file.php?id=42715
> >
> > > Francis
> > >
> > > On Sun, Feb 28, 2021 at 6:29 PM Dean.Webber <
> > 2018001901@student.sit.ac.nz>
> > > wrote:
> > >
> > >> Hi Everyone,
> > >>
> > >> What happens if you 'save as' any basic calc file as "Microsoft Excel
> > 2003
> > >> XML (.xml)" when using AOO in Windows. Does it crash?
> > >>
> > >> Are the XML filters not installed by default? If not, they should be.
> > >>
> > >> Source; OpenOffice on Windows 7 with Java (View topic) • Apache
> > OpenOffice
> > >> Community Forum<
> > >>
> > https://forum.openoffice.org/en/forum/viewtopic.php?f=15&t=104591&p=507213
> > >> It is fine on my system - LMDE 4 Debbie using AOO 4.5.0, and "OpenJDK
> > >> 11.0.9.1" (java-11-openjdk-amd64)
> > >>
> > >> Thanks 🙂
> > >>
> >
> >

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


Re: What happens if you save a Calc file as Microsoft Excel 2003 XML (.xml) in Windows

Posted by F Campos Costero <fj...@gmail.com>.
Hi Matthias,
I get a "Write error: file could not be written" when I try the file from
the forum post saved as Microsoft Excel 2003 XML. However, I can't
reproduce the error if I copy the file contents into a new file. I also
tried reducing the original file to just the numbers 1,2,3,4 in A1:A4 and
it still failed to save. I suspect a file-specific problem.
regards,
Francis

On Mon, Mar 1, 2021 at 11:56 AM Matthias Seidel <ma...@hamburg.de>
wrote:

> Hi Francis,
>
> Am 01.03.21 um 05:10 schrieb F Campos Costero:
> > I do not get a crash saving in the  "Microsoft Excel 2003 XML (.xml)"
> > format using AOO 4.1.9 on Windows 10. I tested with a very simple file
> > containing only a few numbers.
>
> I did tests with some simple spreadsheets and could save them as MS
> Excel 2003 XML.
>
> But with test.ods [1] provided in the forum it fails even on Windows 10
> for me.
>
> Can you confirm?
>
> Regards,
>
>    Matthias
>
> [1] https://forum.openoffice.org/en/forum/download/file.php?id=42715
>
> > Francis
> >
> > On Sun, Feb 28, 2021 at 6:29 PM Dean.Webber <
> 2018001901@student.sit.ac.nz>
> > wrote:
> >
> >> Hi Everyone,
> >>
> >> What happens if you 'save as' any basic calc file as "Microsoft Excel
> 2003
> >> XML (.xml)" when using AOO in Windows. Does it crash?
> >>
> >> Are the XML filters not installed by default? If not, they should be.
> >>
> >> Source; OpenOffice on Windows 7 with Java (View topic) • Apache
> OpenOffice
> >> Community Forum<
> >>
> https://forum.openoffice.org/en/forum/viewtopic.php?f=15&t=104591&p=507213
> >> It is fine on my system - LMDE 4 Debbie using AOO 4.5.0, and "OpenJDK
> >> 11.0.9.1" (java-11-openjdk-amd64)
> >>
> >> Thanks 🙂
> >>
>
>

Re: What happens if you save a Calc file as Microsoft Excel 2003 XML (.xml) in Windows

Posted by Matthias Seidel <ma...@hamburg.de>.
Hi Francis,

Am 01.03.21 um 05:10 schrieb F Campos Costero:
> I do not get a crash saving in the  "Microsoft Excel 2003 XML (.xml)"
> format using AOO 4.1.9 on Windows 10. I tested with a very simple file
> containing only a few numbers.

I did tests with some simple spreadsheets and could save them as MS
Excel 2003 XML.

But with test.ods [1] provided in the forum it fails even on Windows 10
for me.

Can you confirm?

Regards,

   Matthias

[1] https://forum.openoffice.org/en/forum/download/file.php?id=42715

> Francis
>
> On Sun, Feb 28, 2021 at 6:29 PM Dean.Webber <20...@student.sit.ac.nz>
> wrote:
>
>> Hi Everyone,
>>
>> What happens if you 'save as' any basic calc file as "Microsoft Excel 2003
>> XML (.xml)" when using AOO in Windows. Does it crash?
>>
>> Are the XML filters not installed by default? If not, they should be.
>>
>> Source; OpenOffice on Windows 7 with Java (View topic) • Apache OpenOffice
>> Community Forum<
>> https://forum.openoffice.org/en/forum/viewtopic.php?f=15&t=104591&p=507213
>> It is fine on my system - LMDE 4 Debbie using AOO 4.5.0, and "OpenJDK
>> 11.0.9.1" (java-11-openjdk-amd64)
>>
>> Thanks 🙂
>>


Re: What happens if you save a Calc file as Microsoft Excel 2003 XML (.xml) in Windows

Posted by F Campos Costero <fj...@gmail.com>.
I do not get a crash saving in the  "Microsoft Excel 2003 XML (.xml)"
format using AOO 4.1.9 on Windows 10. I tested with a very simple file
containing only a few numbers.
Francis

On Sun, Feb 28, 2021 at 6:29 PM Dean.Webber <20...@student.sit.ac.nz>
wrote:

> Hi Everyone,
>
> What happens if you 'save as' any basic calc file as "Microsoft Excel 2003
> XML (.xml)" when using AOO in Windows. Does it crash?
>
> Are the XML filters not installed by default? If not, they should be.
>
> Source; OpenOffice on Windows 7 with Java (View topic) • Apache OpenOffice
> Community Forum<
> https://forum.openoffice.org/en/forum/viewtopic.php?f=15&t=104591&p=507213
> >
>
> It is fine on my system - LMDE 4 Debbie using AOO 4.5.0, and "OpenJDK
> 11.0.9.1" (java-11-openjdk-amd64)
>
> Thanks 🙂
>

Re: What happens if you save a Calc file as Microsoft Excel 2003 XML (.xml) in Windows

Posted by Matthias Seidel <ma...@hamburg.de>.
Hi all,

Am 01.03.21 um 16:34 schrieb Matthias Seidel:
> Hi Dean,
>
> Am 01.03.21 um 02:29 schrieb Dean.Webber:
>> Hi Everyone,
>>
>> What happens if you 'save as' any basic calc file as "Microsoft Excel 2003 XML (.xml)" when using AOO in Windows. Does it crash?
> On Windows 10 Pro 64-bit with AOO 4.1.9 and a simple Calc file I have no
> problem saving as MS Excel 2003 XML.
>
> But with Windows 7 32-bit and AOO 4.1.9 I get the same error message
> like in the forum.

That's funny: If I first save the file as .ods and then save as MS Excel
2003 XML right after that it also works on Windows 7 32-bit.

Maybe this could be a workaround?

Regards,

   Matthias

>
>> Are the XML filters not installed by default?
> They are included in the default installation on Windows since AOO 4.1.6.
>>  If not, they should be.
> I don't think this is the problem here. It looks like a problem on
> 32-bit systems.
> (Maybe someone with Linux 32-bit could cross check?)
>
> Windows 7 is EOL for almost a year, but the user should open a bug
> report for that.
>
> Regards,
>
>    Matthias
>
>> Source; OpenOffice on Windows 7 with Java (View topic) • Apache OpenOffice Community Forum<https://forum.openoffice.org/en/forum/viewtopic.php?f=15&t=104591&p=507213>
>>
>> It is fine on my system - LMDE 4 Debbie using AOO 4.5.0, and "OpenJDK 11.0.9.1" (java-11-openjdk-amd64)
>>
>> Thanks 🙂


Re: What happens if you save a Calc file as Microsoft Excel 2003 XML (.xml) in Windows

Posted by Matthias Seidel <ma...@hamburg.de>.
Hi Dean,

Am 01.03.21 um 02:29 schrieb Dean.Webber:
> Hi Everyone,
>
> What happens if you 'save as' any basic calc file as "Microsoft Excel 2003 XML (.xml)" when using AOO in Windows. Does it crash?

On Windows 10 Pro 64-bit with AOO 4.1.9 and a simple Calc file I have no
problem saving as MS Excel 2003 XML.

But with Windows 7 32-bit and AOO 4.1.9 I get the same error message
like in the forum.

>
> Are the XML filters not installed by default?
They are included in the default installation on Windows since AOO 4.1.6.
>  If not, they should be.

I don't think this is the problem here. It looks like a problem on
32-bit systems.
(Maybe someone with Linux 32-bit could cross check?)

Windows 7 is EOL for almost a year, but the user should open a bug
report for that.

Regards,

   Matthias

>
> Source; OpenOffice on Windows 7 with Java (View topic) • Apache OpenOffice Community Forum<https://forum.openoffice.org/en/forum/viewtopic.php?f=15&t=104591&p=507213>
>
> It is fine on my system - LMDE 4 Debbie using AOO 4.5.0, and "OpenJDK 11.0.9.1" (java-11-openjdk-amd64)
>
> Thanks 🙂