#### Please do not CC me, I read the list #### #### from a spam free E-Mail Account. Thanks. ####
Hello Andreas, Am 2010-04-08 09:01:49, hacktest Du folgendes herunter: > 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. As I can see, it has copied all formulas from the previous ROW in the newly inserted ROW... Now I have only to solv the sum(over) art which can only make the SUM of a range of ROWS (eg C5 to C999) which does not work if I insert new ROWS because the C999 is not updated to C1000. Thanks, Greetings and nice Day/Evening Michelle Konzack 24V Electronic Engineer -- Development and Production of Low-Energie Electronics, Computer Hardware and Solar/Wind-Energie Systems electron...@tdnet France electron...@tdnet UG (haftungsbeschränkt) Gesch. Michelle Konzack Gesch. Michelle Konzack Apt. 917 (homeoffice) 50, rue de Soultz Kinzigstraße 17 67100 Strasbourg/France 77694 Kehl/Germany Tel: +33-6-61925193 mobil Tel: +49-177-9351947 mobil Tel: +33-9-52705884 fix <http://www.electronica.tamay-dogan.net/> <http://www.can4linux.org/> <http://www.tamay-dogan.net/> <http://www.flexray4linux.org/>
signature.pgp
Description: Digital signature
