Hi Niklas, Niklas Nebel schrieb: > On 05/25/09 05:33, maoyg wrote: >>> 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. >> My idea is all hidden cells are treated as if they do not exist, but I need >> still to ask ux-discuss's and Niklas's advice. > > Non-empty overlapped cells are quite rare, but if they occur, we > shouldn't ignore them. But perhaps we should extend Regina's suggestion > to all empty cells, even if not overlapped (hidden) by merged cells, so > any sequence of 10,empty,20,empty would be continued with 30,empty,40,empty.
That is a great idea and will be a good extension. User would still get the current behavior, if he only marks the sequence '20 empty' and he gets the extended behavior, when he marks a longer sequence. And besides the fact, that merging is copied to source area, dragfill for merged and unmerged cells would behave the same, which is more friendly in using. Such changes in dragfill will need a full spec, which mentioned all this cases. kind regards Regina --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
