Re: [libreoffice-users] Question about saving Excel 365 (.xlsx) files in LibreOffice Calc 6.4.6

On 10/2/20 7:32 AM, sandralouve@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

-- 
/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+unsubscribe@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