Michelle Konzack wrote:
Hello Michael,
Am 2010-04-04 22:05:05, hacktest Du folgendes herunter:
Just clarifying, you want something like this?
B2 =(C2+D2)*F2
B3 =(C3+D3)*F3
B4 =(C4+D4)*F4
B5 =(C5+D5)*F5
B6 =(C6+D6)*F6
B7 =(C7+D7)*F7
B8 =(C8+D8)*F8
Yes...
If so, it can be achieved by mouse-dragging the formula as shown
under 'Copying Formulae' in help. If this is not what you mean i for one
would need more information.
You realy mean, I should copy arround 80.000 fields by hand? Thats sick!
Yes, it is fairly easy. Just double-click the square cell handle to copy
down until the end of the adjacent region. The usual navigation keys do
work together with copy&paste or with menu:Edit>Fill<any direction>
You mean rows rather than fields (columns) and there are only 64536 rows
and 1024 columns per sheet. OOo comes with a datbase component which
really sucks but not as much as a database in Excel.
I have written a "list keeper macro" for those who are unable to work
with databases (the only way to solve all related problems).
It takes care of the general option "Expand references when new rows are
inserted" turning it on if required and off again when it was not set.
It inserts new "records" from sloppy selection into the current region
of used cells around the current selection leaving alone any sheet areas
that are separated by blank cells.
It handles merged cells.
It copies formula cells down from the adjacent top neighbour row.
It selects the remaining new blank cells for editing.
http://user.services.openoffice.org/en/forum/viewtopic.php?f=21&t=2350
Create directory Scripts/python/ in your user profile and extract the
downloaded source code from the archive into that directory.
Then assign 2 shortcuts to insert and remove list rows. I use Ctrl+Ins
and Ctrl+Del for this.
I know that this is not the answer you want, but the only one I can provide.
Good luck,
Andreas
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
