how 2 conditionally auto-re-generate worksheet content?

rb.forums · Newbie Joined: 16 Jun 2007 Posts: 2

hi,

i'm attempting my first script-driven dynamic generation & manipulation of data.

i'd like to create a script to conditionally populate a 2nd worksheet in a workbook, given a value entered into a cell in a first worksheet.

in principle, the idea is simple ... but i'm simply lost as to where/how to undertake this.

e.g.,

on sheet1, enter #N into a cell.

on change of #N,

in sheet#2 automatically,

(1) clear DATA from ALL rows > #X, in columns "B" & "C"
(2) for row_count of i=1->#N,

populate cell @ (row= #X+i , col="B") with "i"
populate cell @ (row=#X+i, col"B") with a formula/calculation based on the value of "i", i.e., f(i)

then, on sheet1, populate Chart data into a defined area, with X- & Y-data defined by the auto-created Sheet2 data.

i'd appreciate any hand-holding/introduction on how to do this.

thank you!

rob

squenson · Posted: Sat Jun 16, 2007 10:16 pm Post subject:

Rob,

If #N is in cell Sheet1.A1, then you should put in Sheet2:

rb.forums · Newbie Joined: 16 Jun 2007 Posts: 2

Hi,

squenson · Posted: Mon Jun 18, 2007 9:53 am Post subject:

Rob,

The only way to generate cell content ex nihilo (from nothing) is to use a macro. In your case, either you create a button and you click on it each time you change the value of N, or you create an event that monitors the change in that cell, and runs the same code as the button. The code would consist of filling a range of length N with the formulas.

I have posted something about events in the past months and I reused it yesterday for someone else: http://www.oooforum.org/forum/viewtopic.phtml?t=54726&highlight=
_________________
Help us to help you: Add [Solved] to the title of the thread if you agree with the answer
>>> Do you know the new OOo support forum http://user.services.openoffice.org/en/forum/index.php? <<<