How do I insert a row
John
I'm a newbie to xwlt. I'm sorry if this question but answered many times in
the past but I can't find the answer.
How can I insert a row into a speadsheet I have open. I found that it was
much easier to fill all the rows and then go back and provide formulas. But
now I need to insert a blank row and can't figure out how to get that done.
Thanks
Johnf
John Machin
> Hi,
Hi John, welcome to the group. There are lots of us Johns, and none
sufficiently notorious to be known by given name only, like Napoleon ...
please consider growing an appendage :-)
> I'm a newbie to xwlt. I'm sorry if this question but answered many times in
> the past but I can't find the answer.
As far as I know, it hasn't been asked.
> How can I insert a row into a speadsheet I have open.
You can't, not without a major rewrite.
> I found that it was
> much easier to fill all the rows and then go back and provide formulas. But
> now I need to insert a blank row and can't figure out how to get that done.
The only way around that is to put the logic that detects the need for a
blank row into your first pass.
Perhaps you might like to publish your code ... maybe we can suggest
ways of riffle-shuffling your two passes into one pass.
Cheers,
John
John
I did exactly as you suggested and applied the blank rows as I created the
data.
I'm John Fabiani. Normally I just use Johnf as my signature - you think
that's OK?
Johnf