Loading...
 
Skip to main content

Errors in copying formulas with constants in spreadsheets

  • Tracker item actions
Trackers
Items
Status
Pending
Subject
Errors in copying formulas with constants in spreadsheets
Version
12.x
Category
  • Usability
Feature
Spreadsheet
Resolution status
Please retest
Submitted by
nirvanesque
Lastmod by
Xavier de Pedro
Rating
(0)
Description

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.

Workaround
This might be working as expected in recent Tiki versions (15.x & 16.x). Can you please retest? Thanks!
Importance
7
Easy to solve?
4
Priority
28
Demonstrate Bug on Tiki 19+
Demonstrate Bug (older Tiki versions)
Ticket ID
5262
Created
Thursday 12 June, 2014 13:55:53 UTC
by nirvanesque
LastModif
Sunday 29 January, 2017 14:40:15 UTC


Show PHP error messages