Unknown Excel functions in gnumeric-1.2.0-1.i386.rpm

[Paul Dickson]

I downloaded gnumeric from Rawhide (but cmp says severn has the same file)
and tried it on my one of my files.  Unfortunately, it tells me the
function '=upper(concatenate(A1, " ", B1))' is invalid.  It was
previously
valid in an earlier version of gnumeric (RH9) and the documentation on
gnumeric's home page says upper and concatenate are Excel functions (so I
doubt support was removed).

Is there a missing dependancy in gnumeric's RPM causing me to not know
what RPMs are missing or should I submit a bug report?


On starting up gumeric, I get the following warnings:

[dickson@violet 09:24:06 treasury]$ gnumeric sac-data-2003.gnumeric
 
** (gnumeric:19102): WARNING **: Configured default font '(null) 0.000000' not
available, trying fallback...
sac-data-2003.gnumeric
 
** (gnumeric:19102): WARNING **: Converted xml document with no encoding from pseudo-UTF-8
to UTF-8.
 
** (gnumeric:19102): WARNING **: Could not find child for option "PhysicalSize"
with id "US-Legal"
 
** (gnumeric:19102): WARNING **: Could not set value of "PhysicalSize" to
"US-Legal"
 
** (gnumeric:19102): WARNING **: Unknown function : concatenate
 
** (gnumeric:19102): WARNING **: Unknown function : upper
 
** (gnumeric:19102): WARNING **: Could not find child for option "PhysicalSize"
with id "US-Legal"
 
** (gnumeric:19102): WARNING **: Could not set value of "PhysicalSize" to
"US-Legal"
 
** (gnumeric:19102): WARNING **: Could not find child for option "PhysicalSize"
with id "US-Legal"
 
** (gnumeric:19102): WARNING **: Could not set value of "PhysicalSize" to
"US-Legal"
 
** (gnumeric:19102): WARNING **: GnomePrint: Requested Helvetica but using Bitstream
Charter (Bitstream Charter Bold 12.000000)
 
** (gnumeric:19102): WARNING **: Trying to fallback to 'Sans'
 
** (gnumeric:19102): CRITICAL **: file gnumeric-gconf.c: line 298
(gnm_gconf_set_file_history_files): assertion `prefs.file_history_files != list'
failed
[dickson@violet 09:24:40 treasury]$ 


	-Paul

[Tino Meinen]

Hi Paul

You have to enable the plugins first (Via the Tools -> Plug-ins)
The expression you give works just fine in gnumeric 1.2.0

(also make sure that the argument separator uses the right one for the
locale that you use within gnumeric. (for the Dutch locale that's ;
instead of ,)

Tino

Op do 02-10-2003, om 19:41 schreef Paul Dickson:
>  I downloaded gnumeric from Rawhide (but cmp says severn has the same
> file)
>  and tried it on my one of my files.  Unfortunately, it tells me the
>  function '=upper(concatenate(A1, " ", B1))' is invalid.  It was
> previously
>  valid in an earlier version of gnumeric (RH9) and the documentation on
>  gnumeric's home page says upper and concatenate are Excel functions (so I
>  doubt support was removed).

[Paul Dickson]

On Thu, 02 Oct 2003 23:56:10 +0200, Tino Meinen wrote:

>  Hi Paul
>  
>  You have to enable the plugins first (Via the Tools -> Plug-ins)
>  The expression you give works just fine in gnumeric 1.2.0
>  
>  (also make sure that the argument separator uses the right one for the
>  locale that you use within gnumeric. (for the Dutch locale that's ;
>  instead of ,)
>  
>  Tino
>  
>  Op do 02-10-2003, om 19:41 schreef Paul Dickson:
>  > I downloaded gnumeric from Rawhide (but cmp says severn has the same file)
>  > and tried it on my one of my files.  Unfortunately, it tells me the
>  > function '=upper(concatenate(A1, " ", B1))' is invalid.  It was
> previously
>  > valid in an earlier version of gnumeric (RH9) and the documentation on
>  > gnumeric's home page says upper and concatenate are Excel functions (so I
>  > doubt support was removed). 
I wasn't aware of having to enable the plugins.  Thanks.

After enabling the plugins and then restarting gnumeric, my spreadsheet
had no problems with the functions.

	-Paul