Re: Column/Row numbers?

On Wed, 28 Jun 2006 15:34:42 -0300 John Coppens [EMAIL PROTECTED] wrote: Hi all. Suddenly, all column and row numbers were replaced by their hex codes (the little squares with 4 hex digits in them). The codes are correct - 0041, 0042 etc. The only difference I can imagine influenced

Still no column/row labels

Hi all. A couple of weeks ago, I reported that col/row labels had disappeared (then, they showed as the special character hex codes squares -which they weren't- now they don't show at all. I'll have to re-install gnumeric I guess, but before that, is there some external factor/configuration item

Re: Still no column/row labels

On Fri, 11 Aug 2006 16:25:12 -0600 Andreas J. Guelzow [EMAIL PROTECTED] wrote: On Fri, 2006-11-08 at 14:55 -0300, John Coppens wrote: Hi all. A couple of weeks ago, I reported that col/row labels had disappeared (then, they showed as the special character hex codes squares -which

How to use the LINEST function?

Hi all... Please, a hand! I've tried to use the LINEST function, and I can only get the M coefficient. THe docs say it is supposed to return two cols by one row, so I tried to select two adjecent cells, and call LINEST again. I've tried to find manuals for other ss's, and tried it that way, no

Re: How to use the LINEST function?

On Fri, 18 Aug 2006 07:47:43 +0200 Jean Bréfort [EMAIL PROTECTED] wrote: Le vendredi 18 août 2006 à 01:39 -0300, John Coppens a écrit : Hi all... Please, a hand! I've tried to use the LINEST function, and I can only get the M coefficient. THe docs say it is supposed to return two

Re: Another problem - page locked

On Sat, 19 Aug 2006 02:27:20 -0300 John Coppens [EMAIL PROTECTED] wrote: Hello all. One of the pages of a spreadsheet doesn't allow editing anymore. It's not possible to enter either data or formulas. Existing data can be edited though. Only clear cells cannot be edited into. Sri

Re: Another problem - page locked

On Fri, 15 Sep 2006 16:26:55 -0400 Morten Welinder [EMAIL PROTECTED] wrote: This effect could be achieved with validations, but it would be easier to tell if you let us know what happens when you try to enter new values. Hi Morten... Nothing happens. Nothing at all. No messages, no warnings.

UTF-8 problem (XLS)

Hello people. Using version 1.6.3 of gnumeric, I tried to read an xls file and save it as csv. There was a problem with the resulting csv file, in that iconv didn't want to convert it into another coding. I'm not sure where the problem lies. The original .xls had the following string in it:

Re: UTF-8 problem (XLS)

On Sun, 05 Aug 2007 23:33:30 -0600 Andreas J. Guelzow [EMAIL PROTECTED] wrote: Are you useing the configurable text exporter or the defaults csv? If you use the latter give the former a try and choose the desired encoding. Hi Andreas, Thanks for the reply. Apparently, the strange characters

Re: UTF-8 problem (XLS)

On Tue, 07 Aug 2007 11:22:39 +0100 Nick Lamb [EMAIL PROTECTED] wrote: On Mon, 2007-08-06 at 11:04 -0300, John Coppens wrote: The origin of the strange characters in the file still unclear. These xls files are sent to my wife's pharmacy monthly with updates. It would be interesting to know

Suggestion

Hi guys May I suggest adding a paragraph to the 'Entering Text' chapter in the user manual? Something like: Please note that what you type may possibly be automatically corrected if the Auto correct feature is enabled (Check Tools|Auto Correct...). This may not always be the desired behaviour

Data import - open data

Hello all, I did a small experiment that generated a data file with 513 lines, each with 2 values, separated by commas (these are the last lines): ... 13,95 12,95 11,94 10,93 9,92 8,92 7,90 6,89 5,87 4,82 3,72 2,58 1,39 0,11 - If I open the file as a spreadsheet, everything is ok. - If I read

Re: Data import - open data

On Thu, 28 May 2009 11:13:56 -0400 Morten Welinder mort...@gnome.org wrote: That is a GTK+ bug. They changed behaviour, see http://bugzilla.gnome.org/show_bug.cgi?id=580930 Thanks, Morten... Never suspected the problem to be in the spinbutton ;-) John

Compiling gnumeric from git

Hi all. Due to the issues in the previous mail, I tried to download and compile gnumeric from git. GOffice went without a hitch, libgsf complained though: Running intltoolize... cp: cannot stat `/usr/local/share/aclocal/intltool.m4': No such file or directory intltoolize: cannot copy

Re: Gnumeric cell 'spreading'

On Wed, 3 Jun 2009 15:47:05 -0400 Morten Welinder mort...@gnome.org wrote: I cannot reproduce with a quick test. Please file at bugzilla.gnome.org with detailed instructions on how you reproduce. (What you enter, what you click, what you see.) Done. John

Compilation problems

Hello all. ./configure and make went well, except for a load of '... is not a prototype warnings'. Make install did this: for file in gnumeric-C.omf; do \ /usr/bin/ginstall -c -m 644 $file.out /usr/local/share/omf/gnumeric/$file; \ done /usr/bin/ginstall: cannot stat `gnumeric-C.omf.out': No

Re: Sub/Superscripts disappeared in 1.10.x?

On Wed, 16 Jun 2010 13:01:10 -0600 Andreas Guelzow aguel...@pyrshep.ca wrote: View-Toolbars gives a choice of toolbars. The long format toolbar has the buttons you seek. The short one does not. Thanks both Jean and Andreas - both info items are welcome! John

Re: Background color change

On Fri, 6 Mar 2015 14:58:04 -0300 John Coppens j...@jcoppens.com wrote: Of course I can define the foreground color for the text in Gnumeric, but this does not seem to be an elegant solution for portability. My apologies - this doesn't seem true either. Setting background to any color makes

Background color change

I realize this has probably been asked frequently, but I can't seem to get any of the solutions to work. The problem: I compiled Gnumeric 1.12.20 - first time for Gtk3 - and found that my dark theme produces a fairly dark background, and black text in the cells - nearly unreadable. In order to

Re: Background color change

On Fri, 6 Mar 2015 15:13:54 -0300 John Coppens j...@jcoppens.com wrote: What am I doing wrong here? Well, I found the solution, I think. As indicated in many forums, I had redirected ~/.config/gtk-3.0 to a theme of (almost) my liking, FlatStudioDark. But it seems that XFCE, through a mechanism

Re: Help

On Wed, 13 Apr 2016 08:48:29 + Jakob Noe-Nygaard wrote: > The question is, if it's possible to load multiple files into one session of > gnumeric instead of having to have an instance for each file? There seems to be a command line option to ssconvert to merge several

Re: How is Gnumeric so fast?

On Sat, 15 Jul 2017 13:42:48 +1000 Leon Taylor wrote: > I understand that Gnumeric was programmed in C, which means that it was > going to be fast, but LibreOffice Calc and Excel would be programmed in > C++, which is just as fast as C (That is, assuming that it is

Re: Remembering window location

On Thu, 23 Jan 2020 20:01:17 -0500 Numos Pseudo via gnumeric-list wrote: > Is there a way to get Gnumeric to remember window location and open > in the same spot every time? I'm using the Windows version of the app > (1.10.16). Not sure if this is the same in Windows, but I suspect so. As

Formatting complex numbers?

Hi all, I'm working with complex numbers, and can't find how to limit the resolution. It's entirely unpractical as it is, as both the real and imaginary parts are shown with the full float numbers, and +/- nr digits or cell formatting don't seem to have any influence. The solution shown

How to return multiple values from a Python function plugin?

Hi, I've figured out how to create Python plugin functions for Gnumeric, and some are even working ;-) However, I need to return multiple values from a function (to be stored in adjecent cells) but cannot find any reference on how to do that. I did find a reference to a Python API - possibly

Python console background color

Hi all. Is there a way to change the background color of the Python console? XFCE is set to a dark theme, and the console comes up with a rather dark background - which is fine - but most of the text is dark blue or black. I've been looking for the UI definition, but can't find anything. John