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

Re: Minor point: cum_biv_norm_dist

Hal Ashburner — 2012-05-21T10:43:19

I always thought so myself...
Hal

On 21 May 2012 20:41, <so09< at >gmx.de> wrote:

_______________________________________________
gnumeric-list mailing list
gnumeric-list< at >gnome.org
http://mail.gnome.org/mailman/listinfo/gnumeric-list

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

Re: decimal separator

Jean Brefort — 2012-05-20T07:38:14

Le dimanche 20 mai 2012 à 09:22 +0200, Markus Bergholz a écrit :

No, as far as I know.
Regards,
Jean

_______________________________________________
gnumeric-list mailing list
gnumeric-list< at >gnome.org
http://mail.gnome.org/mailman/listinfo/gnumeric-list

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 would take only a few seconds.

I can't do this in Gnumeric, but I can in Open/Libre Office and Excel, which means I have to change spreadsheet programs to get this use. Maybe Gnumeric should just drop the HYPERLINK function?

Re: using python: crash, when importing gtk

2012-05-08T18:40:52

Is reported: https://bugzilla.gnome.org/show_bug.cgi?id=675698

Re: using python: crash, when importing gtk

Jean Brefort — 2012-05-08T13:21:43

Please file a bug report, and attach sample files/plugins. This is
serious enough to need a fix.

Regards,
Jean

Le dimanche 06 mai 2012 à 15:26 +0200, Jean Brefort a écrit :


_______________________________________________
gnumeric-list mailing list
gnumeric-list< at >gnome.org
http://mail.gnome.org/mailman/listinfo/gnumeric-list

Re: How does one manipulate cell values with Python.

Jim Tarvid — 2012-05-08T10:36:37

A few years ago, I needed "pivot" and resorted to short python
scripts. One example follows:

#!/usr/bin/python
#pyaay.py - prevalence by year and age to age and year, tail constant
from numpy import *
import xlrd
import csv
d=zeros ((7,41))
fn="prev.xls"
print fn;
book = xlrd.open_workbook(fn)
sh = book.sheet_by_index(1)
for a in range(1,8):
  for y in range(1,18):
    v=sh.cell_value(y,a)
    d[a-1][y-1]=v
    print "d[",a-1,",",y-1,"]=",v
  for y in range(18,42):
    d[a-1][y-1]=v
    print "d[",a-1,",",y-1,"]=",v

writer = csv.writer(open("prev.csv", "wb"))
for a in range(7):
  writer.writerow(d[a])

On Tue, May 8, 2012 at 6:07 AM, Jean Bréfort
<jean.brefort< at >normalesup.org> wrote:

Re: How does one manipulate cell values with Python.

Jean Bréfort — 2012-05-08T10:07:09

You might find some hints at
http://projects.gnome.org/gnumeric/doc/sect-extending-python-console.shtml

Regards,
Jean

Le lundi 07 mai 2012 à 15:37 +0700, Dr. Edward Scott a écrit :


_______________________________________________
gnumeric-list mailing list
gnumeric-list< at >gnome.org
http://mail.gnome.org/mailman/listinfo/gnumeric-list

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

Re: Using logfit on worksheet - please describe thoroughly for a dummy

Igors Mihailovs — 2012-05-07T05:56:01

Thanks a lot, I have been adviced to use transpose function by Jean
meanwhile! And thank you for thorough clarification!


2012/5/7 Andreas Guelzow <aguelzow< at >pyrshep.ca>

Re: Re: Using logfit on worksheet - please describe thoroughly fora dummy

Andreas Guelzow — 2012-05-07T05:44:54

The only way you can transpose while pasting is by using copy and then
paste special, so you have to have the output on the sheet first. In
that case you cannot overwrite a parts of the array.

If you want to have the output of logfit transposed, then rather than
using =logfit(...) as an array function, you should be using
=transpose(logfit(...))

Andreas

Re: using python: crash, when importing gtk

Jean Brefort — 2012-05-06T13:26:04

Le dimanche 06 mai 2012 à 15:06 +0200, scrutinizer< at >gmx.at a écrit :

No, I'm facing similar behavior with the gtk3 version (calling a python
function, and then opening the python console does not work properly). I
am not a Python expert (actually, I don't know Python at all). This
makes things difficult to analyze and fix. Just the fact that this also
occurs with 1.10 makes me think I might not have introduced a new bug)

Regards,
Jean

_______________________________________________
gnumeric-list mailing list
gnumeric-list< at >gnome.org
http://mail.gnome.org/mailman/listinfo/gnumeric-list

Re: using python: crash, when importing gtk

2012-05-06T13:06:09

-------- Original-Nachricht --------


I don't know, if it is related to that. Similar things happen in 1.10.17 with gtk2.

I have two python pugins, each of them imports gtk. The first plugin works fine, but if I start the second one (both plugins are "gui" plugins, then a traceback appears)

import pygtk

pygtk.require('2.0')

import gtk
import Gnumeric ...

Traceback (most recent call last):
  File "transpose", line 17, in <module>
  File "/usr/lib/python2.7/dist-packages/gtk-2.0/gtk/__init__.py", line 42, in <module>
    import gdk
