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 <tomc...@gmail.com>: > 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 <ramontava...@gmail.com> 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 <tomc...@gmail.com> 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 <ramontava...@gmail.com> 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: users+unsubscr...@global.libreoffice.org > >>> 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: users+unsubscr...@global.libreoffice.org > 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: users+unsubscr...@global.libreoffice.org 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