I have a gnumeric file with multiple sheets where each row represents
a data point.  Each column has a different formatting, and I want each
new row to inherit the formatting of the previous in a special way. Not
sure how possible this is in gnumeric, but I have one file that needs
all of the cases listed below.  Some of are more macro/programmatic,
and are included for completeness.  Some of them are more reasonable
(that having been said, does gnumeric need more developers?).

1. One column needs the value to be automatically filled with max(everything
   above it in this column)+1.  I.e., it need the next unused integer.
   Currently, I do this manually by sorting the above rows and then using
   the last row's number+1.

2. Two columns have functions in them with relative references, and these
   functions need to be copied into the new rows.  I can just grab them
   from the row above and copy them, but I was hoping there was a way to
   tell gnumeric "always put foo into column C when a new row is added".
   I can always prefill these columns down the page, but this is ugly for
   two reasons: it violates "0, 1, or Infinity" and it causes small changes
   to the spreadsheet to take nonproportional amount of time to recalculate.

3. These rows represent recorded observations, and each row has a column to
   indicate the date of the observation.  I'd like it to prefill with the
   current date (which can then be corrected manually if the data point is
   added much later than the observation).

    Is any of this doable in gnumeric presently, or planned soon.  Especially
if not, please see my parenthetical remark before the enumerated list 8-).

"Friends don't let friends compile on AIX"
Jack McKinney  jackmc lorentz com
1024D/FBED2DAA 4096g/3F93879F
2002 Chicago Cubs magic number: 67

Attachment: pgpXvfdms62Te.pgp
Description: PGP signature

[Date Prev][Date Next]   [Thread Prev][Thread Next]   [Thread Index] [Date Index] [Author Index]