[Calc, LibO 4.4] Bug on .ODS to .XLSX file conversion?

classic Classic list List threaded Threaded
15 messages Options
RamonTavarez RamonTavarez
Reply | Threaded
Open this post in threaded view
|

[Calc, LibO 4.4] Bug on .ODS to .XLSX file conversion?

This post was updated on .
Hi:

I've experienced the following issue:

The file attached is an .ODS file (1,976 KB).  When seved as  .XLSX file it expands to more than 15 MB.

If the new .XLSX files is oppened with MSOffice 2013 it will ask for recovery of information within the file,  after that if we save the recovered file to the same file type (.XLSX) the file shrinks to 2,393KB.

Why?

OBRA_CIVIL_TERMINACION_ESTACION_Y_MODULO_ENTRADA_EST_21_LINEA_2B_abril_2015.ods

Here is the .XLS file saved with MSOffice 2013:

OBRA_CIVIL_TERMINACION_ESTACION_Y_MODULO_ENTRADA_EST_21_LINEA_2B_abril_2015.xlsx
TomD TomD
Reply | Threaded
Open this post in threaded view
|

Re: [Calc, LibO 4.4] Bug on .ODS to .XLSX file conversion?

Hi :)
The XlsX, and other OOXML formats are notoriously unreliable.  Each
different version of MS Office uses slightly different versions.  There are
at least 3 different "transitional" versions of the format and they are not
always compatible with each other.

If you take the XlsX that was saved by MS Office 2013 and try opening it in
another version of MS Office, say 2010 or 2007, or even 365 then you may
well find it's been opened in "Compatibility Mode" or even that it doesn't
work at all in extreme cases.  Chances are that some things will have moved
around or vanished, especially if you have anything in a frame (such as
images).

It makes a bit of sense that a file created with newer software might not
fare too well on older versions of the same program but with XlsX and the
other OOXML formats it even seems to happen the other way around.  Save a
file in MS Office 2007 and you get the same problems trying to open that
file in more recent versions of MS Office.


MS keep the specs for their formats secret.  There is an ISO definition of
OOXML but that doesn't seem to work in any version of MS Office.  MSO 2013
was the first that allowed people to save in "strict" but the resultant
files don't seem to be able to be opened in any version of MS Office.

So pretty much all programs struggle with trying to read or write XlsX or
other OOXML files in any reliable way.  Which version of MS Office should
they aim for?

Actually we had a few times where the LibreOffice user in an office has
been the only person able to open files from colleagues using different
versions of MS Office and has then become a kinda stepping stone for
sharing files between those colleagues.  Similarly with OpenOffice.


Best advice seems to be to use either;
1.  the older MS Office format, Xls (without the X on the end), for MS
Office Xp/2000 and prior or
2.  stick with Ods.

Microsoft, in their 2010 version, refused to use the ODF 1.2 format that
everyone else was using at the time and stuck with a mangled version of the
older 1.0 (even ignoring the 1.1) and somehow that led to Ods appearing to
open just fine but all the formulas got replaced by fixed values.  Their
apparent failure somehow led to people saying that everyone else made bad
spreadsheet programs and everyone should stick with MS.


So it is well worth avoiding XlsX and it is probably best to use their
older Xls format instead - at least if you want to open the spreadsheet on
any machine other than the one with MS Office 2013 on.

Regards from
Tom :)




On 23 April 2015 at 15:03, RamonTavarez <[hidden email]> wrote:

> Hi:
>
> I've experienced the following issue:
>
> The file attached is an .ODS file (1,976 KB).  When seved as  .XLSX file it
> expands to more than 15 MB.
>
> If the new .XLSX files is oppened with MSOffice 2013 it will ask for
> recovery of information within the file,  after that if we save the
> recovered file to the same file type (.XLSX) the file shrinks to 2,393KB.
>
> Why?
>
>
> OBRA_CIVIL_TERMINACION_ESTACION_Y_MODULO_ENTRADA_EST_21_LINEA_2B_abril_2015.ods
> <
> http://nabble.documentfoundation.org/file/n4147038/OBRA_CIVIL_TERMINACION_ESTACION_Y_MODULO_ENTRADA_EST_21_LINEA_2B_abril_2015.ods
> >
>
>
>
> --
> View this message in context:
> http://nabble.documentfoundation.org/Calc-LibO-4-4-Bug-on-ODS-to-XLSX-file-conversion-tp4147038.html
> Sent from the Users mailing list archive at Nabble.com.
>
> --
> To unsubscribe e-mail to: [hidden email]
> Problems?
> http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
> Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
> List archive: http://listarchives.libreoffice.org/global/users/
> All messages sent to this list will be publicly archived and cannot be
> deleted
>
>

--
To unsubscribe e-mail to: [hidden email]
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted
RamonTavarez RamonTavarez
Reply | Threaded
Open this post in threaded view
|

Re: [Calc, LibO 4.4] Bug on .ODS to .XLSX file conversion?

Hi:

Thanks for your attention.

The fact with this file is that can't be supported by .XLS format, and my
coworkers doesn't work with LibO, and that is the only way I can use to
"keep in touch" with them and their jobs. It may be a pain .. ... ... ,
but while it work I'll keep using this method to share my jobs with them!

In  use LibO for every document  I  create, even I update every version of
LibO  as the module for my Linux distro: Porteus.

On the other hand,I can understand the situation with MSOffice and how they
refuse the OpenDocument formats, but I still worry about   the big  file
size for those files not supported by the "classical" file type.

This can lead erroneously, as you said,  to people to believe that everyone
else made bad spreadsheet programs and everyone should stick with MS.

Thanks.

*Ramón E. Tavárez B.*

On Thu, Apr 23, 2015 at 10:47 AM, Tom Davies <[hidden email]> wrote:

> Hi :)
> The XlsX, and other OOXML formats are notoriously unreliable.  Each
> different version of MS Office uses slightly different versions.  There are
> at least 3 different "transitional" versions of the format and they are not
> always compatible with each other.
>
> If you take the XlsX that was saved by MS Office 2013 and try opening it
> in another version of MS Office, say 2010 or 2007, or even 365 then you may
> well find it's been opened in "Compatibility Mode" or even that it doesn't
> work at all in extreme cases.  Chances are that some things will have moved
> around or vanished, especially if you have anything in a frame (such as
> images).
>
> It makes a bit of sense that a file created with newer software might not
> fare too well on older versions of the same program but with XlsX and the
> other OOXML formats it even seems to happen the other way around.  Save a
> file in MS Office 2007 and you get the same problems trying to open that
> file in more recent versions of MS Office.
>
>
> MS keep the specs for their formats secret.  There is an ISO definition of
> OOXML but that doesn't seem to work in any version of MS Office.  MSO 2013
> was the first that allowed people to save in "strict" but the resultant
> files don't seem to be able to be opened in any version of MS Office.
>
> So pretty much all programs struggle with trying to read or write XlsX or
> other OOXML files in any reliable way.  Which version of MS Office should
> they aim for?
>
> Actually we had a few times where the LibreOffice user in an office has
> been the only person able to open files from colleagues using different
> versions of MS Office and has then become a kinda stepping stone for
> sharing files between those colleagues.  Similarly with OpenOffice.
>
>
> Best advice seems to be to use either;
> 1.  the older MS Office format, Xls (without the X on the end), for MS
> Office Xp/2000 and prior or
> 2.  stick with Ods.
>
> Microsoft, in their 2010 version, refused to use the ODF 1.2 format that
> everyone else was using at the time and stuck with a mangled version of the
> older 1.0 (even ignoring the 1.1) and somehow that led to Ods appearing to
> open just fine but all the formulas got replaced by fixed values.  Their
> apparent failure somehow led to people saying that everyone else made bad
> spreadsheet programs and everyone should stick with MS.
>
>
> So it is well worth avoiding XlsX and it is probably best to use their
> older Xls format instead - at least if you want to open the spreadsheet on
> any machine other than the one with MS Office 2013 on.
>
> Regards from
> Tom :)
>
>
>
>
> On 23 April 2015 at 15:03, RamonTavarez <[hidden email]> wrote:
>
>> Hi:
>>
>> I've experienced the following issue:
>>
>> The file attached is an .ODS file (1,976 KB).  When seved as  .XLSX file
>> it
>> expands to more than 15 MB.
>>
>> If the new .XLSX files is oppened with MSOffice 2013 it will ask for
>> recovery of information within the file,  after that if we save the
>> recovered file to the same file type (.XLSX) the file shrinks to 2,393KB.
>>
>> Why?
>>
>>
>> OBRA_CIVIL_TERMINACION_ESTACION_Y_MODULO_ENTRADA_EST_21_LINEA_2B_abril_2015.ods
>> <
>> http://nabble.documentfoundation.org/file/n4147038/OBRA_CIVIL_TERMINACION_ESTACION_Y_MODULO_ENTRADA_EST_21_LINEA_2B_abril_2015.ods
>> >
>>
>>
>>
>> --
>> View this message in context:
>> http://nabble.documentfoundation.org/Calc-LibO-4-4-Bug-on-ODS-to-XLSX-file-conversion-tp4147038.html
>> Sent from the Users mailing list archive at Nabble.com.
>>
>> --
>> To unsubscribe e-mail to: [hidden email]
>> Problems?
>> http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
>> Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
>> List archive: http://listarchives.libreoffice.org/global/users/
>> All messages sent to this list will be publicly archived and cannot be
>> deleted
>>
>>
>