ImportError: No module named gdk
E Execution of module "transpose" failed.
^[[A
** (gnumeric:2108): CRITICAL **: gplp_unload_service_function_group: assertion `IS_GNM_PLUGIN_SERVICE_FUNCTION_GROUP (service)' failed

If I start plugin A (starts ok), then plugin B will fail. If I restart Gnumeric, first start plugin B (works ok), then launching plugin A will fail again with the traceback message above. 

Do you know a fix or workaround for the buggy behaviour?

regards,

Re: Re: Using logfit on worksheet - please describe thoroughly for adummy

Igors Mihailovs — 2012-05-06T11:56:31

Hello Jean,
Thank you very much for your help! It would be nice if you also add this to
the actual "Help" of "Gnumeric", in case you haven't yet. "Gnumeric" is
indeed very practical and convenient for use, personally I like it more
than "LibreOffice Calc", partially because of better compatibility with MS
Excel file format, partially for its great charting tool and solver.

I submitted the bug - but while I was making a sample worksheet I run onto
another one :) When I paste the output of LOGFIT transposing it
simultaneously, I did it in the wrong place and obtained !#REF error
(actually, I was going to paste it as values but forgot to select
appropriate option). So I wanted to delete the erroneous array - and here
the bug appeared: when I selected it and pressed "Delete", "Gnumeric"
complained that array XNN:XNN will be split, where XNN:XNN is the array
where the output of LOGFIT would be if it were not transposed. So I had to
select the full square (5x5 in this case) to be able to use "Delete" key.
The bug is not crucial (when I'm aware of it, I understand that I can
perform the "transpose" operation in an extra workbook to not corrupt my
data), but it seems to me better if I report it, too.

See attachment for sample workbook. Interestingly, when a workbook is saved
and then reopened, the array appears to be pasted WITHOUT being transposed.

2012/5/5 Jean Brefort <jean.brefort< at >normalesup.org>:

Re: Using logfit on worksheet - please describe thoroughly for a dummy

Jean Brefort — 2012-05-05T15:38:39

The unreadable characters might be a bug, please file a bug report and
attach a sample screenshot (or, better, a sample workbook).


When you enter an array formula as iut is the case for fitting, you need
to select the cells which will receive all the results, type the formula
and then Ctrl+Shift+Enter.


Hope this helps,
Jean

Le samedi 05 mai 2012 à 10:58 +0300, Igors Mihailovs a écrit :


_______________________________________________
gnumeric-list mailing list
gnumeric-list< at >gnome.org
http://mail.gnome.org/mailman/listinfo/gnumeric-list

Re: using python: crash, when importing gtk

Jean Brefort — 2012-05-05T13:44:42

Le vendredi 04 mai 2012 à 07:32 +0200, scrutinizer< at >gmx.at a écrit :

It should fail because things can't work currently. It does not fail
actually, and this is a bug.


Hmm, this is clearly a bug. Something tries to initialize gobject type a
second time, and, of course, this fails. I'm suspecting this occurs
during gnm_python_init() execution. This code needs much love in order
to work. It currently imports pygtk wich is not compatible with gtk-3.

Regards,
Jean



_______________________________________________
gnumeric-list mailing list
gnumeric-list< at >gnome.org
http://mail.gnome.org/mailman/listinfo/gnumeric-list

Using logfit on worksheet - please describe thoroughly for a dummy

Igors Mihailovs — 2012-05-05T07:58:49

Dear helpful people,
As LOGFIT function returned regression equation on a chart with some
characters unreadable (between a and b, or some parts of them), I
tried to use it on worksheet. Help says it should return an array with
5 numerical results. But how can I view these results on a worksheet?
Only the 1st one is displayed in the cell where the function is
entered. I suppose I should point explicitly to the cells where I want
results to appear, but how? I googled a lot but haven't found
anything, at least anything I could understand.
Many thanks in advance!

--
Best regards,
Igors

Re: using python: crash, when importing gtk

2012-05-04T05:32:07

-------- Original-Nachricht --------

Hello Jean, I don't understand why.


I tried using PyGI instead. A dialog appears, but then, after pressing the ok button, gnumeric hangs.

gnumeric

/usr/lib/python2.7/dist-packages/gi/_gobject/constants.py:24: Warning: g_boxed_type_register_static: assertion `g_type_from_name (name) == 0' failed
  from . import _gobject

the mini test plugin:

from gi.repository import Gtk

import Gnumeric

# Called when user presses "OK" in dialog.
def cb_ok_test (dialog, event):
    dialog.destroy()

# Populate sheet and show dialog.
def f_transpose(gui):

    dialog = Gtk.MessageDialog(None,
                               Gtk.DialogFlags.DESTROY_WITH_PARENT,
                               Gtk.MessageType.INFO,
                               Gtk.ButtonsType.OK,
                               "Press OK to transpose")
    dialog.connect('response', cb_ok_test)
    dialog.run()

# This dictinary binds verbs to Python functions.
transpose_ui_actions = {
    'Transpose': f_transpose,
}