After an evaluation, GNOME has moved from Bugzilla to GitLab. Learn more about GitLab.
No new issues can be reported in GNOME Bugzilla anymore.
To report an issue in a GNOME project, go to GNOME GitLab.
Do not go to GNOME Gitlab for: Bluefish, Doxygen, GnuCash, GStreamer, java-gnome, LDTP, NetworkManager, Tomboy.
Bug 572127 - exports SERIESSUM function to XLS incorrectly
exports SERIESSUM function to XLS incorrectly
Status: RESOLVED FIXED
Product: Gnumeric
Classification: Applications
Component: import/export MS Excel (tm)
1.9.x
Other All
: Normal normal
: ---
Assigned To: Jody Goldberg
Jody Goldberg
Depends on:
Blocks:
 
 
Reported: 2009-02-17 11:25 UTC by sjmachin
Modified: 2012-09-29 20:41 UTC
See Also:
GNOME target: ---
GNOME version: ---


Description sjmachin 2009-02-17 11:25:10 UTC 
Please describe the problem:
Start Gnumeric, enter any formula involving the SERIESSUM function.
Save file as MS Excel 97/.../XP.
Open file with Excel 2003; result is that Excel pops up a dialogue box saying that data may have been lost. Then any cell that contained SERIESSUM is showing #N/A.

Steps to reproduce:
1. see above
2. 
3. 


Actual results:
see above

Expected results:
Gnumeric should produce formula code that Excel will accept.

Does this happen every time?
Yes.

Other information:
Inspecting BIFF dumps shows that Gnumeric generates formula code for built-in function 92, but Excel itself generates formula code as though SERIESSUM is an add-in function. Gnumeric imports BOTH varieties without complaint. Possibly fn 92 is/was SERIES which is/was a chart-only function. Note that MS Excel 4.0 Function Reference Manual (Document Number AB26298-0392) dated 1992 says that SERIES is for charts only, and talks about the Analysis Toolpak add-in macro in connection with SERIESSUM.
Comment 1 Morten Welinder 2009-02-17 18:15:32 UTC 
I changed the name of #92 to SERIES, but I am not sure if this breaks
loading of anything we care about.

Leaving open.
Comment 2 Morten Welinder 2012-09-29 20:41:28 UTC 
No screams of horrow rang out, so the fix appears to work fine.