Hi Maoyg,
maoyg schrieb:
> Hi, all
> I want to discuss this issue's the specification with your.
> If you think it is important, I hope you can vote it.
> As we know, the calc for the merged cell(selection etc) is different from the
> excel,
> I have some advice for the spec, I hope you can discuss and help me to finish
> it. :)
> I have define a corrent behavior about issue 66028, please review it. thanks.
> http://www.openoffice.org/issues/show_bug.cgi?id=66028
The hidden cells can still contain values and can still be used in
references in OOo. You need to say, what happens with the hidden cells:
How their value is considered for the continuing interval of the shown
value, and how the hidden values are continued.
I suggest the following behavior:
For calculating the continuing interval, not-empty hidden cells are
treated as if they were not hidden, and empty hidden cell are treated as
if they do not exist.
The hidden cell are only considered in drag direction.
The target area gets the same merge pattern than the source range.
Dragfilling overwrites all existing values.
{ } indicates merging
Expample A with varying intervals because of hidden cells
{ 10
hidden 6}
{ 20
hidden 8}
is continued to
{ 11
hidden 7}
{ 21
hidden 9}
Example B with consistent intervals including hidden cells
{ 10
hidden 12}
{ 14
hidden 16}
is continued to
{ 18
hidden 20}
{ 22
hidden 24}
Example C with empty hidden cells
{ 10
empty }
{ 20
empty}
is continued to
{ 30
empty}
{ 40
empty}
Example D with merged cells and single cells mixed
{ 10
empty}
20
is continued to
{ 30
empty}
40
Example E which shows considering in drag direction
{ 10 empty
empty hidden 2}
{ 14 empty
empty hidden 5}
is continued to
{ 18 empty
empty hidden 8}
{ 22 empty
empty hidden 11}
kind regards
Regina
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscr...@sc.openoffice.org
For additional commands, e-mail: dev-h...@sc.openoffice.org