--
To unsubscribe e-mail to: [hidden email]
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted
James Knott James Knott
Reply | Threaded
Open this post in threaded view
|

Re: [Calc, LibO 4.4] Bug on .ODS to .XLSX file conversion?

In reply to this post by TomD
On 04/23/2015 10:47 AM, Tom Davies wrote:
> MSO 2013
> was the first that allowed people to save in "strict" but the resultant
> files don't seem to be able to be opened in any version of MS Office.

Those files are probably write only.  ;-)


--
To unsubscribe e-mail to: [hidden email]
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted
TomD TomD
Reply | Threaded
Open this post in threaded view
|

Re: [Calc, LibO 4.4] Bug on .ODS to .XLSX file conversion?

In reply to this post by RamonTavarez
Hi :)
Yeh, i don't know a good way around that :(  other than the way you already
use! :))


People used to be quite happy with the idea of downloading Adobe Acrobat to
read Pdfs with.  It used to be that almost any website that shared any kind
of document tended to only have them as Pdfs and also then 'had to' have a
button to help people download and install an Adobe Pdf Reader.  We hardly
see any of that these days but that is quite a recent change.

There were objections from people working in the council, or other
government offices or in big companies that they couldn't install anything
and thus couldn't use the format that everyone else seemed to be using so
much.  Now they seem to use Pdf more than everyone else, and even demand
that other people use it!

Regards from
Tom :)





On 23 April 2015 at 16:08, Ramon Tavarez <[hidden email]> wrote:

> Hi:
>
> Thanks for your attention.
>
> The fact with this file is that can't be supported by .XLS format, and my
> coworkers doesn't work with LibO, and that is the only way I can use to
> "keep in touch" with them and their jobs. It may be a pain .. ... ... ,
> but while it work I'll keep using this method to share my jobs with them!
>
> In  use LibO for every document  I  create, even I update every version of
> LibO  as the module for my Linux distro: Porteus.
>
> On the other hand,I can understand the situation with MSOffice and how
> they refuse the OpenDocument formats, but I still worry about   the big
>  file size for those files not supported by the "classical" file type.
>
> This can lead erroneously, as you said,  to people to believe that
> everyone else made bad spreadsheet programs and everyone should stick with
> MS.
>
> Thanks.
>
> *Ramón E. Tavárez B.*
>
> On Thu, Apr 23, 2015 at 10:47 AM, Tom Davies <[hidden email]> wrote:
>
>> Hi :)
>> The XlsX, and other OOXML formats are notoriously unreliable.  Each
>> different version of MS Office uses slightly different versions.  There are
>> at least 3 different "transitional" versions of the format and they are not
>> always compatible with each other.
>>
>> If you take the XlsX that was saved by MS Office 2013 and try opening it
>> in another version of MS Office, say 2010 or 2007, or even 365 then you may
>> well find it's been opened in "Compatibility Mode" or even that it doesn't
>> work at all in extreme cases.  Chances are that some things will have moved
>> around or vanished, especially if you have anything in a frame (such as
>> images).
>>
>> It makes a bit of sense that a file created with newer software might not
>> fare too well on older versions of the same program but with XlsX and the
>> other OOXML formats it even seems to happen the other way around.  Save a
>> file in MS Office 2007 and you get the same problems trying to open that
>> file in more recent versions of MS Office.
>>
>>
>> MS keep the specs for their formats secret.  There is an ISO definition
>> of OOXML but that doesn't seem to work in any version of MS Office.  MSO
>> 2013 was the first that allowed people to save in "strict" but the
>> resultant files don't seem to be able to be opened in any version of MS
>> Office.
>>
>> So pretty much all programs struggle with trying to read or write XlsX or
>> other OOXML files in any reliable way.  Which version of MS Office should
>> they aim for?
>>
>> Actually we had a few times where the LibreOffice user in an office has
>> been the only person able to open files from colleagues using different
>> versions of MS Office and has then become a kinda stepping stone for
>> sharing files between those colleagues.  Similarly with OpenOffice.
>>
>>
>> Best advice seems to be to use either;
>> 1.  the older MS Office format, Xls (without the X on the end), for MS
>> Office Xp/2000 and prior or
>> 2.  stick with Ods.
>>
>> Microsoft, in their 2010 version, refused to use the ODF 1.2 format that
>> everyone else was using at the time and stuck with a mangled version of the
>> older 1.0 (even ignoring the 1.1) and somehow that led to Ods appearing to
>> open just fine but all the formulas got replaced by fixed values.  Their
>> apparent failure somehow led to people saying that everyone else made bad
>> spreadsheet programs and everyone should stick with MS.
>>
>>
>> So it is well worth avoiding XlsX and it is probably best to use their
>> older Xls format instead - at least if you want to open the spreadsheet on
>> any machine other than the one with MS Office 2013 on.
>>
>> Regards from
>> Tom :)
>>
>>
>>
>>
>> On 23 April 2015 at 15:03, RamonTavarez <[hidden email]> wrote:
>>
>>> Hi:
>>>
>>> I've experienced the following issue:
>>>
>>> The file attached is an .ODS file (1,976 KB).  When seved as  .XLSX file
>>> it
>>> expands to more than 15 MB.
>>>
>>> If the new .XLSX files is oppened with MSOffice 2013 it will ask for
>>> recovery of information within the file,  after that if we save the
>>> recovered file to the same file type (.XLSX) the file shrinks to 2,393KB.
>>>
>>> Why?
>>>
>>>
>>> OBRA_CIVIL_TERMINACION_ESTACION_Y_MODULO_ENTRADA_EST_21_LINEA_2B_abril_2015.ods
>>> <
>>> http://nabble.documentfoundation.org/file/n4147038/OBRA_CIVIL_TERMINACION_ESTACION_Y_MODULO_ENTRADA_EST_21_LINEA_2B_abril_2015.ods
>>> >
>>>
>>>
>>>
>>> --
>>> View this message in context:
>>> http://nabble.documentfoundation.org/Calc-LibO-4-4-Bug-on-ODS-to-XLSX-file-conversion-tp4147038.html
>>> Sent from the Users mailing list archive at Nabble.com.
>>>
>>> --
>>> To unsubscribe e-mail to: [hidden email]
>>> Problems?
>>> http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
>>> Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
>>> List archive: http://listarchives.libreoffice.org/global/users/
>>> All messages sent to this list will be publicly archived and cannot be
>>> deleted
>>>
>>>
>>
>

