Am 17.06.2011 17:38, tora - Takamichi Akiyama wrote:
On 2011/06/17 16:38, Martin Hediger wrote:
Its true, i havent thought of the implications of what it means to
switch rows. Should references pointing to cell A1 remain pointing to
A1, when the content of A1 is "traded" for the content of B1? W
On 2011/06/17 16:38, Martin Hediger wrote:
Its true, i havent thought of the implications of what it means to switch rows. Should
references pointing to cell A1 remain pointing to A1, when the content of A1 is
"traded" for the content of B1? What should the references follow?
But apart from th
Oops, there was a typo bug.
Now fixed:
https://bitbucket.org/tora/calc-move-selected-cells
Best,
Tora
On 2011/06/17 23:40, tora - Takamichi Akiyama wrote:
Hi Oliver,
On 2011/06/17 1:12, Oliver Brinzing wrote:
> Quickly move Rows and columns like in Writer
> http://openoffice.org/bugzilla/sh
Hi Oliver,
On 2011/06/17 1:12, Oliver Brinzing wrote:
> Quickly move Rows and columns like in Writer
> http://openoffice.org/bugzilla/show_bug.cgi?id=40285
>
> have a look at the attached example ;-)
Thanks! That is what I thought.
And now, I also have written a similar one. ;-)
https://bitbuck
Its true, i havent thought of the implications of what it means to
switch rows. Should references pointing to cell A1 remain pointing to
A1, when the content of A1 is "traded" for the content of B1? What
should the references follow?
But apart from that, the way to exchange two rows is I belie
Hi,
maybe this can help:
Quickly move Rows and columns like in Writer
http://openoffice.org/bugzilla/show_bug.cgi?id=40285
have a look at the attached example ;-)
Regards
Oliver
--
GnuPG key 0xCFD04A45: 8822 057F 4956 46D3 352C 1A06 4E2C AB40 CFD0 4A45
signature.asc
Description: OpenPGP
Here is what I wrote a few years ago to move column "C" to the location of "A",
as Niklas suggests. :-)
Sub Main
oSheet = ThisComponent.getCurrentController().getActiveSheet()
Move_Column(oSheet, "C", "A")
End Sub
Sub Move_Column(oSheet, sFrom, sTo)
cFrom = oSheet.getCol
Thanks for the feedback, indeed it makes intuitively sense to check out
that part of the API.
The simplest way of defining the rows to exchange (that I can think of
right now) would be to just to select two rows in the spreadsheet. If
more or less than two rows are selected, this would cause an
On 15.06.2011 23:19, Martin Hediger wrote:
I was thinking, would it be possible to implement some kind of row-row
exchange button in Calc? Of course, the same could apply to
column-column exchange.
It depends on the desired behavior of that button. Probably it can be a
combination of "insert r