Scenario: Estimating a line formula Y = mX + c
Steps:
1. Create a spreadsheet.
2. In cells A1, B1, type in some numerical values, e.g.: 2.53 and 32.785 We will use them for constants m, c.
Note: can be any other value.
3. In column A, type in some (5) numerical values, starting row A2 to A6
4. In cell B2, type the formula "=$A$1*A2+$B$1" without the quotes. Then press Enter.
You should get the value of the equation.
5. Next try to replicate the formula in cell B2, by dragging the small square icon at the bottom-right corner of the cell (like you would do in Excel spreadsheet). Drag till B6.
6. Formula should be replicated and numerical values should show.
Error 1:
You get error message in the cell: Error: Parse error ... ----^Expecting '('
Error 2:
The cells to be replicated by dragging the formula have incorrect formula of type "=ANaN*B3+ANaN"
Edit > Undo does not work. The error values in the cells cannot be removed by click on Edit > Undo
This is a major drawback of the Spreadsheet feature. Reduces considerably, the usability of this important feature.
To help developers solve the bug, we kindly request that you demonstrate your bug on a show2.tiki.org instance. To start, simply select a version and click on "Create show2.tiki.org instance". Once the instance is ready (in a minute or two), as indicated in the status window below, you can then access that instance, login (the initial admin username/password is "admin") and configure the Tiki to demonstrate your bug. Priority will be given to bugs that have been demonstrated on show2.tiki.org.
To help developers solve the bug, we kindly request that you demonstrate your bug on a show.tikiwiki.org instance. To start, simply select a version and click on "Create show.tikiwiki.org instance". Once the instance is ready (in a minute or two), as indicated in the status window below, you can then access that instance, login (the initial admin username/password is "admin") and configure the Tiki to demonstrate your bug. Priority will be given to bugs that have been demonstrated on show.tikiwiki.org.
filename | created | hits | comment | version | filetype | ||
---|---|---|---|---|---|---|---|
No attachments for this item |