Dynamic Addition of columns in spreadsheet

LS Sir shared this question 1 year ago
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

https://www.geogebra.org/m/fr8rxjpc

Comments (8)

photo
1

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.

photo
1

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

photo
1

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.)

photo
1

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.

photo
1

Try

A400=1

photo
1

I can add rows now but it seems the formula didn't work.

I have some input boxes. They work well before I add those rows in.

Now when I enter the number, say 124- the input bow shows a random number.

Could you please help?

Thanks,

photo
1

no, not with the informations provided. what formula?

an advice, forget spreadsheet if you dealing with the app of the beginning post

photo
photo
1

It works. Thank you!

© 2021 International GeoGebra Institute