On 10/2/20 7:55 AM, Tom Williams wrote: > On 10/2/20 7:32 AM, sandralo...@vivaldi.net wrote: >> Le 2020-10-01 01:13, Tom Williams a écrit : >>> Hi! A friend of mine sent me an Excel 365 spreadsheet to get my help to >>> add a formula. The spreadsheet is "simple", in that it had about 90 >>> rows of data, with only one column being a numeric value. Everything >>> else was plain text. I added the formula (to sum the numbers in the one >>> numeric column) and when I saved the file, in XLSX format, I noticed the >>> file size was smaller. >>> >>> Here is what I found: >>> >>> Original file: 22kb >>> >>> Calc 6.4.6 on Ubuntu 20.04: 16kb >>> >>> Calc 5.1.6 (I think) on Mint 18.3: 9kb >>> >>> Why would saving the file in Calc reduce the file size? >>> >>> Thanks in advance! >>> >>> Peace... >>> >>> "The Other" Tom >>> >>> -- >>> /When I leave, I don't know what I'm hoping to find, >>> And when I leave, I don't know what I'm leaving behind.../ >> Hello Tom >> >> A pleasure to have a librarian lol, well already the previous versions >> of LibreOffice converted to Ms Office format are necessarily more >> dancing in size as you have noticed, I will advise you to publish the >> latest version of LibreOffice 7.0.1.2 >> >> then to come back to your question I don't have a screenshot but I >> send you mine which also shows a document at the base ods of 33.6 kiB >> converted to xlsx format of 26.9 kiB but when you look at the content >> level the xlsx version is in excel zip so compressed at the base where >> the xlsx size will be smaller than the ods version in size because it >> is compressed at the source. >> >> I hope to have answered your concern if not please specify your >> question to me with screenshots so that I understand well why it is >> not a question. >> >> cordially >> Sandra LOUVEZO > Thanks for the reply! I'll try LibreOffice 7 and see what happens. I > think I have it installed in a virtual Windows 10 environment I > sometimes use. > > Thanks! > > Peace... > > "The Other" Tom > So, I tried this in LibreOffice 7.0.1 on Windows 10 and found the spreadsheet saved to a file size of 17kb. This isn't a "problem" or anything and I was mostly curious about the difference in file size. :)
Peace... "The Other" Tom -- /When I leave, I don't know what I'm hoping to find, And when I leave, I don't know what I'm leaving behind.../ -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy