gmane.comp.gnome.apps.gnumeric

Feature Request

Rosa Maria — 2012-05-22T17:24:03

Hello,

I request this for Gnumeric, the evaluation of a formula step-by-step wiht intermediate results.

Thanks in advance and best regards.

Rosa María
(Inercina)

 
"Cuídate de la Ciencia que no Llora, de la Filosofía que no Ríe y de la Grandeza que no se inclina ante los niños"

"Madre es el nombre de dios en los labios y en los corazones de todos los niños"
_______________________________________________
gnumeric-list mailing list
gnumeric-list< at >gnome.org
http://mail.gnome.org/mailman/listinfo/gnumeric-list

Possible bug with paste special

2012-05-21T10:59:36

Dear developers,

I select cells AH2 and AI2, copy, go to cell N2 and paste special with 
"don't change formula" (or whatever it shows in English). Now cell N2 
contains the original formula from AH2, however cell O2 contains an 
adjusted formula, just what you get from normal copy/paste.

Using 1.10.17 - is this already fixed in version 1.11 or should I file a 
bug?

Regards
Soeren

Minor point: cum_biv_norm_dist

2012-05-21T10:41:57

Dear developers,

I remembered Gnumeric offers a bivariate normal distribution function. 
So I looked in statistics, couldn't find it, looked again, searched, 
still couldn't find it. Thought I was wrong. Then accidently found it in 
finance.

Wouldn't cum_biv_norm_dist find a better home in the statistics section?

Regards
Soeren

decimal separator

Markus Bergholz — 2012-05-20T07:22:54

if gnumeric displays dots or commas as decimal seperator is depend  on
the locale.
for comma as decimal seperator $ LC_NUMERIC="de" gnumeric
for dot as decimal seperator $ LC_NUMERIC="en" gnumeric

but is there a way to change this in gnumeric and don't start gnumeric
with different locale?


greeting
markus

HYPERLINK - bug #81718?

Bob Mesibov — 2012-05-11T05:20:40

I use Gnumeric 1.10.8

If I want to put a hyperlink into a Gnumeric cell, I have to use the Add Hyperlink dialogue. Using the HYPERLINK function does not add a hyperlink to a cell.

In bug discussion 81718

https://bugzilla.gnome.org/show_bug.cgi?id=81718

developer Andreas does not see a use case for HYPERLINK:

"I have yet to see any use case for HYPERLINK that would not be better solved by adding a huperlink." (comment 19)

Here is one: I have a Gnumeric spreadsheet listing 2000 music tracks and their details, one track per spreadsheet row. I would like one cell in each row to link to the track, so that clicking on the link in that cell will open the track from my hard drive using the default audio player for that file type.

It would take many hours to Add Hyperlink 2000 times in this spreadsheet. It would be more efficient to add a column containing the filepath addresses of the 2000 tracks, then use HYPERLINK ({cell address for filepath},"link text") in the first cell and copy down 1999 times, which wo

How does one manipulate cell values with Python.

Dr. Edward Scott — 2012-05-07T08:37:15

With Visual Basic one can manipulate the value in a cell using: 
Activecell.value = 24 for example.  What statement in Python is used to
accomplish the same action?  The Python manuals are silent on the matter
so far as I can tell and the gnumeric help offers no information that I
can discern.
ers.dallas< at >gmail.com

Bind menu accelerator to python plugin

2012-05-01T06:26:00

Hello is it possible to bind a menu shortcut to a pyhton ui plugin? Following did not work: 

<action name="Fill_from_above">
<label>Fill from above\tF8</label>
</action>

Manual page of ssconvert

Dick Bingham — 2012-04-30T14:39:53

Unable to execute " man ssconvert", as suggested from "
http://projects.gnome.org/gnumerics/doc/s..  "Converting Files".

ssconvert is located in my C:\Program Files (x86) Gnumeric/1.10.16/bin/    .
Have been able to execute "ssconvert --list-importers", but Not "man
ssconvert".

The message I get is "man ssconvert" is not recognized. ( from the bin
listed above ? )

my system : Hp Pavilion core 13 running Win 7.; Hard drive 1.+ terabytes ,
8GB main memory..

Have printed "converting Files", " File formats" and especially "Quattro
pro File Format".  ( My goal is to convert existing QuATTRO pRO FILES  to
gnum  or calc.org formats. )

What help can you offer? once I was pretty handy with DOS commands.  what
am I overlooking here ?   All guidance appreciated.

Have a Great Day !  Dick Bingham from DickBinFla< at >gmail.com
_______________________________________________
gnumeric-list mailing list
gnumeric-list< at >gnome.org
http://mail.gnome.org/mailman/listinfo/gnumeric-list

Gnumeric Python: get position of the current selected cell

2012-04-30T06:02:00

Hello, I searched a very long time (in googge and examples), but I didn't find out, how to retrieve the position (for example A2) of the current selected or "active" cell. I only found about ranges, but no single cell selected.

I need it for my ui plugin to fill the current selected cell with a certain value.

My question is: how can I get the position of the current selected cell? ;)

many thanks in advance

Gnumeric Domain Windows

Marco24 — 2012-04-13T10:37:02

Hi! I installed Gnumeric on a PC in my school (Windows Server 2008 R2, WITH
20 pc with Win 7).
I'm from Italy, My Windows 7 Is IT, my configuration settings is on ITA, but
Gnumeric menu are in English.
There's a possibility to change this?

Many Thanks!

compile gnumeric win32 with cross-mingw compiler on linux

付天豪 — 2012-04-10T09:03:45


I use MinGW cross compiling environment :http://mingw-cross-env.nongnu.org/
and compile the Dependency :GTK2 , Goffice, libgsf glib pango libglade2 intltool gnome-xml
I use the command:
./configure --host=i686-pc-mingw32
output:
Compiler:i686-pc-mingw32-gccCompiler flags:-g -O2 -Wall -Wmissing-prototypes  -Wsign-compare -Wpointer-arith -Wnested-externs -Wchar-subscripts -Wwrite-strings -Wdeclaration-after-statement -Wnested-externs -Wmissing-noreturn -Wmissing-prototypes -Wmissing-declarations -Wno-pointer-sign -Werror=format-securityFloating point type:double
UI:Gtk
Perl Support:yes (using perl)Python Support:unable to find Python.h
GDA support:NO.  libgda problemGNOME-DB support:noPsiconv support:        missing dependencies
PDF documentation:No, not requested.
then  I  use the command:
make
gnm-marshalers.h is empty, I  copied the linux   version of gnm-marshalers.h(With the make command automatically generated)
then I re-use the command:
make 
output:
  CCLD   gnumeric.exe/opt

Cross-compiler encountered the problem

付天豪 — 2012-04-09T03:49:25

 
CCLD   gnumeric.exe/opt/mingw/usr/lib/gcc/i686-pc-mingw32/4.6.0/../../../../i686-pc-mingw32/bin/ld: warning: --export-dynamic is not supported for PE targets, did you mean --export-all-symbols?main-application.o: In function `handle_paint_events':/root/gnumeric-1.10.17/src/main-application.c:127: undefined reference to `__imp__initial_workbook_open_complete'main-application.o: In function `main':/root/gnumeric-1.10.17/src/main-application.c:386: undefined reference to `__imp__initial_workbook_open_complete'/root/gnumeric-1.10.17/src/main-application.c:436: undefined reference to `__imp__initial_workbook_open_complete'collect2: ld returned 1 exit statusmake[4]: *** [gnumeric.exe] 错误 1
and  i do  not how  i can do about it.       _______________________________________________
gnumeric-list mailing list
gnumeric-list< at >gnome.org
http://mail.gnome.org/mailman/listinfo/gnumeric-list

Dynamic range in Diagrams

FrancisA — 2012-04-08T12:26:57

Hello, I created a histogramm.

Example
   A B ...
1 1
2 2
3 3
4 2
5 3
6 1
7 3
8...

A Histogram (I have much more Diagrams based on that Datas) in the range
A1:A7

So from time to time, I want to append datas (for example A8 and A9), and as
it is now, I have to correct alls data ranges in each diagram (extend from
A7 to A9 in this example)

So my question is: is there any possibility for the diagrams to look for the
last filled in cell in a column?

Thank you in advance!

gnm-marshallers.h is empty

付天豪 — 2012-04-06T08:27:24


gnm-marshallers.h  is empty

It seems to be automatically generated ，and how i can do about it?
(i romved it ,and run make again,and it was empty too,)       _______________________________________________
gnumeric-list mailing list
gnumeric-list< at >gnome.org
http://mail.gnome.org/mailman/listinfo/gnumeric-list

Help me please

付天豪 — 2012-04-06T00:33:44


when i compile gnumeric :
gnm-solver.c: In function 'gnm_solver_class_init':gnm-solver.c:1234:10: error: 'gnm__BOOLEAN__OBJECT_POINTER' undeclared (first use in this function)gnm-solver.c:1234:10: note: each undeclared identifier is reported only once for each function it appears ingnm-solver.c:1256:10: error: 'gnm__BOOLEAN__POINTER' undeclared (first use in this function)gnm-solver.c:1266:10: error: 'gnm__VOID__BOOLEAN_INT' undeclared (first use in this function)
In gnm-marshalers.c i find the gnm__BOOLEAN__OBJECT_POINTER, and in gnm-solver.c head #include "gnm-marshalers.h"
I don't know how to Solve this problem       _______________________________________________
gnumeric-list mailing list
gnumeric-list< at >gnome.org
http://mail.gnome.org/mailman/listinfo/gnumeric-list

advanced filters intervals

bob2029 — 2012-04-04T09:15:55

Hello!
I have a problem with advanced filters. I want to use a criteria 1000<J<2000
but if i use two criteria in the column : J<2000 and J>1000, gnumeric do
J>1000 OR J<2000. I want to do J>1000 AND J<2000. I don't know how.
Thanks for your answers.
bob2029

advanced filters intervals

vincent hautiere — 2012-04-04T09:56:16

Hello!
I have a problem with advanced filters. I want to use a criteria
1000<J<2000 but if i use two criteria in the column : J<2000 and J>1000,
gnumeric do J>1000 OR J<2000. I want to do J>1000 AND J<2000. I don't know
how.
Thanks for your answers.
bob2029
_______________________________________________
gnumeric-list mailing list
gnumeric-list< at >gnome.org
http://mail.gnome.org/mailman/listinfo/gnumeric-list

How to compile gnumeric for windows from unbuntu?

付天豪 — 2012-03-29T10:00:18

How to compile gnumeric for windows from unbuntu?I learned on the Internet, it seems that you can use mingw, but has not been tried successfully.And I find /gnumeric/tools/win32 directory, there are some build files, but I do not know how to use them.I really do not.I hope the forum know how brothers can give suggestions, thank you!       _______________________________________________
gnumeric-list mailing list
gnumeric-list< at >gnome.org
http://mail.gnome.org/mailman/listinfo/gnumeric-list

Format Painter

Dave Harris — 2012-03-26T16:13:21

Hi, I have looked back in the archives and noticed that the equivalent  of Excel's Format Painter has often been mooted - Has Gnumeric now got this option (I can't see it)
Regards
Dave       _______________________________________________
gnumeric-list mailing list
gnumeric-list< at >gnome.org
http://mail.gnome.org/mailman/listinfo/gnumeric-list

Reply to Old Nabble post not showing up

greigsteve — 2012-03-24T19:52:02

I posted a query on old nabble forum (Ignore text in array formula) and when
I go back to that site it indicates that there have been no replies to it. I
just happened across the mail.gnome.org archives and noticed my post there
and, suprisingly, a reply to it. I could not see anyway of replying from
there so made a new post from old nabble to reply to the reply. Steve

ignore text in array formula 2

greigsteve — 2012-03-24T19:42:36

Have only just seen your reply Soeren due to a problem I had which I have
posted as a separate thread.

I have tried the expression you suggest and also a number of variants but
still cant get it to work although I can see the logic behind it. The
expression you suggested was changing H2 to
=sum(if(isnumber(B$2:B$300);(B$2:B$300)*($D$2:$D$300=$F2);0))

The example with the problem is :
http://old.nabble.com/file/p33544690/Ignore_text_array_formula.gnumeric
Ignore_text_array_formula.gnumeric 

Thank you, Steve