headers
Bob Mesibov | 11 May 07:20
Picon

HYPERLINK - bug #81718?

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?
Permalink | Reply | 0 comments |
headers
Dr. Edward Scott | 7 May 10:37
Picon

How does one manipulate cell values with Python.


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
Permalink | Reply | 2 comments |
headers
Igors Mihailovs | 7 May 07:56
Picon

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

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>
On Sun, 2012-05-06 at 14:56 +0300, Igors Mihailovs wrote:
> 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",

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
--
Andreas Guelzow <aguelzow <at> pyrshep.ca>

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



--
With best regards,
Igors 




--
Ar cieņu,
Igors Mihailovs
С уважением,
Игорь Михайлов


_______________________________________________
gnumeric-list mailing list
gnumeric-list <at> gnome.org
http://mail.gnome.org/mailman/listinfo/gnumeric-list
Permalink | Reply | 0 comments |
headers
Igors Mihailovs | 6 May 13:56
Picon

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

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>:

> 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 :
>> 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
>> _______________________________________________
>> gnumeric-list mailing list
>> gnumeric-list <at> gnome.org
>> http://mail.gnome.org/mailman/listinfo/gnumeric-list
>
>



--
With best regards,
Igors



Attachment (logfit_possible_bugs.gnumeric): application/octet-stream, 2566 bytes
_______________________________________________
gnumeric-list mailing list
gnumeric-list <at> gnome.org
http://mail.gnome.org/mailman/listinfo/gnumeric-list
Permalink | Reply | 1 comment |
headers
Igors Mihailovs | 5 May 09:58
Picon

Using logfit on worksheet - please describe thoroughly for a dummy

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
Permalink | Reply | 1 comment |
headers
scrutinizer | 1 May 08:26
Picon
Picon

Bind menu accelerator to python plugin

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>

--

-- 
NEU: FreePhone 3-fach-Flat mit kostenlosem Smartphone!                                  
Jetzt informieren: http://mobile.1und1.de/?ac=OM.PW.PW003K20328T7073a
Permalink | Reply | 0 comments |
headers
Dick Bingham | 30 Apr 16:39
Picon

Manual page of ssconvert

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
Permalink | Reply | 1 comment |
headers
scrutinizer | 30 Apr 08:02
Picon
Picon

Gnumeric Python: get position of the current selected cell

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
--

-- 
NEU: FreePhone 3-fach-Flat mit kostenlosem Smartphone!                                  
Jetzt informieren: http://mobile.1und1.de/?ac=OM.PW.PW003K20328T7073a
Permalink | Reply | 21 comments |
headers
Marco24 | 13 Apr 12:37
Picon
Favicon

Gnumeric Domain Windows


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!
--

-- 
View this message in context: http://old.nabble.com/Gnumeric-Domain-Windows-tp33681006p33681006.html
Sent from the GnuMeric mailing list archive at Nabble.com.
Permalink | Reply | 3 comments |
headers
付天豪 | 10 Apr 11:03
Picon

compile gnumeric win32 with cross-mingw compiler on linux


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-gcc
Compiler 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-security
Floating point type: double

UI: Gtk

Perl Support: yes (using perl)
Python Support: unable to find Python.h

GDA support: NO.  libgda problem
GNOME-DB support: no
Psiconv 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/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 status

and i don't know how i can do about it 

Help me please !




_______________________________________________
gnumeric-list mailing list
gnumeric-list <at> gnome.org
http://mail.gnome.org/mailman/listinfo/gnumeric-list
Permalink | Reply | 0 comments |
headers
付天豪 | 9 Apr 05:49
Picon

Cross-compiler encountered the problem

 

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 status
make[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
Permalink | Reply | 0 comments |

Gmane