--
To unsubscribe e-mail to: [hidden email]
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted
Cley Faye Cley Faye
Reply | Threaded
Open this post in threaded view
|

Re: [Calc, LibO 4.4] Bug on .ODS to .XLSX file conversion?

Discussion about open formats aside, I've looked at the file and it looks
like when saving as xlsx each sheet grow huge (some goes to ~20MB before
compression).

Could you also post the xlsx file obtained when saving with MSO, for
comparison? My guess is that either LO saves *a lot* of empty/dummy cells,
or that it saves in an older xlsx format that is less compact.

btw this is only a "by curiosity" request, but it could help the dev
pinpoint an issue if my first guess is correct.

--
Cley Faye
http://cleyfaye.net

2015-04-23 17:28 GMT+02:00 Tom Davies <[hidden email]>:

> Hi :)
> Yeh, i don't know a good way around that :(  other than the way you already
> use! :))
>
>
> People used to be quite happy with the idea of downloading Adobe Acrobat to
> read Pdfs with.  It used to be that almost any website that shared any kind
> of document tended to only have them as Pdfs and also then 'had to' have a
> button to help people download and install an Adobe Pdf Reader.  We hardly
> see any of that these days but that is quite a recent change.
>
> There were objections from people working in the council, or other
> government offices or in big companies that they couldn't install anything
> and thus couldn't use the format that everyone else seemed to be using so
> much.  Now they seem to use Pdf more than everyone else, and even demand
> that other people use it!
>
> Regards from
> Tom :)
>
>
>
>
>
> On 23 April 2015 at 16:08, Ramon Tavarez <[hidden email]> wrote:
>
> > Hi:
> >
> > Thanks for your attention.
> >
> > The fact with this file is that can't be supported by .XLS format, and my
> > coworkers doesn't work with LibO, and that is the only way I can use to
> > "keep in touch" with them and their jobs. It may be a pain .. ... ... ,
> > but while it work I'll keep using this method to share my jobs with them!
> >
> > In  use LibO for every document  I  create, even I update every version
> of
> > LibO  as the module for my Linux distro: Porteus.
> >
> > On the other hand,I can understand the situation with MSOffice and how
> > they refuse the OpenDocument formats, but I still worry about   the big
> >  file size for those files not supported by the "classical" file type.
> >
> > This can lead erroneously, as you said,  to people to believe that
> > everyone else made bad spreadsheet programs and everyone should stick
> with
> > MS.
> >
> > Thanks.
> >
> > *Ramón E. Tavárez B.*
> >
> > On Thu, Apr 23, 2015 at 10:47 AM, Tom Davies <[hidden email]> wrote:
> >
> >> Hi :)
> >> The XlsX, and other OOXML formats are notoriously unreliable.  Each
> >> different version of MS Office uses slightly different versions.  There
> are
> >> at least 3 different "transitional" versions of the format and they are
> not
> >> always compatible with each other.
> >>
> >> If you take the XlsX that was saved by MS Office 2013 and try opening it
> >> in another version of MS Office, say 2010 or 2007, or even 365 then you
> may
> >> well find it's been opened in "Compatibility Mode" or even that it
> doesn't
> >> work at all in extreme cases.  Chances are that some things will have
> moved
> >> around or vanished, especially if you have anything in a frame (such as
> >> images).
> >>
> >> It makes a bit of sense that a file created with newer software might
> not
> >> fare too well on older versions of the same program but with XlsX and
> the
> >> other OOXML formats it even seems to happen the other way around.  Save
> a
> >> file in MS Office 2007 and you get the same problems trying to open that
> >> file in more recent versions of MS Office.
> >>
> >>
> >> MS keep the specs for their formats secret.  There is an ISO definition
> >> of OOXML but that doesn't seem to work in any version of MS Office.  MSO
> >> 2013 was the first that allowed people to save in "strict" but the
> >> resultant files don't seem to be able to be opened in any version of MS
> >> Office.
> >>
> >> So pretty much all programs struggle with trying to read or write XlsX
> or
> >> other OOXML files in any reliable way.  Which version of MS Office
> should
> >> they aim for?
> >>
> >> Actually we had a few times where the LibreOffice user in an office has
> >> been the only person able to open files from colleagues using different
> >> versions of MS Office and has then become a kinda stepping stone for
> >> sharing files between those colleagues.  Similarly with OpenOffice.
> >>
> >>
> >> Best advice seems to be to use either;
> >> 1.  the older MS Office format, Xls (without the X on the end), for MS
> >> Office Xp/2000 and prior or
> >> 2.  stick with Ods.
> >>
> >> Microsoft, in their 2010 version, refused to use the ODF 1.2 format that
> >> everyone else was using at the time and stuck with a mangled version of
> the
> >> older 1.0 (even ignoring the 1.1) and somehow that led to Ods appearing
> to
> >> open just fine but all the formulas got replaced by fixed values.  Their
> >> apparent failure somehow led to people saying that everyone else made
> bad
> >> spreadsheet programs and everyone should stick with MS.
> >>
> >>
> >> So it is well worth avoiding XlsX and it is probably best to use their
> >> older Xls format instead - at least if you want to open the spreadsheet
> on
> >> any machine other than the one with MS Office 2013 on.
> >>
> >> Regards from
> >> Tom :)
> >>
> >>
> >>
> >>
> >> On 23 April 2015 at 15:03, RamonTavarez <[hidden email]> wrote:
> >>
> >>> Hi:
> >>>
> >>> I've experienced the following issue:
> >>>
> >>> The file attached is an .ODS file (1,976 KB).  When seved as  .XLSX
> file
> >>> it
> >>> expands to more than 15 MB.
> >>>
> >>> If the new .XLSX files is oppened with MSOffice 2013 it will ask for
> >>> recovery of information within the file,  after that if we save the
> >>> recovered file to the same file type (.XLSX) the file shrinks to
> 2,393KB.
> >>>
> >>> Why?
> >>>
> >>>
> >>>
> OBRA_CIVIL_TERMINACION_ESTACION_Y_MODULO_ENTRADA_EST_21_LINEA_2B_abril_2015.ods
> >>> <
> >>>
> http://nabble.documentfoundation.org/file/n4147038/OBRA_CIVIL_TERMINACION_ESTACION_Y_MODULO_ENTRADA_EST_21_LINEA_2B_abril_2015.ods
> >>> >
> >>>
> >>>
> >>>
> >>> --
> >>> View this message in context:
> >>>
> http://nabble.documentfoundation.org/Calc-LibO-4-4-Bug-on-ODS-to-XLSX-file-conversion-tp4147038.html
> >>> Sent from the Users mailing list archive at Nabble.com.
> >>>
> >>> --
> >>> To unsubscribe e-mail to: [hidden email]
> >>> Problems?
> >>> http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
> >>> Posting guidelines + more:
> http://wiki.documentfoundation.org/Netiquette
> >>> List archive: http://listarchives.libreoffice.org/global/users/
> >>> All messages sent to this list will be publicly archived and cannot be
> >>> deleted
> >>>
> >>>
> >>
> >
>
> --
> To unsubscribe e-mail to: [hidden email]
> Problems?
> http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
> Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
> List archive: http://listarchives.libreoffice.org/global/users/
> All messages sent to this list will be publicly archived and cannot be
> deleted
>

--
To unsubscribe e-mail to: [hidden email]
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted
RamonTavarez RamonTavarez
Reply | Threaded
Open this post in threaded view
|

Re: [Calc, LibO 4.4] Bug on .ODS to .XLSX file conversion?

Check the post,  I've uploaded the requested file.

Thanks for your interest.

Regards

Ramón E. Tavárez B.

On Thu, Apr 23, 2015 at 1:31 PM, Cley Faye [via Document Foundation Mail Archive] <[hidden email]> wrote:
Discussion about open formats aside, I've looked at the file and it looks
like when saving as xlsx each sheet grow huge (some goes to ~20MB before
compression).

