Bug 131828 - Font size feedback is wrong
Summary: Font size feedback is wrong
Status: RESOLVED NOTABUG
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
Inherited From OOo
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2020-04-02 14:39 UTC by info
Modified: 2022-04-25 16:25 UTC (History)
4 users (show)

See Also:
Crash report or crash signature:


Attachments
problem example (13.53 KB, application/vnd.oasis.opendocument.spreadsheet)
2020-04-02 14:40 UTC, info
Details

Note You need to log in before you can comment on or make changes to this bug.
Description info 2020-04-02 14:39:51 UTC
Description:
The font size is incorrectly shown as identical, when one is clearly larger than the other. 

Steps to Reproduce:
1. Check font size of cell A22
2. Check font size of cell A21
3. They are both shown as 8pt - clearly something is wrong

Actual Results:
Font size shown as 8 in cell A22

Expected Results:
Font size is actuall 10pt in A22, IIRC


Reproducible: Always


User Profile Reset: No



Additional Info:
[Information automatically included from LibreOffice]
Locale: en-GB
Module: SpreadsheetDocument
[Information guessed from browser]
OS: Windows (All)
OS is 64bit: no

Version: 6.4.2.2 (x64)
Build ID: 4e471d8c02c9c90f512f7f9ead8875b57fcb1ec3
CPU threads: 4; OS: Windows 10.0 Build 18363; UI render: default; VCL: win; 
Locale: nb-NO (en_GB); UI-Language: en-GB
Calc: threaded
Comment 1 info 2020-04-02 14:40:33 UTC
Created attachment 159271 [details]
problem example
Comment 2 Durgapriyanka 2020-04-03 20:51:27 UTC
Thank you for reporting the bug. I can confirm the bug present in

Version: 6.4.0.0.alpha1+ (x86)
Build ID: ec7374ff84c71edfbb30d6e4dc5b486b6df7107f
CPU threads: 2; OS: Windows 6.1 Service Pack 1 Build 7601; UI render: default; VCL: win; 
TinderBox: Win-x86@42, Branch:master, Time: 2019-11-10_21:37:30
Locale: en-US (en_US); UI-Language: en-US
Calc: threaded
	

and in

LibreOffice 3.3.0 
OOO330m19 (Build:6)
tag libreoffice-3.3.0.4
Comment 3 Julien Nabet 2022-04-23 18:40:00 UTC
In fact both cells are indeed Tahoma 8 pt.
But when entering cell A22, each character is Verdana 10 pt.

Extraction the ods file to retrieve content.xml, I see this:
          <table:table-cell table:style-name="ce29" office:value-type="string" calcext:value-type="string">
            <text:p>
              <text:span text:style-name="T1">5</text:span>
              <text:span text:style-name="T2">1</text:span>
            </text:p>
          </table:table-cell>

Here is the definition of ce29:
    <style:style style:name="ce29" style:family="table-cell" style:parent-style-name="Std">
      <style:table-cell-properties style:text-align-source="fix" style:repeat-content="false" />
      <style:paragraph-properties fo:text-align="center" fo:margin-left="0cm" />
      <style:text-properties style:use-window-font-color="true" style:text-outline="false" style:text-line-through-style="none" style:text-line-through-type="none" style:font-name="Tahoma" fo:font-size="8pt" fo:language="none" fo:country="none"
      fo:font-style="normal" fo:text-shadow="none" style:text-underline-style="none" fo:font-weight="normal" style:text-underline-mode="continuous" style:text-overline-mode="continuous" style:text-line-through-mode="continuous"
      style:font-name-asian="Segoe UI" style:font-size-asian="8pt" style:language-asian="none" style:country-asian="none" style:font-style-asian="normal" style:font-weight-asian="normal" style:font-name-complex="Verdana" style:font-size-complex="8pt"
      style:language-complex="none" style:country-complex="none" style:font-style-complex="normal" style:font-weight-complex="normal" style:text-emphasize="none" style:font-relief="none" style:text-overline-style="none"
      style:text-overline-color="font-color" />
    </style:style>

=> Tahoma 8pt

Here are the definitions of T1 and T2:
    <style:style style:name="T1" style:family="text">
      <style:text-properties style:font-name="Verdana" fo:font-size="10pt" style:font-name-complex="Verdana" />
    </style:style>
    <style:style style:name="T2" style:family="text">
      <style:text-properties style:font-name="Verdana" fo:font-size="10pt" style:font-name-complex="Verdana" style:font-size-asian="10pt" style:font-size-complex="10pt" />
    </style:style>

=> Verdana 10 pt

Heiko/Xisco: what should be expected here? font name and font size retrieved from the whole cell and in this case it's correct or should it be blank when the content doesn't correspond? (a bit like when typing a word in Writer, if you change fontname/fontsize just one letter then select the whole word, info are blank).
Comment 4 Heiko Tietze 2022-04-25 09:02:49 UTC
<18>Hello</18> World  => 10 //cell content partly direct formatted as 18pt
Hello <18>World</18>  => 10
<18>Hello World</18>  => 18 //all cell content direct formatted as 18pt
 <18>Hello World</18> => 10 //white space w/o formatting before
<18>Hello World</18>  => 10 //white space w/o formatting after

The cell content here is <text:span text:style-name="T1">5</text:span><text:span text:style-name="T2">1</text:span> (with T1 <> T2). Sounds like NAB to me.

PS: Ctrl+M clears direct formatting, and View > Value Highlighting helps to identify data mistakenly formatted as text.
Comment 5 Julien Nabet 2022-04-25 16:25:07 UTC
Thank you Heiko for the feedback, let's put this one to Not A Bug then.