#33662: hiding rows does not close outline folds

#

Thu Feb 28 09:15:17 2008

RBS - Ticket created

Subject:

hiding rows does not close outline folds

[text/plain 497b]

First off, thanks for a really useful module.

The documentation's recommended way of writing an outline with closed
outline section is to hide the rows in that section of the outline.

However, with OpenOffice (at least), this merely hides the rows and the
outline button still shows a "-" as though the rows were open.

Clicking the "-" once turns the button in to a "+" button, just as
though the outline section had been open and is now closed. Clicking
the "+" button shows all of the rows.

#

Wed Mar 05 20:30:34 2008

JMCNAMARA - Correspondence added

[text/plain 213b]

Hi,

I hadn't noticed that. It behave slightly incorrectly in Gnumeric as
well even though it is okay in Excel.

I think I know what causes it but it may not be easy to fix. I'll let
you know.

Thanks,

John.
--

#	Wed Mar 05 20:30:37 2008	RT_System - Status changed from 'new' to 'open'

#

Sun Mar 09 14:07:05 2008

JMCNAMARA - Correspondence added

[text/plain 1.2k]

On Thu Feb 28 09:15:17 2008, RBS wrote:
> First off, thanks for a really useful module.
>
> The documentation's recommended way of writing an outline with closed
> outline section is to hide the rows in that section of the outline.
>
> However, with OpenOffice (at least), this merely hides the rows and the
> outline button still shows a "-" as though the rows were open.

Hi,

I've had a look at this in some more detail.

There is an additional internal flag required in the file format for the
last row/column of a collapsed group. Excel doesn't strictly require it
but OpenOffice and Gnumeric appear to expect it.

Therefore, I've added an addition "collapsed" parameter to the set_row()
and set_column() methods to allow greater fidelity with Excel.

I've added it to the beta of the next Spreadsheet::WriteExcel release
which you can download from here:

http://homepage.eircom.net/~jmcnamara/perl/prerel/Spreadsheet-WriteExcel-2.20.01.tar.gz

See the updated outline.pl program in the examples dir as well as the
new outline_collapsed.pl program and the updated docs for set_row(),
set_column() and "Outlines And Grouping In Excel".

I've tested it with OpenOffice and Gnumeric but let me know if you
encounter any further problems.

John.
--

#

Sun Mar 09 14:08:35 2008

JMCNAMARA - Correspondence added

[text/plain 144b]

Hi,

Sorry wrong link. Here is the latest:

http://homepage.eircom.net/~jmcnamara/perl/prerel/Spreadsheet-WriteExcel-2.20.05.tar.gz

John.
--

#

Mon Mar 10 05:35:08 2008

JMCNAMARA - Correspondence added

300 min

[text/plain 187b]

Fixed in version 2.21.

Use additional $collapse parameter in set_row() and set_column() to
indicate the row/column with the collapsed symbol.

See updated docs and examples.

John.
--

#	Mon Mar 10 05:35:25 2008	JMCNAMARA - Status changed from 'open' to 'resolved'

#	Mon Mar 10 05:36:30 2008	JMCNAMARA - Fixed in 2.21 added

#

Mon Mar 10 10:11:48 2008

barries[...]slaysys.com - Correspondence added

Subject:	Re: [rt.cpan.org #33662] hiding rows does not close outline folds
Date:	Mon, 10 Mar 2008 09:44:02 -0400
To:	bug-Spreadsheet-WriteExcel[...]rt.cpan.org
From:	Barrie Slaymaker <barries[...]slaysys.com>

[text/plain 729b]

Thanks, John, both v.2.20.05 and v2.21 work perfectly. To others reading
along, the subtlety that $collapsed needs to be set on the
summary/containing row, not the hidden rows, is key. It's correctly
documented, I just missed this detail on first read.

Here's the code I'm using for an outline spreadsheet writer where the
summary row is above the collapsed section (as opposed to outline.pl's
"summary row below"):

$worksheet->set_row(
$row_number, $row_height, undef, $hidden, $depth
);

$worksheet->set_row( ## Set parent row to be collapsed.
$row_number - 1, undef, undef, undef, undef, 1
) if $hidden;

- Barrie

#	Mon Mar 10 10:12:13 2008	RT_System - Status changed from 'resolved' to 'open'

#	Sun Mar 16 13:47:06 2008	JMCNAMARA - Status changed from 'open' to 'resolved'