Could you also post the xlsx file obtained when saving with MSO, for
comparison? My guess is that either LO saves *a lot* of empty/dummy cells,
or that it saves in an older xlsx format that is less compact.

btw this is only a "by curiosity" request, but it could help the dev
pinpoint an issue if my first guess is correct.

--
Cley Faye
http://cleyfaye.net

2015-04-23 17:28 GMT+02:00 Tom Davies <[hidden email]>:

> Hi :)
> Yeh, i don't know a good way around that :(  other than the way you already
> use! :))
>
>
> People used to be quite happy with the idea of downloading Adobe Acrobat to
> read Pdfs with.  It used to be that almost any website that shared any kind
> of document tended to only have them as Pdfs and also then 'had to' have a
> button to help people download and install an Adobe Pdf Reader.  We hardly
> see any of that these days but that is quite a recent change.
>
> There were objections from people working in the council, or other
> government offices or in big companies that they couldn't install anything
> and thus couldn't use the format that everyone else seemed to be using so
> much.  Now they seem to use Pdf more than everyone else, and even demand
> that other people use it!
>
> Regards from
> Tom :)
>
>
>
>
>
> On 23 April 2015 at 16:08, Ramon Tavarez <[hidden email]> wrote:

>
> > Hi:
> >
> > Thanks for your attention.
> >
> > The fact with this file is that can't be supported by .XLS format, and my
> > coworkers doesn't work with LibO, and that is the only way I can use to
> > "keep in touch" with them and their jobs. It may be a pain .. ... ... ,
> > but while it work I'll keep using this method to share my jobs with them!
> >
> > In  use LibO for every document  I  create, even I update every version
> of
> > LibO  as the module for my Linux distro: Porteus.
> >
> > On the other hand,I can understand the situation with MSOffice and how
> > they refuse the OpenDocument formats, but I still worry about   the big
> >  file size for those files not supported by the "classical" file type.
> >
> > This can lead erroneously, as you said,  to people to believe that
> > everyone else made bad spreadsheet programs and everyone should stick
> with
> > MS.
> >
> > Thanks.
> >
> > *Ramón E. Tavárez B.*
> >

> > On Thu, Apr 23, 2015 at 10:47 AM, Tom Davies <[hidden email]> wrote:
> >
> >> Hi :)
> >> The XlsX, and other OOXML formats are notoriously unreliable.  Each
> >> different version of MS Office uses slightly different versions.  There
> are
> >> at least 3 different "transitional" versions of the format and they are
> not
> >> always compatible with each other.
> >>
> >> If you take the XlsX that was saved by MS Office 2013 and try opening it
> >> in another version of MS Office, say 2010 or 2007, or even 365 then you
> may
> >> well find it's been opened in "Compatibility Mode" or even that it
> doesn't
> >> work at all in extreme cases.  Chances are that some things will have
> moved
> >> around or vanished, especially if you have anything in a frame (such as
> >> images).
> >>
> >> It makes a bit of sense that a file created with newer software might
> not
> >> fare too well on older versions of the same program but with XlsX and
> the
> >> other OOXML formats it even seems to happen the other way around.  Save
> a
> >> file in MS Office 2007 and you get the same problems trying to open that
> >> file in more recent versions of MS Office.
> >>
> >>
> >> MS keep the specs for their formats secret.  There is an ISO definition
> >> of OOXML but that doesn't seem to work in any version of MS Office.  MSO
> >> 2013 was the first that allowed people to save in "strict" but the
> >> resultant files don't seem to be able to be opened in any version of MS
> >> Office.
> >>
> >> So pretty much all programs struggle with trying to read or write XlsX
> or
> >> other OOXML files in any reliable way.  Which version of MS Office
> should
> >> they aim for?
> >>
> >> Actually we had a few times where the LibreOffice user in an office has
> >> been the only person able to open files from colleagues using different
> >> versions of MS Office and has then become a kinda stepping stone for
> >> sharing files between those colleagues.  Similarly with OpenOffice.
> >>
> >>
> >> Best advice seems to be to use either;
> >> 1.  the older MS Office format, Xls (without the X on the end), for MS
> >> Office Xp/2000 and prior or
> >> 2.  stick with Ods.
> >>
> >> Microsoft, in their 2010 version, refused to use the ODF 1.2 format that
> >> everyone else was using at the time and stuck with a mangled version of
> the
> >> older 1.0 (even ignoring the 1.1) and somehow that led to Ods appearing
> to
> >> open just fine but all the formulas got replaced by fixed values.  Their
> >> apparent failure somehow led to people saying that everyone else made
> bad
> >> spreadsheet programs and everyone should stick with MS.
> >>
> >>
> >> So it is well worth avoiding XlsX and it is probably best to use their
> >> older Xls format instead - at least if you want to open the spreadsheet
> on
> >> any machine other than the one with MS Office 2013 on.
> >>
> >> Regards from
> >> Tom :)
> >>
> >>
> >>
> >>
> >> On 23 April 2015 at 15:03, RamonTavarez <[hidden email]> wrote:

> >>
> >>> Hi:
> >>>
> >>> I've experienced the following issue:
> >>>
> >>> The file attached is an .ODS file (1,976 KB).  When seved as  .XLSX
> file
> >>> it
> >>> expands to more than 15 MB.
> >>>
> >>> If the new .XLSX files is oppened with MSOffice 2013 it will ask for
> >>> recovery of information within the file,  after that if we save the
> >>> recovered file to the same file type (.XLSX) the file shrinks to
> 2,393KB.
> >>>
> >>> Why?
> >>>
> >>>
> >>>
> OBRA_CIVIL_TERMINACION_ESTACION_Y_MODULO_ENTRADA_EST_21_LINEA_2B_abril_2015.ods
> >>> <
> >>>
> http://nabble.documentfoundation.org/file/n4147038/OBRA_CIVIL_TERMINACION_ESTACION_Y_MODULO_ENTRADA_EST_21_LINEA_2B_abril_2015.ods
> >>> >
> >>>
> >>>
> >>>
> >>> --
> >>> View this message in context:
> >>>
> http://nabble.documentfoundation.org/Calc-LibO-4-4-Bug-on-ODS-to-XLSX-file-conversion-tp4147038.html
> >>> Sent from the Users mailing list archive at Nabble.com.
> >>>
> >>> --
> >>> To unsubscribe e-mail to: [hidden email]
> >>> Problems?

> >>> http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
> >>> Posting guidelines + more:
> http://wiki.documentfoundation.org/Netiquette
> >>> List archive: http://listarchives.libreoffice.org/global/users/
> >>> All messages sent to this list will be publicly archived and cannot be
> >>> deleted
> >>>
> >>>
> >>
> >
>
> --
> To unsubscribe e-mail to: [hidden email]
> Problems?
> http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
> Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
> List archive: http://listarchives.libreoffice.org/global/users/
> All messages sent to this list will be publicly archived and cannot be
> deleted
>

--
To unsubscribe e-mail to: [hidden email]
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted



If you reply to this email, your message will be added to the discussion below:
http://nabble.documentfoundation.org/Calc-LibO-4-4-Bug-on-ODS-to-XLSX-file-conversion-tp4147038p4147063.html
To unsubscribe from [Calc, LibO 4.4] Bug on .ODS to .XLSX file conversion?, click here.
NAML

Cley Faye Cley Faye
Reply | Threaded
Open this post in threaded view
|

Re: [Calc, LibO 4.4] Bug on .ODS to .XLSX file conversion?

That's interesting. Examining the beginning of one of the "big" sheets in
both case, we see that LibreOffice is *very* verbose with what it save. If
I understand it correctly, LO save informations about *every* cells,
including empty ones. Which is very odd, since it does not do it with
*every* sheets.

This does not explain why MSO have to "repair" the files though. Maybe the
devs would be interested in this test case.

--
Cley Faye
http://cleyfaye.net

