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 162480 - functions to refer to header and footer
functions to refer to header and footer
Status: RESOLVED WONTFIX
Product: Gnumeric
Classification: Applications
Component: Analytics
git master
Other All
: Low enhancement
: ---
Assigned To: Morten Welinder
Jody Goldberg
Depends on:
Blocks:
 
 
Reported: 2004-12-29 16:15 UTC by Helmut Wollmersdorfer
Modified: 2010-06-15 20:27 UTC
See Also:
GNOME target: ---
GNOME version: ---



Description Helmut Wollmersdorfer 2004-12-29 16:15:19 UTC
I would like to see the following feature implemented in Gnumeric, which I also
missed in XL:

- make it possible to use functions in header and footer of a page like this
  
   Custom header configuration
    
     Left section:
     =Sheet1!A1

This feature would allow to generate texts in headers and footer which depend on
the contents of "normal" cells. I missed this feature in generating automated
reports or applications like this.

As a general design approach the sections (left, middle, right) of header and
footer could be implemented with the same functionality as "normal" cells, but
with special addresses like

   sheet1!header!left or
   sheet1!header1 or
   sheet1!header!A1

This also will allow to reference the content of header/footer cells by other
cells.
Comment 1 Jody Goldberg 2005-01-17 04:42:45 UTC
A nice idea.  We'll need to rework and extend the hooks for headers/footers
eventualyl to support XP's extensions for things like font characteristics and
images.  Adding extensions to pull in data would be nice.  It's hard to say how
XLS export would handle it, but we can probably just strip it, and put in the
current value.
Comment 2 Andreas J. Guelzow 2007-11-18 19:26:15 UTC
With the next released version

&[cell:$A$3]   and &[cell:Sheet2!$A$3]

will include the content of cell $A$3 on the current Sheet and on Sheet2 respectively.

I am leaving this open with a changed title (and a changed component) since this does not address the second suggestion. Personally I think it would be better to implement that as function calls rather than as as references:
=header("Sheet1",1) or so. 
Comment 3 Andreas J. Guelzow 2010-06-15 20:27:14 UTC
While it seems useful to include sheet data in the headers and footers, that is in fact already possible.

There doesn't seem to be a real use case for being able to refer to the header footer info from within the sheet. I'll therefore close it as WONTFIX.