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 <[email protected]>: > 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] <[email protected]> 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 > > < > http://nabble.documentfoundation.org/template/NamlServlet.jtp?macro=unsubscribe_by_code&node=4147038&code=cmFtb250YXZhcmV6QGdtYWlsLmNvbXw0MTQ3MDM4fDE2MzExMjYwMDk= > > > > . > > 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: [email protected] > 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: [email protected] 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