2015-04-23 20:12 GMT+02:00 RamonTavarez <[hidden email]>:

> Check the post,  I've uploaded the requested file.
>
> Thanks for your interest.
>
> Regards
>
> *Ramón E. Tavárez B.*
>
> On Thu, Apr 23, 2015 at 1:31 PM, Cley Faye [via Document Foundation Mail
> Archive] <[hidden email]> wrote:
>
> > Discussion about open formats aside, I've looked at the file and it looks
> > like when saving as xlsx each sheet grow huge (some goes to ~20MB before
> > compression).
> >
> > Could you also post the xlsx file obtained when saving with MSO, for
> > comparison? My guess is that either LO saves *a lot* of empty/dummy
> cells,
> > or that it saves in an older xlsx format that is less compact.
> >
> > btw this is only a "by curiosity" request, but it could help the dev
> > pinpoint an issue if my first guess is correct.
> >
> > --
> > Cley Faye
> > http://cleyfaye.net
> >
> > 2015-04-23 17:28 GMT+02:00 Tom Davies <[hidden email]
> > <http:///user/SendEmail.jtp?type=node&node=4147063&i=0>>:
> >
> > > Hi :)
> > > Yeh, i don't know a good way around that :(  other than the way you
> > already
> > > use! :))
> > >
> > >
> > > People used to be quite happy with the idea of downloading Adobe
> Acrobat
> > to
> > > read Pdfs with.  It used to be that almost any website that shared any
> > kind
> > > of document tended to only have them as Pdfs and also then 'had to'
> have
> > a
> > > button to help people download and install an Adobe Pdf Reader.  We
> > hardly
> > > see any of that these days but that is quite a recent change.
> > >
> > > There were objections from people working in the council, or other
> > > government offices or in big companies that they couldn't install
> > anything
> > > and thus couldn't use the format that everyone else seemed to be using
> > so
> > > much.  Now they seem to use Pdf more than everyone else, and even
> demand
> > > that other people use it!
> > >
> > > Regards from
> > > Tom :)
> > >
> > >
> > >
> > >
> > >
> > > On 23 April 2015 at 16:08, Ramon Tavarez <[hidden email]
> > <http:///user/SendEmail.jtp?type=node&node=4147063&i=1>> wrote:
> > >
> > > > Hi:
> > > >
> > > > Thanks for your attention.
> > > >
> > > > The fact with this file is that can't be supported by .XLS format,
> and
> > my
> > > > coworkers doesn't work with LibO, and that is the only way I can use
> > to
> > > > "keep in touch" with them and their jobs. It may be a pain .. ... ...
> > ,
> > > > but while it work I'll keep using this method to share my jobs with
> > them!
> > > >
> > > > In  use LibO for every document  I  create, even I update every
> > version
> > > of
> > > > LibO  as the module for my Linux distro: Porteus.
> > > >
> > > > On the other hand,I can understand the situation with MSOffice and
> how
> > > > they refuse the OpenDocument formats, but I still worry about   the
> > big
> > > >  file size for those files not supported by the "classical" file
> type.
> > > >
> > > > This can lead erroneously, as you said,  to people to believe that
> > > > everyone else made bad spreadsheet programs and everyone should stick
> > > with
> > > > MS.
> > > >
> > > > Thanks.
> > > >
> > > > *Ramón E. Tavárez B.*
> > > >
> > > > On Thu, Apr 23, 2015 at 10:47 AM, Tom Davies <[hidden email]
> > <http:///user/SendEmail.jtp?type=node&node=4147063&i=2>> wrote:
> > > >
> > > >> Hi :)
> > > >> The XlsX, and other OOXML formats are notoriously unreliable.  Each
> > > >> different version of MS Office uses slightly different versions.
> > There
> > > are
> > > >> at least 3 different "transitional" versions of the format and they
> > are
> > > not
> > > >> always compatible with each other.
> > > >>
> > > >> If you take the XlsX that was saved by MS Office 2013 and try
> opening
> > it
> > > >> in another version of MS Office, say 2010 or 2007, or even 365 then
> > you
> > > may
> > > >> well find it's been opened in "Compatibility Mode" or even that it
> > > doesn't
> > > >> work at all in extreme cases.  Chances are that some things will
> have
> > > moved
> > > >> around or vanished, especially if you have anything in a frame (such
> > as
> > > >> images).
> > > >>
> > > >> It makes a bit of sense that a file created with newer software
> might
> > > not
> > > >> fare too well on older versions of the same program but with XlsX
> and
> > > the
> > > >> other OOXML formats it even seems to happen the other way around.
> > Save
> > > a
> > > >> file in MS Office 2007 and you get the same problems trying to open
> > that
> > > >> file in more recent versions of MS Office.
> > > >>
> > > >>
> > > >> MS keep the specs for their formats secret.  There is an ISO
> > definition
> > > >> of OOXML but that doesn't seem to work in any version of MS Office.
> > MSO
> > > >> 2013 was the first that allowed people to save in "strict" but the
> > > >> resultant files don't seem to be able to be opened in any version of
> > MS
> > > >> Office.
> > > >>
> > > >> So pretty much all programs struggle with trying to read or write
> > XlsX
> > > or
> > > >> other OOXML files in any reliable way.  Which version of MS Office
> > > should
> > > >> they aim for?
> > > >>
> > > >> Actually we had a few times where the LibreOffice user in an office
> > has
> > > >> been the only person able to open files from colleagues using
> > different
> > > >> versions of MS Office and has then become a kinda stepping stone for
> > > >> sharing files between those colleagues.  Similarly with OpenOffice.
> > > >>
> > > >>
> > > >> Best advice seems to be to use either;
> > > >> 1.  the older MS Office format, Xls (without the X on the end), for
> > MS
> > > >> Office Xp/2000 and prior or
> > > >> 2.  stick with Ods.
> > > >>
> > > >> Microsoft, in their 2010 version, refused to use the ODF 1.2 format
> > that
> > > >> everyone else was using at the time and stuck with a mangled version
> > of
> > > the
> > > >> older 1.0 (even ignoring the 1.1) and somehow that led to Ods
> > appearing
> > > to
> > > >> open just fine but all the formulas got replaced by fixed values.
> > Their
> > > >> apparent failure somehow led to people saying that everyone else
> made
> > > bad
> > > >> spreadsheet programs and everyone should stick with MS.
> > > >>
> > > >>
> > > >> So it is well worth avoiding XlsX and it is probably best to use
> > their
> > > >> older Xls format instead - at least if you want to open the
> > spreadsheet
> > > on
> > > >> any machine other than the one with MS Office 2013 on.
> > > >>
> > > >> Regards from
> > > >> Tom :)
> > > >>
> > > >>
> > > >>
> > > >>
> > > >> On 23 April 2015 at 15:03, RamonTavarez <[hidden email]
> > <http:///user/SendEmail.jtp?type=node&node=4147063&i=3>> wrote:
> > > >>
> > > >>> Hi:
> > > >>>
> > > >>> I've experienced the following issue:
> > > >>>
> > > >>> The file attached is an .ODS file (1,976 KB).  When seved as  .XLSX
> > > file
> > > >>> it
> > > >>> expands to more than 15 MB.
> > > >>>
> > > >>> If the new .XLSX files is oppened with MSOffice 2013 it will ask
> for
> > > >>> recovery of information within the file,  after that if we save the
> > > >>> recovered file to the same file type (.XLSX) the file shrinks to
> > > 2,393KB.
> > > >>>
> > > >>> Why?
> > > >>>
> > > >>>
> > > >>>
> > >
> >
> OBRA_CIVIL_TERMINACION_ESTACION_Y_MODULO_ENTRADA_EST_21_LINEA_2B_abril_2015.ods
> >
> > > >>> <
> > > >>>
> > >
> >
> http://nabble.documentfoundation.org/file/n4147038/OBRA_CIVIL_TERMINACION_ESTACION_Y_MODULO_ENTRADA_EST_21_LINEA_2B_abril_2015.ods
> > > >>> >
> > > >>>
> > > >>>
> > > >>>
> > > >>> --
> > > >>> View this message in context:
> > > >>>
> > >
> >
> http://nabble.documentfoundation.org/Calc-LibO-4-4-Bug-on-ODS-to-XLSX-file-conversion-tp4147038.html
> > > >>> Sent from the Users mailing list archive at Nabble.com.
> > > >>>
> > > >>> --
> > > >>> To unsubscribe e-mail to: [hidden email]
> > <http:///user/SendEmail.jtp?type=node&node=4147063&i=4>
> > > >>> Problems?
> > > >>>
> > http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
> > > >>> Posting guidelines + more:
> > > http://wiki.documentfoundation.org/Netiquette
> > > >>> List archive: http://listarchives.libreoffice.org/global/users/
> > > >>> All messages sent to this list will be publicly archived and cannot
> > be
> > > >>> deleted
> > > >>>
> > > >>>
> > > >>
> > > >
> > >
> > > --
> > > To unsubscribe e-mail to: [hidden email]
> > <http:///user/SendEmail.jtp?type=node&node=4147063&i=5>
> > > Problems?
> > > http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
> > > Posting guidelines + more:
> http://wiki.documentfoundation.org/Netiquette
> > > List archive: http://listarchives.libreoffice.org/global/users/
> > > All messages sent to this list will be publicly archived and cannot be
> > > deleted
> > >
> >
> > --
> > To unsubscribe e-mail to: [hidden email]
> > <http:///user/SendEmail.jtp?type=node&node=4147063&i=6>
> > Problems?
> > http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
> > Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
> > List archive: http://listarchives.libreoffice.org/global/users/
> > All messages sent to this list will be publicly archived and cannot be
> > deleted
> >
> >
> > ------------------------------
> >  If you reply to this email, your message will be added to the discussion
> > below:
> >
> >
> http://nabble.documentfoundation.org/Calc-LibO-4-4-Bug-on-ODS-to-XLSX-file-conversion-tp4147038p4147063.html
> >  To unsubscribe from [Calc, LibO 4.4] Bug on .ODS to .XLSX file
> > conversion?, click here
> > <
> >
> > .
> > NAML
> > <
>
http://nabble.documentfoundation.org/template/NamlServlet.jtp?macro=macro_viewer&id=instant_html%21nabble%3Aemail.naml&base=nabble.naml.namespaces.BasicNamespace-nabble.view.web.template.NabbleNamespace-nabble.view.web.template.NodeNamespace&breadcrumbs=notify_subscribers%21nabble%3Aemail.naml-instant_emails%21nabble%3Aemail.naml-send_instant_email%21nabble%3Aemail.naml
> >
> >
>
>
>
>
> --
> View this message in context:
> http://nabble.documentfoundation.org/Calc-LibO-4-4-Bug-on-ODS-to-XLSX-file-conversion-tp4147038p4147064.html
> Sent from the Users mailing list archive at Nabble.com.
> --
> To unsubscribe e-mail to: [hidden email]
> Problems?
> http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
> Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
> List archive: http://listarchives.libreoffice.org/global/users/
> All messages sent to this list will be publicly archived and cannot be
> deleted
>

