Bug 444566

Summary: Feature regression with gnumeric 1.8.2
Product: [Fedora] Fedora Reporter: Pat Gunn <pgunn>
Component: gnumericAssignee: Huzaifa S. Sidhpurwala <huzaifas>
Status: CLOSED UPSTREAM QA Contact: Fedora Extras Quality Assurance <extras-qa>
Severity: medium Docs Contact:
Priority: low    
Version: 9CC: huzaifas, lex.lists
Target Milestone: ---   
Target Release: ---   
Hardware: All   
OS: Linux   
Whiteboard:
Fixed In Version: Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: 2009-02-26 22:39:22 UTC Type: ---
Regression: --- Mount Type: ---
Documentation: --- CRM:
Verified Versions: Category: ---
oVirt Team: --- RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: --- Target Upstream Version:
Embargoed:
Attachments:
Description Flags
Spreadsheet which works in older versions of gnumeric none

Description Pat Gunn 2008-04-29 07:01:52 UTC 
Description of problem:Previous versions of gnumeric in fedora allowed summaries
over computed values, e.g. SUM(A1:A9/B1:B9) or SUM(IF(B1:B9,A1:A9/B1:B9)). The
version included in FC9 preview does not.


Version-Release number of selected component (if applicable): 1.8.2


How reproducible: 100%


Steps to Reproduce:
1.
2.
3.
  
Actual results:Evaluation fails


Expected results:


Additional info:See attached file
Comment 1 Pat Gunn 2008-04-29 07:01:52 UTC 
Created attachment 304074 [details]
Spreadsheet which works in older versions of gnumeric
Comment 2 Huzaifa S. Sidhpurwala 2008-04-29 10:57:46 UTC 
I can reproduce this.
Looks like this is no longer supported, you need to use SUM(A4:A6)/B4/B9 instead

I am going to probe a little more tomorrow.
Comment 3 Pat Gunn 2008-04-30 10:17:31 UTC 
I would like to request then that Fedora9 consider inclusion 1.6 of gnumeric
then instead of 1.8. Breaking of people's existing spreadsheets is not a good
thing in an upgrade.
Comment 4 Pat Gunn 2008-04-30 12:04:43 UTC 
Working with the developers, we found that forcing array evaluation
(control-shift-enter) on all cells that previously worked using standard
evaluation results in spreadsheets working again. They are considering adding an
internal flag for spreadsheets enabling old-style evaluation though.
Comment 5 Bug Zapper 2008-05-14 10:21:38 UTC 
Changing version to '9' as part of upcoming Fedora 9 GA.
More information and reason for this action is here:
http://fedoraproject.org/wiki/BugZappers/HouseKeeping
Comment 6 lexual 2009-02-26 12:58:29 UTC 
Pat, was is this resolved for you now?
Comment 7 Pat Gunn 2009-02-26 16:42:15 UTC 
It's upstream at http://bugzilla.gnome.org/show_bug.cgi?id=530711
I'll poke them.