Sort does not maintain relative row when using a formula referencing another row
I added this same information in a bug report, but am adding it here as well since the latest version of the iOS to select from when reporting the bug was 4.3; yet version 5 has been available for months; and the lastest version of Numbers for iOS to select from was 1.4, while my version is 1.5 (423). Makes me wonder if/how often they look at the bug reports.
------------------------------------
Bug Report
Sort does not maintain relative row when using a formula referencing another row (the row above in this example)
PRESERVE ROW AND COLUMN ARE TURNED OFF FOR ALL FORMULAS
When resorted by changing a value in Column A, the formulas should maintain their relative row values. THEY DO NOT.
The sort and formulas work correctly in Numbers for the Mac, but not in Numbers for iOS.
In the following example:
Row 1 is the header row
Column A is used to sort
Column B contains the numeral 1 in all rows
Column C contain the numeral 1 in Row 1 and a formula in the remaining rows. The formula adds the value in value in column C in the prior row to the value in column B in the current row (i.e. to keep a running total).
Initial spreadsheet
Row B 1
2 1 (=B2+C1 ) value = 2
3 1 (=B3+C2) value = 3
4 1 (=B4+C3) value = 4
5 1 (=B5+C4) value = 5
In this example the value 4 in column A is changed to 2.5 and the table is resorted.
What you SHOULD get after sorting is this (since no rows or columns are preserved).
Row B 1
2 1 (=B2+C1 ) value = 2
2.5 1 (=B3+C2) value = 3
3 1 (=B4+C3) value = 4
5 1 (=B5+C4) value = 5
What you ACTUALLY get after sorting is this:
Row B 1
2 1 (=B2+C1 ) value = 2
2.5 1 (=B3+C4) value = 4 SHOULD BE B3+C2
3 1 (=B4+C2) value = 3 SHOULD BE B4+C3
5 1 (=B5+C3) value = 5 SHOULD BE B5+C4
The version of Numbers I am using, 1.5(423), is not available in the drop down list to select from. The latest in the drop down is 1.4.
The version iOS I am using, 5.0.1(9A405), is also not available in the drop down list. The latest in the drop down is 4.3.
That these releases have been out for four months and are not available in the drop down makes me wonder if/how often these bug reports are looked at.
Message was edited by: rbeckmann I'm leaving this marked as a question in case i have missed something, but I don't think i have since i have confirmed it works as I described it should in both Excel for Windows and in Numbers for the Mac.
iPad 2, iOS 5.0.1