Bug 123340 - EDITING The text vertical alignment in comment isn’t modifiable in the Format→Align menu
Summary: EDITING The text vertical alignment in comment isn’t modifiable in the Format...
Status: RESOLVED NOTABUG
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
Inherited From OOo
Hardware: All All
: medium minor
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Calc-Comments
  Show dependency tree / graph
 
Reported: 2019-02-11 11:26 UTC by NISZ LibreOffice Team
Modified: 2019-10-03 07:57 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:

Attachments
Screenshot of the problem in Calc. (107.46 KB, image/png)
2019-02-11 11:26 UTC, NISZ LibreOffice Team 		Details
View All Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
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!