Dynamic Addition of columns in spreadsheet
Answered
Can we create columns dynamically in the spread sheet. I have two values m and n. got through InputBox by the students. The value of x in the quadratic graph lies in between these points (For exmple -4 to 4) Chance are there the students may choose values in between -1 and 7., some times -3 to +3. The range differs according to the input values. I want to calculate ax^2+bx+c in the spreadsheet with dynamic values of m and n. Number of columns created , after every input must be dynamic. Need your help. Thanks in advance
L.Sankaranarayanan
Files:
ClassicDynamicP...
I have a similar question but for the row.
I have an input box n. I want to create n+1 rows on the spreadsheet.
Thank you for your help.
First of all: what part does the spreadsheet play in your considerations?
what you have is a matrix, a matrix can handled and displayed as a whole
Formating display matrix https://wiki.geogebra.org/e...
I made a suggestion. Inputbox remain to add
Depends on what you want exactly. You can use the FillCells command (or FillRow, FillColumn), which allows you to write the contents of a list or a matrix into the spreadsheet. So if you can generate all the content for the spreadsheet beforehand (and whenever the slider changes), you can just put that into a matrix and fill the spreadsheet with it.
What's problematic is adding stuff dynamically later if you don't have absolute positions in spreadsheet format. (As far as I can see there is no way to tell Geogebra to - for example - write something in the cell in row 7, column 5. For some reason you can only read the spreadsheet that way, but not write.) The only way I see around that would be to additionally manage the content of a spreadsheet table within a matrix and refill the whole spreadsheet table from the matrix whenever you need to add/change something. (Which kinda makes using the spreadsheet somewhat superfluous aside from having a table representation of the data.)
Thank you all for your advice. Now I have a simple question.
The spreadsheet has only 100 rows.
I need 400 rows. How should I do that?
Thank you for your answer.
Try
A400=1
It works. Thank you!
Comments have been locked on this page!