Properties
Category
English
Similar Topics
Statistics
Comments
16
Participants
3
Subscribers
28
Votes
2
Views
1186
Share

How to smartest save random made strings in different cells in a column in the spreadsheet ?
Answered
I've got GeoGebra to create a random sting every time I click on a button and I want GeoGebra to save every string in different cells in a column in the spreadsheet.
For example I would like the first generated string saved in the cell B2, the next in B3 and so on.
How can I do that smartest when the number of the generated string is n and the string is always made in the same variable (for example f) ?
- GeoGebra
- Help
- Partners
-
Contact us
- Feedback & Questions
- This email address is being protected from spambots. You need JavaScript enabled to view it.
- +43 677 6137 2693
© 2022 International GeoGebra Institute
Execute({"B"+(n+1)+"="+f+""})
Execute use a list with string-elements. {"","", ....""} and execute each string similar as he is written in the input-box.
Each string-element can be composed with constants and variables.
Example (when n is ==2): "B"+(n+1)+"=" --> "B3="
in the string is inserted the value of f (and not the name).
If this value (f) is a string then the character " must be insert also (at begin and end of the string).
this charcter must be insert as UnicodeToLetter(34)
Example: {"B"+(n+1)+"="+(UnicodeToLetter(34)+f+UnicodeToLetter(34))+""}
--> B3="abcde" (when n == 2 and f is a string and has the value "abcde")
Execute({"B"+(n+1)+"="+f+""})
Execute use a list with string-elements. {"","", ....""} and execute each string similar as he is written in the input-box.
Each string-element can be composed with constants and variables.
Example (when n is ==2): "B"+(n+1)+"=" --> "B3="
in the string is inserted the value of f (and not the name).
If this value (f) is a string then the character " must be insert also (at begin and end of the string).
this charcter must be insert as UnicodeToLetter(34)
Example: {"B"+(n+1)+"="+(UnicodeToLetter(34)+f+UnicodeToLetter(34))+""}
--> B3="abcde" (when n == 2 and f is a string and has the value "abcde")
If f is a function, and I would like to have it written in the spreadsheet as f(x) = ...
How can I do that ?
The content of the cells also seems locked/writing-protected so that the content can't be overwritten.
How can I change that ?
When the string is added to the spreadsheet, the string is viewed in the drawing window.
How can I use a script to make the string invisible in the drawing window once it is added to the spreadsheet ?
see script in button
Which script can I use afterwards to clear all the used cells in a column except the first cell (for example B1) ?
see script in button2
Comments have been locked on this page!