--
To unsubscribe e-mail to: [hidden email]
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted
TomD TomD
Reply | Threaded
Open this post in threaded view
|

Re: [Calc, LibO 4.4] Bug on .ODS to .XLSX file conversion?

Hi :)
Good work there.  Thanks for taking it to the next level Cley!  Nicely done
:)

Posting a bug-report might be a good idea?  Ramon can you do that?
Regards from
Tom :)



On 23 April 2015 at 21:45, Cley Faye <[hidden email]> wrote:

> That's interesting. Examining the beginning of one of the "big" sheets in
> both case, we see that LibreOffice is *very* verbose with what it save. If
> I understand it correctly, LO save informations about *every* cells,
> including empty ones. Which is very odd, since it does not do it with
> *every* sheets.
>
> This does not explain why MSO have to "repair" the files though. Maybe the
> devs would be interested in this test case.
>
> --
> Cley Faye
> http://cleyfaye.net
>
>
<snip />


> > > > >>
> > > > >>
> > > > >> On 23 April 2015 at 15:03, RamonTavarez <[hidden email]
> > > <http:///user/SendEmail.jtp?type=node&node=4147063&i=3>> wrote:
> > > > >>
> > > > >>> Hi:
> > > > >>>
> > > > >>> I've experienced the following issue:
> > > > >>>
> > > > >>> The file attached is an .ODS file (1,976 KB).  When seved as
> .XLSX
> > > > >>> file it
> > > > >>> expands to more than 15 MB.
> > > > >>>
> > > > >>> If the new .XLSX files is oppened with MSOffice 2013 it will ask
> for
> > > > >>> recovery of information within the file,  after that if we save
> the
> > > > >>> recovered file to the same file type (.XLSX) the file shrinks to
> > > > >>>2,393KB.
> > > > >>> Why?
> > > > >>>
> > > > >>>
> > > > >>>
> > > >
> > >
> >
> OBRA_CIVIL_TERMINACION_ESTACION_Y_MODULO_ENTRADA_EST_21_LINEA_2B_abril_2015.ods
> > >
> > > > >>> <
> > > > >>>
> > > >
> > >
> >
> http://nabble.documentfoundation.org/file/n4147038/OBRA_CIVIL_TERMINACION_ESTACION_Y_MODULO_ENTRADA_EST_21_LINEA_2B_abril_2015.ods
> > > > >>> >
> > > > >>>
> > > > >>>
> > > > >>>
> > > > >>> --
> > > > >>> View this message in context:
> > > > >>>
> > > >
> > >
> >
> http://nabble.documentfoundation.org/Calc-LibO-4-4-Bug-on-ODS-to-XLSX-file-conversion-tp4147038.html
>
>
<snip />


>
> > >
> >
> http://nabble.documentfoundation.org/Calc-LibO-4-4-Bug-on-ODS-to-XLSX-file-conversion-tp4147038p4147063.html
> > >
>

<snip />

--
To unsubscribe e-mail to: [hidden email]
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted
pietervo pietervo
Reply | Threaded
Open this post in threaded view
|

Re: [Calc, LibO 4.4] Bug on .ODS to .XLSX file conversion?

In reply to this post by Cley Faye
Cley Faye wrote:

 > That's interesting. Examining the beginning of one of the "big" sheets in
 > both case, we see that LibreOffice is *very* verbose with what it save. If
 > I understand it correctly, LO save informations about *every* cells,
 > including empty ones. Which is very odd, since it does not do it with
 > *every* sheets.
 
Yes, I also looked at it, I inspected sheet 7 (and it brought my computer to a grinding halt).
It contains all the cells until column IW, which is 231 columns!
As this sheet has 10423 rows, that is a lot of data.

So the question is: why did it not optimize away the empty cells?
--
Piet van Oostrum <[hidden email]>
WWW: http://pietvanoostrum.com/
PGP key: [8DAE142BE17999C4]

--
To unsubscribe e-mail to: [hidden email]
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

m.a.riosv m.a.riosv
Reply | Threaded
Open this post in threaded view
|

Re: [Calc, LibO 4.4] Bug on .ODS to .XLSX file conversion?

I think Piet have pointed to the source of the problem.

Seems in several sheet there are cells formatted out data range. Sheet 'Análisis Pisos' seems empty but has a lot of empty comments, better delete the sheet.

For a first cleaning, to do in every sheet:

- Ctrl+End goes to bottom-right corner of range with data in a sheet.
- Use Ctrl-M to clear any direct format for the columns right and rows down of it.

Miguel Ángel.


RamonTavarez RamonTavarez
Reply | Threaded
Open this post in threaded view
|

Re: [Calc, LibO 4.4] Bug on .ODS to .XLSX file conversion?

