Bug 123340

Summary: EDITING The text vertical alignment in comment isn’t modifiable in the Format→Align menu
Product: LibreOffice Reporter: NISZ LibreOffice Team <libreoffice>
Component: CalcAssignee: Not Assigned <libreoffice-bugs>
Status: RESOLVED NOTABUG    
Severity: minor CC: kelemeng, nemeth, rb.henschel
Priority: medium    
Version: Inherited From OOo   
Hardware: All   
OS: All   
Whiteboard:
Crash report or crash signature: Regression By:
Bug Depends on:    
Bug Blocks: 101216    
Attachments: Screenshot of the problem in Calc.

Description NISZ LibreOffice Team 2019-02-11 11:26:02 UTC
Description:
The text vertical alignment in comment isn’t modifiable in the Format→Align menu. (But it is modifiable in the Text Formatting toolbar.)

Steps to Reproduce:
    1. Create a new spreadsheet in LibreOffice Calc.
    2. Select a cell and choose Insert→Comment.
    3. Choose Format→Align.

Actual Results:
Top, Center, Bottom options are gray.

Expected Results:
The text vertical alignment in comment should be modifiable in the Format→Align menu.


Reproducible: Always


User Profile Reset: No



Additional Info:
LibreOffice details:
Version: 6.3.0.0.alpha0+
Build ID: fcc5fc76c33de566cb2d02be541dcbde29d1eb8a
CPU threads: 4; OS: Windows 10.0; UI render: GL; VCL: win; 
Locale: hu-HU (hu_HU); UI-Language: en-US
Calc: threaded

Reproducible with:
LibreOffice 3.5.0rc3 
Build ID: 7e68ba2-a744ebf-1f241b7-c506db1-7d53735
Comment 1 NISZ LibreOffice Team 2019-02-11 11:26:53 UTC
Created attachment 149114 [details]
Screenshot of the problem in Calc.
Comment 2 Durgapriyanka 2019-02-12 15:58:06 UTC
Thank you for reporting the bug. I confirm the bug present in

Version: 6.3.0.0.alpha0+
Build ID: b6b28931435e44aca92b8c0e1659f701e3ed1a87
CPU threads: 2; OS: Windows 6.1; UI render: default; VCL: win; 
TinderBox: Win-x86@42, Branch:master, Time: 2019-01-30_06:57:04
Locale: en-US (en_US); UI-Language: en-US
Calc: threaded
Comment 3 Timur 2019-02-12 17:02:41 UTC
inherited. minor.
Comment 4 Regina Henschel 2019-10-02 20:13:37 UTC
The shown item does not belong to comments at all, but to cell content. A comment in Calc is a graphical object. You get the anchor (which appears as vertical alignment) of the text block of a comment via menu Format > Object > Text.

This is "worksforme".
Comment 5 NISZ LibreOffice Team 2019-10-03 07:57:22 UTC
(In reply to Regina Henschel from comment #4)
> The shown item does not belong to comments at all, but to cell content. A
> comment in Calc is a graphical object. You get the anchor (which appears as
> vertical alignment) of the text block of a comment via menu Format > Object
> > Text.

If you create a comment and add some text to it, you can format that with the Format -> Alignment -> (first 4 items). Those apply to the text of the comment and are also present on the Formatting toolbar.

This confused us a bit, and assumed that these are the same as the buttons of the Formatting toolbar. Icons and their placement are rather similar after all.

Looking closer at the source, the Format - Alignment menu contains the CommonAlignTop CommonAlignVerticalCenter and CommonAlignBottom commands while the Formatting toolbar has AlignTop AlignVCenter and AlignBottom commands, and these change the vertical alignment of the comment text as expected.

> 
> This is "worksforme".

Let's say NAB, and thanks for checking!