A Few Geogebra Spreadsheet-Related Questions
I'm relatively new to Geogebra. Here are a few questions I have.
1) Let's say I place into cell A1 of a Geogebra spreadsheet the function "random()," which returns a random value between 0 and 1, such as 0.234. I wish to copy this formula to the 99 cells below (that is, cells A2:A100). Whenever I attempt to do this, what results is the random VALUE in cell A1 being copied, not the formula itself. Thus if random() had returned 0.234, I would get the value 0.234 copied to each of the next 99 cells below. How does one copy the formula in cell A1 to the 99 cells below it, not the VALUE in cell A1? (It seems if I copy only one cell at a time to one other cell, I do get the formula copied. But when I copy one cell to 99 cells, I get the value.)
2) I cannot find the Excel "trunc" command to truncate a value to its next lowest integer (e.g., 3.2 should truncate to 3; 3.9 should truncate to 3 also). I've come up with a workaround using the round function:
If(round(F15) ≤ F15, round(F15), round(F15) - 1)
but I was wondering if there was an actual equivalent to "trunc" available.
3) Where can I find a complete list of all worksheet functions specifically available to Geogebra spreadsheets?