In reply to this post by TomD
Hi Tom:

I've wanted to  report it as a bug, but first I decided to ask the community, in case I 'm the  the origin of the "failure ".

Now I want to ask you how exactly can I report it to be treated as a bug by the dev. community ?

Thanks.

(long live LibO!)
Paul D. Mirowsky Paul D. Mirowsky
Reply | Threaded
Open this post in threaded view
|

Re: [Calc, LibO 4.4] Bug on .ODS to .XLSX file conversion?

In reply to this post by m.a.riosv
Should "Delete empty rows/columns" be a new command on a sheet basis.
Sheet basis meaning you see the results of command before saving and can
"undo".
I'm not sure it would be good a default unless the command would check
formulas to make sure empty cells are not referenced.


On 4/23/2015 7:57 PM, m.a.riosv wrote:

> I think Piet have pointed to the source of the problem.
>
> Seems in several sheet there are cells formatted out data range. Sheet
> 'Análisis Pisos' seems empty but has a lot of empty comments, better delete
> the sheet.
>
> For a first cleaning, to do in every sheet:
>
> - Ctrl+End goes to bottom-right corner of range with data in a sheet.
> - Use Ctrl-M to clear any direct format for the columns right and rows down
> of it.
>
> Miguel Ángel.
>
>
>
>
>
>
> --
> View this message in context: http://nabble.documentfoundation.org/Calc-LibO-4-4-Bug-on-ODS-to-XLSX-file-conversion-tp4147038p4147086.html
> Sent from the Users mailing list archive at Nabble.com.
>


--
To unsubscribe e-mail to: [hidden email]
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted
pietervo pietervo
Reply | Threaded
Open this post in threaded view
|

Re: [Calc, LibO 4.4] Bug on .ODS to .XLSX file conversion?

In reply to this post by m.a.riosv
m.a.riosv wrote:

 > I think Piet have pointed to the source of the problem.
 >
 > Seems in several sheet there are cells formatted out data range. Sheet
 > 'Análisis Pisos' seems empty but has a lot of empty comments, better delete
 > the sheet.
 >
 > For a first cleaning, to do in every sheet:
 >
 > - Ctrl+End goes to bottom-right corner of range with data in a sheet.
 > - Use Ctrl-M to clear any direct format for the columns right and rows down
 > of it.
 >
 > Miguel Ángel.

I did some more experimenting with Sheet 7 (ANALISIS PISOS IMPORTADOS).

First I selected all columns from M to the end and deleted all cells (everything) in it. That helped.

But then I saw that several rows (3723, 3897, 3972-3984, 4040-4046, 4090. 8375, 8378, 10415-10417, 10238) still had all their cells listed individually. It appears that these complete rows have the font set to "Times New Roman 10pt", whereas the default font is Arial. So I also dir a Ctrl-M on these columns and that dramatically decreased the size of Sheet 7.

The file saved by MS Excel has special commands to set the format/style of a row, so that it does not have to specify each individual cell. So that is an optimisation that the exporter misses for some reason. I also tried this with a small file and there it did optimize it.

I guess if you do this for all the sheets the file may become much smaller.
That still leaves improvement possibilities in the exporter.
--
Piet van Oostrum <[hidden email]>
WWW: http://pietvanoostrum.com/
PGP key: [8DAE142BE17999C4]

--
To unsubscribe e-mail to: [hidden email]
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

James E. Lang James E. Lang
Reply | Threaded
Open this post in threaded view
|

Re: [Calc, LibO 4.4] Bug on .ODS to .XLSX file conversion?

In reply to this post by Cley Faye
One possibility comes to mind as to why "empty" cells are saved. If formatting has been applied to the empty cells then they must be saved even if no values are currently stored in those cells. As a trivial example consider the four cell range A1:B2 which contain no values but the four cells are formatted to display numbers as currency. How could that formatting be saved without saving those "empty" cells?

--
Jim

-----Original Message-----
From: Cley Faye <[hidden email]>
To: RamonTavarez <[hidden email]>
Cc: "[hidden email]" <[hidden email]>
Sent: Thu, 23 Apr 2015 13:47
Subject: Re: [libreoffice-users] Re: [Calc, LibO 4.4] Bug on .ODS to .XLSX file conversion?

That's interesting. Examining the beginning of one of the "big" sheets in
both case, we see that LibreOffice is *very* verbose with what it save. If
I understand it correctly, LO save informations about *every* cells,
including empty ones. Which is very odd, since it does not do it with
*every* sheets.

This does not explain why MSO have to "repair" the files though. Maybe the
devs would be interested in this test case.

--
Cley Faye
http://cleyfaye.net

2015-04-23 20:12 GMT+02:00 RamonTavarez <[hidden email]>:

