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
