The 'Default' cell style doesnt have font size set and as a result, opening an LO ods in excel results in a default font size of 11 and opening it in calligra results in a default font size of 9, rather than calc's default of 10. Assume the necessary code pointer is at https://cgit.freedesktop.org/libreoffice/core/tree/sc/source/core/data/stlpool.cxx#n212
Confirming that on save to ODF, Default table-cell style has no fo:font-size set and that on opening into MS Excel an Excel default of 11pt is used rather than the 10pt size used by Calc.
** Please read this message in its entirety before responding ** To make sure we're focusing on the bugs that affect our users today, LibreOffice QA is asking bug reporters and confirmers to retest open, confirmed bugs which have not been touched for over a year. There have been thousands of bug fixes and commits since anyone checked on this bug report. During that time, it's possible that the bug has been fixed, or the details of the problem have changed. We'd really appreciate your help in getting confirmation that the bug is still present. If you have time, please do the following: Test to see if the bug is still present with the latest version of LibreOffice from https://www.libreoffice.org/download/ If the bug is present, please leave a comment that includes the information from Help - About LibreOffice. If the bug is NOT present, please set the bug's Status field to RESOLVED-WORKSFORME and leave a comment that includes the information from Help - About LibreOffice. Please DO NOT Update the version field Reply via email (please reply directly on the bug tracker) Set the bug's Status field to RESOLVED - FIXED (this status has a particular meaning that is not appropriate in this case) If you want to do more to help you can test to see if your issue is a REGRESSION. To do so: 1. Download and install oldest version of LibreOffice (usually 3.3 unless your bug pertains to a feature added after 3.3) from http://downloadarchive.documentfoundation.org/libreoffice/old/ 2. Test your bug 3. Leave a comment with your results. 4a. If the bug was present with 3.3 - set version to 'inherited from OOo'; 4b. If the bug was not present in 3.3 - add 'regression' to keyword Feel free to come ask questions or to say hello in our QA chat: https://kiwiirc.com/nextclient/irc.freenode.net/#libreoffice-qa Thank you for helping us make LibreOffice even better for everyone! Warm Regards, QA Team MassPing-UntouchedBug
still repro in LO 6.1.2.1 on Windows 10
Eike commented on this topic: "I think that setting the Default style's font to a fixed 10pt size is not the proper approach. If the problem is that font size is not written to file then the export should check for it and add it to the document's default style instead. I'm not sure at the moment where this internally used 10pt actually originates and why export omits it, but the Default standard style never defined a hard 10pt font size."
Quoting myself from my bug 139281: (In reply to Buovjaga from comment #0) > I was looking into bug 112559 "FILESAVE: ODS - Default cell style font size > not set". It is indeed possible to solve it by editing > sc/source/core/data/stlpool.cxx so it has > > #include <editeng/fhgtitem.hxx> > > and in ScStyleSheetPool::CreateStandardStyles() > > pSet->Put( SvxFontHeightItem( 200, 100, ATTR_FONT_HEIGHT ) ); // 10pt (Just as an additional note on how *not* to solve this)
Here is my attempt at fixing this: https://gerrit.libreoffice.org/c/core/+/110539 Hope this is the right approach.
Maxim Monastirsky committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/commit/a796aa9d65e3d4292232820d424b3f62c673fa07 tdf#112559 sc: Expose font height via the Defaults UNO API It will be available in 7.2.0. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Let's close as fixed
*** Bug 106125 has been marked as a duplicate of this bug. ***