06-18-2017, 04:12 PM
06-18-2017, 07:20 PM
Simply enter for example "=Row^2", that is the way to enter formulas for a whole column.
Arno
Arno
06-19-2017, 12:09 AM
Not really what I want. I have an existing sheet and I need to add a column between two existing ones. Eg, I have net and "purchase price" and I want to put "additional" and "down payment" between them.
06-19-2017, 09:13 AM
Hello,
Unfortunately, there is no easy way to do so...
The easiest might be a copy/paste operation
Cyrille
Unfortunately, there is no easy way to do so...
The easiest might be a copy/paste operation
Cyrille
06-22-2017, 10:25 PM
(06-19-2017 09:13 AM)cyrille de brébisson Wrote: [ -> ]Hello,
Unfortunately, there is no easy way to do so...
The easiest might be a copy/paste operation
Cyrille
copy and paste did not seem to work with the formulas. I ended up just recreating the whole darn thing.
06-26-2017, 06:14 AM
hello,
Sorry, yes, formulas don't get updated.
Cyrille
Sorry, yes, formulas don't get updated.
Cyrille
06-26-2017, 10:45 PM
You can use the programs below to insert and delete columns:
Example: If you want to insert a column at B just go to the home or cas view and type InsertCol(2). Similar for DeleteCol.
I'm working on a similar method to insert and delete rows.
Eventually, as time permits, I plan to use the Curser variable to locate where to insert or delete, and hijack the plot key to display a pop up menu asking how many rows or columns.
-road
PHP Code:
EXPORT InsertCol(c)
BEGIN
local rs,cs;
rs:=SIZE(A:A);
cs:=SIZE(1:1);
FOR I FROM c TO cs DO
FOR J FROM 1 TO rs DO
Cell(J,cs-I+c+1,−1):=Cell(J,cs-I+c,−1);
END;
END;
FOR J FROM 1 TO rs DO
Cell(J,c,−1):=Cell(J,cs+1,−1);
END;
"all done";
END;
EXPORT DeleteCol(c)
BEGIN
local rs,cs;
rs:=SIZE(A:A);
cs:=SIZE(1:1);
FOR I FROM c TO cs DO
FOR J FROM 1 TO rs DO
Cell(J,I,−1):=Cell(J,I+1,−1);
END;
END;
"all done";
END;
Example: If you want to insert a column at B just go to the home or cas view and type InsertCol(2). Similar for DeleteCol.
I'm working on a similar method to insert and delete rows.
Eventually, as time permits, I plan to use the Curser variable to locate where to insert or delete, and hijack the plot key to display a pop up menu asking how many rows or columns.
-road