Bug report

[Elaine Rocholl <el...@gmail.com>]

Subject:  Merge function under format greyed out
Windows 7 Home Premium with Service Pack 1
64 bit
OpenOffice Version 4.1.1

1. Open a CALC document in OpenOffice
2. Select a single row of cells
3. Select Format
4. Note Merge is greyed out

I used to beta test tax software.  If further information is required,
please let me know.

Elaine Rocholl

RE: Bug report

[Brian Barker <b....@btinternet.com>]

At 10:31 17/10/2015 -0700, Dennis E. Hamilton wrote:
>If only a single cell is selected, the Merge Cells item on the 
>Format menu item will be greyed out. There are probably other 
>variations, including read-only sheets, protected fields, etc.

Actually, even those latter cases do not cause greying out of the 
menu item: instead, using it invokes an error message.

Brian Barker 


---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@openoffice.apache.org
For additional commands, e-mail: users-help@openoffice.apache.org

RE: Bug report

["Dennis E. Hamilton" <de...@acm.org>]

I just performed this exercise using OpenOffice 4.1.1 on Windows 10 Pro x64.

Here is how I did it.

 1. Opened OpenOffice 4.1.1
 2. On the Dashboard page, selected Spreadsheet
 3. On the new Calc spreadsheet, selected row 14 by clicking on the row number (not on any cell), selecting the entire row (with A14 shown as the start of the selection).
 4. Clicked menu Format | Merged Cells (not greyed)

Row 14 now shows as a single sheet-wide cell

If only a single cell is selected, the Merge Cells item on the Format menu item will be greyed out.  There are probably other variations, including read-only sheets, protected fields, etc.

Is there a difference in detail in your scenario, Elaine? 

Can you replicate this?  If so, there may be something else involved with the sheet that exhibits the problem you see.

Thanks for reporting this and checking it out.

 - Dennis


> -----Original Message-----
> From: Elaine Rocholl [mailto:elainerocholl@gmail.com]
> Sent: Saturday, October 17, 2015 09:43
> To: users@openoffice.apache.org
> Subject: Bug report
> 
> Subject:  Merge function under format greyed out
> Windows 7 Home Premium with Service Pack 1
> 64 bit
> OpenOffice Version 4.1.1
> 
> 1. Open a CALC document in OpenOffice
> 2. Select a single row of cells
> 3. Select Format
> 4. Note Merge is greyed out
> 
> I used to beta test tax software.  If further information is required,
> please let me know.
> 
> Elaine Rocholl


---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@openoffice.apache.org
For additional commands, e-mail: users-help@openoffice.apache.org

Re: Bug report

[Dave <da...@gmail.com>]

-------- Original Message --------
From: Elaine Rocholl
Date: Sat, 17 Oct 2015 11:43:14 -0500

> Subject:  Merge function under format greyed out
> Windows 7 Home Premium with Service Pack 1
> 64 bit
> OpenOffice Version 4.1.1
>
> 1. Open a CALC document in OpenOffice
> 2. Select a single row of cells
> 3. Select Format
> 4. Note Merge is greyed out
>
> I used to beta test tax software.  If further information is required,
> please let me know.
>
> Elaine Rocholl

Hi Elaine,

Tested your steps on a Windows 7 Ultimate SP1 64bit machine, with AOO
4.1.1 and cannot reproduce your issue. (See capture below)

As Denis has already pointed out, you must select either a range of
cells, or click on a row number to make the "Merge" option accessible.

If this does not resolve your issue, resetting your "user profile" might
be a solution:
https://forum.openoffice.org/en/forum/viewtopic.php?f=74&t=12426
However, this is more a measure of last resort to use when other options
have not succeeded.

Hope this helps.

Dave