Issue 128351 - AOO Calc, Format Cells, Font tab vs Font Effects tab - difference in preview
Summary: AOO Calc, Format Cells, Font tab vs Font Effects tab - difference in preview
Alias: None
Product: Calc
Classification: Application
Component: ui (show other issues)
Version: 4.1.7
Hardware: PC Windows 7
: P5 (lowest) Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Depends on:
Reported: 2020-03-30 15:57 UTC by Czesław Wolański
Modified: 2020-05-04 17:06 UTC (History)
1 user (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---

Calc document for test (8.08 KB, application/vnd.oasis.opendocument.spreadsheet)
2020-03-30 15:57 UTC, Czesław Wolański
no flags Details
Screenshots illustrating this issue (475.13 KB, image/jpeg)
2020-03-30 15:59 UTC, Czesław Wolański
no flags Details
Excerpts from Calc guide (911.60 KB, image/jpeg)
2020-03-30 16:00 UTC, Czesław Wolański
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description Czesław Wolański 2020-03-30 15:57:33 UTC
Created attachment 86916 [details]
Calc document for test

I have attached Calc file "testFile" for test.
Two cells - B5 & C5 - formatted as Text - contain sample string: "Format Cells".

In attached file "DialogTabs" you may see due screenshots.

1. Open test file in AOO Calc
2. Select cell e.g. 'B5'
3. Open Format Cells dialog
   (Format > Cells  OR  "Format Cells" from context menu)
4. Go to Font tab.
   Notice font size used in preview at the bottom of dialog.
5. Go to Font Effects tab.
   You will notice that font size used in preview at the bottom
   of dialog is bigger.
6. Edit cell 'B5'
7. Select its content
8. Open Character dialog
   Format > Character OR "Character" from context menu
9. If you visit Font tab and Font Effects tab you will notice
   that the size of the font used in preview is the same.

For the time being I see no rationale for this difference. Therefore
I consider it a teeny-weeny bug. P6 importance would seem adequate, though user's annoyance calls for P5.

And some final remarks based upon further research and "playing":
- if in Format Cells dialog, Font tab, you change the font size,
  then both preview (Font tab and Font Effects tab) are the same.
- if you start with tiny font size e.g. 6 poins, the issue
  does not occur.
- issue occurs if one starts AOO Calc (new document) or opens
  new document in Calc.
- in document "Entering, Editing, and Formating Data in Calc",
  dated 2005, I found two relevant figures (see, please, attached file
  "CalcGuide"). They demonstrate different font size in preview.
- to be on the safe side I checked AOO Writer: Character dialog
  and Paragraph Style dialog. The issue doesn't occur.
Comment 1 Czesław Wolański 2020-03-30 15:59:00 UTC
Created attachment 86917 [details]
Screenshots illustrating this issue
Comment 2 Czesław Wolański 2020-03-30 16:00:08 UTC
Created attachment 86918 [details]
Excerpts from Calc guide
Comment 3 Keith N. McKenna 2020-05-04 17:06:58 UTC
I can partially confirm this with the following configuration:

Windows 10 Version 1909 OS Build 18363.778
AOO Version 4.1.7 AOO417m1(Build:9800)  -  Rev. 46059c9192
2019-09-03 12:04
I can confirm that the Font Effects preview is indeed a larger font size than the 10 point defined in the test file. How ever to my eyes The Font tab preview appears to be the same 10 point as the file.