> Check the post,  I've uploaded the requested file.
>
> Thanks for your interest.
>
> Regards
>
> *Ramón E. Tavárez B.*
>
> On Thu, Apr 23, 2015 at 1:31 PM, Cley Faye [via Document Foundation Mail
> Archive] <[hidden email]> wrote:
>
> > Discussion about open formats aside, I've looked at the file and it looks
> > like when saving as xlsx each sheet grow huge (some goes to ~20MB before
> > compression).
> >
> > Could you also post the xlsx file obtained when saving with MSO, for
> > comparison? My guess is that either LO saves *a lot* of empty/dummy
> cells,
> > or that it saves in an older xlsx format that is less compact.
> >
> > btw this is only a "by curiosity" request, but it could help the dev
> > pinpoint an issue if my first guess is correct.
> >
> > --
> > Cley Faye
> > http://cleyfaye.net
> >
> > 2015-04-23 17:28 GMT+02:00 Tom Davies <[hidden email]
> > <http:///user/SendEmail.jtp?type=node&node=4147063&i=0>>:
> >
> > > Hi :)
> > > Yeh, i don't know a good way around that :(  other than the way you
> > already
> > > use! :))
> > >
> > >
> > > People used to be quite happy with the idea of downloading Adobe
> Acrobat
> > to
> > > read Pdfs with.  It used to be that almost any website that shared any
> > kind
> > > of document tended to only have them as Pdfs and also then 'had to'
> have
> > a
> > > button to help people download and install an Adobe Pdf Reader.  We
> > hardly
> > > see any of that these days but that is quite a recent change.
> > >
> > > There were objections from people working in the council, or other
> > > government offices or in big companies that they couldn't install
> > anything
> > > and thus couldn't use the format that everyone else seemed to be using
> > so
> > > much.  Now they seem to use Pdf more than everyone else, and even
> demand
> > > that other people use it!
> > >
> > > Regards from
> > > Tom :)
> > >
> > >
> > >
> > >
> > >
> > > On 23 April 2015 at 16:08, Ramon Tavarez <[hidden email]
> > <http:///user/SendEmail.jtp?type=node&node=4147063&i=1>> wrote:
> > >
> > > > Hi:
> > > >
> > > > Thanks for your attention.
> > > >
> > > > The fact with this file is that can't be supported by .XLS format,
> and
> > my
> > > > coworkers doesn't work with LibO, and that is the only way I can use
> > to
> > > > "keep in touch" with them and their jobs. It may be a pain .. ... ...
> > ,
> > > > but while it work I'll keep using this method to share my jobs with
> > them!
> > > >
> > > > In  use LibO for every document  I  create, even I update every
> > version
> > > of
> > > > LibO  as the module for my Linux distro: Porteus.
> > > >
> > > > On the other hand,I can understand the situation with MSOffice and
> how
> > > > they refuse the OpenDocument formats, but I still worry about   the
> > big
> > > >  file size for those files not supported by the "classical" file
> type.
> > > >
> > > > This can lead erroneously, as you said,  to people to believe that
> > > > everyone else made bad spreadsheet programs and everyone should stick
> > > with
> > > > MS.
> > > >
> > > > Thanks.
> > > >
> > > > *Ramón E. Tavárez B.*
> > > >
> > > > On Thu, Apr 23, 2015 at 10:47 AM, Tom Davies <[hidden email]
> > <http:///user/SendEmail.jtp?type=node&node=4147063&i=2>> wrote:
> > > >
> > > >> Hi :)
> > > >> The XlsX, and other OOXML formats are notoriously unreliable.  Each
> > > >> different version of MS Office uses slightly different versions.
> > There
> > > are
> > > >> at least 3 different "transitional" versions of the format and they
> > are
> > > not
> > > >> always compatible with each other.
> > > >>
> > > >> If you take the XlsX that was saved by MS Office 2013 and try
> opening
> > it
> > > >> in another version of MS Office, say 2010 or 2007, or even 365 then
> > you
> > > may
> > > >> well find it's been opened in "Compatibility Mode" or even that it
> > > doesn't
> > > >> work at all in extreme cases.  Chances are that some things will
> have
> > > moved
> > > >> around or vanished, especially if you have anything in a frame (such
> > as
> > > >> images).
> > > >>
> > > >> It makes a bit of sense that a file created with newer software
> might
> > > not
> > > >> fare too well on older versions of the same program but with XlsX
> and
> > > the
> > > >> other OOXML formats it even seems to happen the other way around.
> > Save
> > > a
> > > >> file in MS Office 2007 and you get the same problems trying to open
> > that
> > > >> file in more recent versions of MS Office.
> > > >>
> > > >>
> > > >> MS keep the specs for their formats secret.  There is an ISO
> > definition
> > > >> of OOXML but that doesn't seem to work in any version of MS Office.
> > MSO
> > > >> 2013 was the first that allowed people to save in "strict" but the
> > > >> resultant files don't seem to be able to be opened in any version of
> > MS
> > > >> Office.
> > > >>
> > > >> So pretty much all programs struggle with trying to read or write
> > XlsX
> > > or
> > > >> other OOXML files in any reliable way.  Which version of MS Office
> > > should
> > > >> they aim for?
> > > >>
> > > >> Actually we had a few times where the LibreOffice user in an office
> > has
> > > >> been the only person able to open files from colleagues using
> > different
> > > >> versions of MS Office and has then become a kinda stepping stone for
> > > >> sharing files between those colleagues.  Similarly with OpenOffice.
> > > >>
> > > >>
> > > >> Best advice seems to be to use either;
> > > >> 1.  the older MS Office format, Xls (without the X on the end), for
> > MS
> > > >> Office Xp/2000 and prior or
> > > >> 2.  stick with Ods.
> > > >>
> > > >> Microsoft, in their 2010 version, refused to use the ODF 1.2 format
> > that
> > > >> everyone else was using at the time and stuck with a mangled version
> > of
> > > the
> > > >> older 1.0 (even ignoring the 1.1) and somehow that led to Ods
> > appearing
> > > to
> > > >> open just fine but all the formulas got replaced by fixed values.
> > Their
> > > >> apparent failure somehow led to people saying that everyone else
> made
> > > bad
> > > >> spreadsheet programs and everyone should stick with MS.
> > > >>
> > > >>
> > > >> So it is well worth avoiding XlsX and it is probably best to use
> > their
> > > >> older Xls format instead - at least if you want to open the
> > spreadsheet
> > > on
> > > >> any machine other than the one with MS Office 2013 on.
> > > >>
> > > >> Regards from
> > > >> Tom :)
> > > >>
> > > >>
> > > >>
> > > >>
> > > >> On 23 April 2015 at 15:03, RamonTavarez <[hidden email]
> > <http:///user/SendEmail.jtp?type=node&node=4147063&i=3>> wrote:
> > > >>
> > > >>> Hi:
> > > >>>
> > > >>> I've experienced the following issue:
> > > >>>
> > > >>> The file attached is an .ODS file (1,976 KB).  When seved as  .XLSX
> > > file
> > > >>> it
> > > >>> expands to more than 15 MB.
> > > >>>
> > > >>> If the new .XLSX files is oppened with MSOffice 2013 it will ask
> for
> > > >>> recovery of information within the file,  after that if we save the
> > > >>> recovered file to the same file type (.XLSX) the file shrinks to
> > > 2,393KB.
> > > >>>
> > > >>> Why?
> > > >>>
> > > >>>
> > > >>>
> > >
> >
> OBRA_CIVIL_TERMINACION_ESTACION_Y_MODULO_ENTRADA_EST_21_LINEA_2B_abril_2015.ods
> >
> > > >>> <
> > > >>>
> > >
> >
> http://nabble.documentfoundation.org/file/n4147038/OBRA_CIVIL_TERMINACION_ESTACION_Y_MODULO_ENTRADA_EST_21_LINEA_2B_abril_2015.ods
> > > >>> >
> > > >>>
> > > >>>
> > > >>>
> > > >>> --
> > > >>> View this message in context:
> > > >>>
> > >
> >
> http://nabble.documentfoundation.org/Calc-LibO-4-4-Bug-on-ODS-to-XLSX-file-conversion-tp4147038.html
> > > >>> Sent from the Users mailing list archive at Nabble.com.
> > > >>>
> > > >>> --
> > > >>> To unsubscribe e-mail to: [hidden email]
> > <http:///user/SendEmail.jtp?type=node&node=4147063&i=4>
> > > >>> Problems?
> > > >>>
> > http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
> > > >>> Posting guidelines + more:
> > > http://wiki.documentfoundation.org/Netiquette
> > > >>> List archive: http://listarchives.libreoffice.org/global/users/
> > > >>> All messages sent to this list will be publicly archived and cannot
> > be
> > > >>> deleted
> > > >>>
> > > >>>
> > > >>
> > > >
> > >
> > > --
> > > To unsubscribe e-mail to: [hidden email]
> > <http:///user/SendEmail.jtp?type=node&node=4147063&i=5>
> > > Problems?
> > > http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
> > > Posting guidelines + more:
> http://wiki.documentfoundation.org/Netiquette
> > > List archive: http://listarchives.libreoffice.org/global/users/
> > > All messages sent to this list will be publicly archived and cannot be
> > > deleted
> > >
> >
> > --
> > To unsubscribe e-mail to: [hidden email]
> > <http:///user/SendEmail.jtp?type=node&node=4147063&i=6>
> > Problems?
> > http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
> > Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
> > List archive: http://listarchives.libreoffice.org/global/users/
> > All messages sent to this list will be publicly archived and cannot be
> > deleted
> >
> >
> > ------------------------------
> >  If you reply to this email, your message will be added to the discussion
> > below:
> >
> >
> http://nabble.documentfoundation.org/Calc-LibO-4-4-Bug-on-ODS-to-XLSX-file-conversion-tp4147038p4147063.html
> >  To unsubscribe from [Calc, LibO 4.4] Bug on .ODS to .XLSX file
> > conversion?, click here
> > <
> >
> > .
> > NAML
> > <
>
http://nabble.documentfoundation.org/template/NamlServlet.jtp?macro=macro_viewer&id=instant_html%21nabble%3Aemail.naml&base=nabble.naml.namespaces.BasicNamespace-nabble.view.web.template.NabbleNamespace-nabble.view.web.template.NodeNamespace&breadcrumbs=notify_subscribers%21nabble%3Aemail.naml-instant_emails%21nabble%3Aemail.naml-send_instant_email%21nabble%3Aemail.naml
> >
> >
>
>
>
>
> --
> View this message in context:
> http://nabble.documentfoundation.org/Calc-LibO-4-4-Bug-on-ODS-to-XLSX-file-conversion-tp4147038p4147064.html
> Sent from the Users mailing list archive at Nabble.com.
> --
> To unsubscribe e-mail to: [hidden email]
> Problems?
> http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
> Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
> List archive: http://listarchives.libreoffice.org/global/users/
> All messages sent to this list will be publicly archived and cannot be
> deleted
>

--
To unsubscribe e-mail to: [hidden email]
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

--
To unsubscribe e-mail to: [hidden email]
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted