Re: plotting in the sheet dimension

2014-01-12 Thread Jean Bréfort
Hi João, This is just not implemented in graphs. I actually have no idea ihow it would be difficult to add this feature. Regards, Jean Le dimanche 12 janvier 2014 à 18:40 +0100, João MC Teixeira a écrit : Hi there, Amazing tool gnumeric is! I have a doubt on data range selection, for

Re: GLib warnings

2014-03-15 Thread Jean Bréfort
Yes, known issue, and fixed one hour ago or so. Cheers, Jean Le samedi 15 mars 2014 à 13:38 +, Allin Cottrell a écrit : With my last few builds of gnumeric (I'm currently running 1.12.12) I'm seeing several repetitions of this pair of warnings on exiting the program: (gnumeric:PID):

Re: Reverse legend in stacked column chart

2014-03-27 Thread Jean Bréfort
Hi, In a stacked chart, the series are displayed from bottom to top, while it is the reverse order in the legend. There is no way currently to change this behavior. Regards, Jean Le jeudi 27 mars 2014 à 19:52 +, Ditte Mølgård Heide-Jørgensen a écrit : Hi everyone, I'm using stacked

Re: Reverse legend in stacked column chart

2014-03-27 Thread Jean Bréfort
Actually, it seems that this has been fixed some times ago, which version are you using? Best regards, Jean Le jeudi 27 mars 2014 à 21:21 +0100, Jean Bréfort a écrit : Hi, In a stacked chart, the series are displayed from bottom to top, while it is the reverse order in the legend

Re: Reverse legend in stacked column chart

2014-03-28 Thread Jean Bréfort
Seems we need to update the pages. You can find a recent build at https://people.gnome.org/~mortenw/gnumeric/ Regards, Jean Le vendredi 28 mars 2014 à 06:06 +, Ditte Mølgård Heide-Jørgensen a écrit : Hi again, Thanks for your quick reply. I realized that I'm using 1.10.16 (from the Get

Re: excel-like improvements to chart editing

2014-04-15 Thread Jean Bréfort
Hi, Intersting ideas, we just miss volunteers to implement them et the moment. It would be nice to open as many enhancement requests at bugzilla.gomne.org so that those ideas don't disappear into some black hole. Cheers, Jean Le mardi 15 avril 2014 à 15:49 +0100, Marc Dunord a écrit : dear

Re: Chart Properties

2014-05-22 Thread Jean Bréfort
Hi, This is due to a Gtk+ behavior change. The bug has been fixed in goffice-0,10,10. You need to upgrade, but unfortunately, the package in current stable ubuntu is 0.10.9 Regards, Jean Le mercrei 21 mai 2014 à 21:15 -0700, mungstro a écrit : Hi... I'm having troubles because i recently

Re: Gnumeric Bug

2014-05-27 Thread Jean Bréfort
Hi, ssconvert is able to handle more than 64k rows, but not the .xls format. You should try with either .xlsx or .ods. Regards, Jean Le mardi 27 mai 2014 à 10:09 +0530, Nitesh a écrit : Hii, I am using current verson of gumeric and trying to convert .csv file to .xls file using gnumeric

Re: Use text-lables as x-axis values in XY Chart

2014-12-14 Thread Jean Bréfort
It is not currently possible. An enhancement request exists (https://bugzilla.gnome.org/show_bug.cgi?id=600482). Anyway, in your case a line plot might be more appropriate and allows any label. Reagards, Jean Le dimanche 14 décembre 2014 à 18:49 +0100, Giacomo Marchioro a écrit : Hi all, I am

Re: A plea from a semi-newbie

2015-01-16 Thread Jean Bréfort
You need a scatter (XY) plot, not a line plot. I'm pretty sure that my solution works. Can you provide me a sample file? Le jeudi 15 janvier 2015 à 16:24 -0700, rodgos a écrit : Thanks for the reply, but I don't think that it will help. My problem is two fold. First, I require the x axis to be

Re: A plea from a semi-newbie

2015-01-16 Thread Jean Bréfort
If you really want a line plot, you can ignore the time column. The first column is used as labels and the second as the values. Le vendredi 16 janvier 2015 à 15:08 -0700, rodgos a écrit : Well, I do seem to be making some headay in this problem, albeit slowly.. So far, Ive created a Gnumeric

Re: A plea from a semi-newbie

2015-01-15 Thread Jean Bréfort
Hi, If I understand correctly what you are doing, you need to add columns A and B to get the date and time in the same field. You can do that either in the sheet, using a new column, or in the series data field. For X values use A:A+B:B and for y values C:C. That should work if the time column

Re: error compiling gnumeric

2015-01-11 Thread Jean Bréfort
Dear Frédéric Which command line did you use, including environment variables? Also, using 'make -V' would give access to the exact command passed to the linker. Cheers, Jean Le dimanche 11 janvier 2015 à 21:09 +0100, Frédéric Parrenin a écrit : Dear all, Today I downloaded libgsf,

Re: error compiling gnumeric

2015-01-11 Thread Jean Bréfort
Hmm, Looks like I forgot to add the two libraries to the .pc file. Please update goffice, and build again. Le dimanche 11 janvier 2015 à 21:28 +0100, Jean Bréfort a écrit : Dear Frédéric Which command line did you use, including environment variables? Also, using 'make -V' would give access

Re: problem compiling goffice

2015-03-19 Thread Jean Bréfort
Try deleting the whole directory /home/fparrenin/local/lib/goffice/0.10.22 before installing. Jean Le jeudi 19 mars 2015 à 18:13 +0100, Frédéric Parrenin a écrit : Thanks for the hint, but that did not solve the issue, I still have the same error message. Frédéric 2015-03-19 18:00

Re: heat map or matrix plot

2015-03-12 Thread Jean Bréfort
à 08:05 +0100, Jean Bréfort a écrit : Hi, Select the cell range containing all your data and create the plot, that should work. Row and column don't need to be numeric and the colors should follow the numbers in the cells. But, after testing, I don't get what I thought it would do. I need

Re: heat map or matrix plot

2015-03-10 Thread Jean Bréfort
Hi, Select the cell range containing all your data and create the plot, that should work. Row and column don't need to be numeric and the colors should follow the numbers in the cells. But, after testing, I don't get what I thought it would do. I need to investigate a bit, feel free to file one

Re: Inserting images

2015-11-11 Thread Jean Bréfort
Le jeudi 12 novembre 2015 à 00:01 +, Dan MacDonald a écrit : > Hi gnumeric devs! > > I'd like to create a spreadsheet that would make quite heavy use of > images. The images will only be small (say 100x100 pixels or so) but > I will need to import quite a lot of them and on a regular basis. >

Re: gobject-introspection for Gnumeric [Was: Python headers for pygobject 3/Gnumeric 1.12.25]

2015-11-01 Thread Jean Bréfort
I don't know for Ruby, but with Python, you can do something like: $ python >>> import gi >>> gi.require_version('GOffice','0.10') >>> from gi.repository import GOffice >>> gi.require_version('Gnm', '1.12') >>> from gi.repository import Gnm >>> Gnm.init() >>> wb=Gnm.Workbook.new_with_sheets(1)

Re: Gnumeric in Mac OSX Yosemite

2015-09-30 Thread Jean Bréfort
Hi, I suppose you can use the package available with macports ( https://www.macports.org). Hope this helps, Jean Le mercredi 30 septembre 2015 à 18:06 +0900, Sayantani Chatterjee a écrit : > Hi, > I am recently using Mac OS, before it I was using Windows. So it's > little difficult for me to

Re: Can't delete multiple rows

2015-12-03 Thread Jean Bréfort
Deleting multiple rows only works for consecutive rows. It does not work for a multiple selection (the same for columns and cells). Multiple selection deletion is not supported. Please file an enhancement request at bugzilla.gnome.org. Regards, Jean Le mercredi 02 décembre 2015 à 11:49 -0600,

Re: statistics gtk glade2.12

2015-12-17 Thread Jean Bréfort
Hi, You might use the GOGraphWidget from goffice. I don't know how it can integrate with glade, Not sure if recent glade releases support custom widgets. About GOGraphWidget use, you'll find samples in the goffice/tests directory (go-demo.c and pie-demo.c). Hope this helps, Jean Le mercredi 16

Re: Is RGnumeric still available

2016-01-06 Thread Jean Bréfort
There is a plugin with functions imported from R in gnumeric. Go to Insert/Functions, choose statistics and look for r.* functions. Regards, Jean Le mercredi 06 janvier 2016 à 13:02 +, pi...@ticino.com a écrit : > There used to be a gnumeric R plug-in to use R functions inside > gnumeric.

Re: Considering taking on Windows port

2016-09-04 Thread Jean Bréfort
Hi, You should start from current git, imho. You'll find some code in the gnumeric/tools/win32 directory. Hope this helps, Jean Le dimanche 04 septembre 2016 à 20:17 +, Ron Gaw a écrit : > Okay, I'll take the plunge then.  Starting point - how / where do I > pull the last code set that

Re: odd xlsx problem

2016-11-29 Thread Jean Bréfort
No idea, I am unable to reproduce. May be something related to your xlsx files? Does this happen for all of them? Regards, Jean Le mardi 29 novembre 2016 à 11:56 -0500, Allin Cottrell a écrit : > I'm running gnumeric 1.12.32 on Arch Linux and I'm seeing an odd  > problem wih xlsx files: they

Re: Import images to cells

2017-03-18 Thread Jean Bréfort
Not possible as far as I know. Regards, Jean Le samedi 18 mars 2017 à 07:06 -0700, Grant a écrit : > > Can I import a CSV file (or similar) to gnumeric and have the > > images > > included there (base64 or local path or http path or ?) appear in > > the > > spreadsheet within or on top of the

Re: Text box in gnumeric plots

2017-03-10 Thread Jean Bréfort
Hi, Of course you can, just add a title to the chart, move it where you want the text, and type. You'll also have to change the font and font size, I suppose. You can also add the text as markup if you want rich text. Hope this helps, Jean Le vendredi 10 mars 2017 à 20:06 +, Scott

Re: problem compiling goffice

2017-04-25 Thread Jean Bréfort
Hi Frederic Check if you have m4/gtk-doc.m4 with the GTK_DOC_CHECK definition inside, otherwise, run autogen.sh again. Hope this helps, Jean Le lundi 24 avril 2017 à 18:00 +0200, Frédéric Parrenin a écrit : > Dear all, > > Today I tried to compile the latest git version of goffice on my >

Re: Problem with Font height/Row Height

2018-03-13 Thread Jean Bréfort
You can also change the monitor resolution used by gnumeric using the Preferences dialog (Windows/Screen path). If this does not work, please file a bug report. Hope this helps Jean Le lundi 12 mars 2018 à 15:04 -0700, Dean McCarron a écrit : > I ran into an identical problem when I migrated to

Re: segfault

2018-10-02 Thread Jean Bréfort
Not fully fixed. Removing one of the chart sheets makes gnumeric crash. Probably because of: sheet-view.c:226sv->controls->len - 10); the -10 seems quite strange, -1 would be better, imho. Cheers, Jean Le mardi 02 octobre 2018 à 12:44 -0400, Morten Welinder a écrit : > Fixed.

Re: segfault

2018-10-02 Thread Jean Bréfort
Please file a bug report. Regards, Jean Le jeudi 13 septembre 2018 à 17:44 -0400, Allin Cottrell a écrit : > I thought you might want to know, the attached xls file provokes a > segfault in 1.12.42 on Fedora. I'm aware that's not the latest > release so my information may be stale, but I'm not

Re: [gnumeric-list] [cazz...@di.unimi.it: Re: [gnumeric-list] Re: python plugins]

2020-04-04 Thread Jean Bréfort
Le samedi 04 avril 2020 à 12:08 +0200, Walter Cazzola a écrit : > On Sat, 4 Apr 2020, User Hayden via gnumeric-list wrote: > > > Actually many Linux distros ahve already switched to Python 3 > > though 2 > > may be available in the repositories. > > in my case, I've both python2 (2.7.17) and

Re: Print Preview

2020-04-02 Thread Jean Bréfort
Hi, I'm also using Debian Sid and Print Preview works for me. Actually, this command uses evince to display the result through gtk+ printing code. May be you have a problem with evince crashing, just a guess. Hope this helps, Jean Le jeudi 02 avril 2020 à 12:48 -0500, Chris Dunn a écrit : >

Re: python plugins

2020-04-02 Thread Jean Bréfort
Hi, The Python support in gnumeric is limited to Python-2, it can't work with Python-3. Regards, Jean Le jeudi 02 avril 2020 à 22:10 +0200, Walter Cazzola a écrit : > Dear All, > I'm a long time user of gnumeric, today I would like to add a quite > simple > python plugin that I'm writing but I

Re: Order of items in legend, stavked bar chart

2020-03-18 Thread Jean Bréfort
Hi, This is weird. For scatter plots, the first series comes first in the legend but for bar/column charts it comes last. For columns, it makes sense since the first series is displayed at low Y-axis values, but for bar charts, it clearly does not. Please file a bug report at gitlab.gnome.org,

Re: newbie

2021-05-27 Thread Jean Bréfort
Hi, You can use conditional formatting. Option "Cell value is = x." and today() as value. Hope this helps. Jean Le mercredi 26 mai 2021 à 21:20 +, Jakob Cornelis via gnumeric-list a écrit : > I use gnumeric’s calendar template for an events and appointments > calendar. One feature that

Re: gnumeric dark theme

2021-02-14 Thread Jean Bréfort
Hi, The answer is b. You need to add appropriate fields in you gtk.css file. You'll find the default along with some documentation in: https://gitlab.gnome.org/GNOME/gnumeric/-/blob/master/src/gnumeric.css Hope this helps, Jean Le lundi 15 février 2021 à 03:48 +0100, Fourhundred Thecat via

Re: Aw: Re: Re: need help in some points to get gnumeric 'long' mature. introspection, GDA support, GNOME-DB support, Psiconv, PDF documentation.

2022-05-02 Thread Jean Bréfort
support:  NO.  libgda > problem'  >   > assume it's the point 'with ui support' you mentioned, but how to do > that???  >   > --- > > :-)  >   > 'apt-get install -y libjson-glib-dev' made it for this step,  >   > will report about further progress ...  >   > t

Re: XYcolor plots

2021-11-13 Thread Jean Bréfort via gnumeric-list
level. Le samedi 13 novembre 2021 à 09:49 -0700, John Denker via gnumeric-list a écrit : > On 11/13/21 9:22 AM, Jean Bréfort wrote: > > > Actually, you can choose the colors: select the Z axis, then the color > > scale page and click New or Duplicate. You can build your own cust

Re: XYcolor plots

2021-11-13 Thread Jean Bréfort via gnumeric-list
Hi John, Actually, you can choose the colors: select the Z axis, then the color scale page and click New or Duplicate. You can build your own custom color scale. Hope this helps, Jean Le samedi 13 novembre 2021 à 08:31 -0700, John Denker via gnumeric-list a écrit : > Hi Folks -- > > The

Re: XYcolor plots

2021-11-13 Thread Jean Bréfort via gnumeric-list
Le samedi 13 novembre 2021 à 10:51 -0700, John Denker via gnumeric-list a écrit : > On 11/13/21 10:20 AM, Jean Bréfort wrote: > > > to delete a map, you can just erase the file in > > ~/.goffice/colormaps > > Wow, that's useful. I never would have guessed. I tried > lo

Re: XYcolor plots

2021-11-13 Thread Jean Bréfort via gnumeric-list
Ah, OK, I see the issue. I'll have a look. Le samedi 13 novembre 2021 à 12:21 -0700, John Denker via gnumeric-list a écrit : > On 11/13/21 11:09 AM, Jean Bréfort wrote: > > > This is because the axis is mapped to 0..5 and not 0..4, set the > > maximum of the axis to 4 and

Re: XYcolor plots

2021-11-13 Thread Jean Bréfort via gnumeric-list
Found the issue, this is actually the wanted behavior, the colors are not associated with 0..4 but with 0, 1, 2, 4, and 6. Le samedi 13 novembre 2021 à 21:13 +0100, Jean Bréfort via gnumeric- list a écrit : > Ah, OK, I see the issue. I'll have a look. > > Le samedi 13 novembre 2021 à 12

Re: XYcolor plots

2021-11-14 Thread Jean Bréfort via gnumeric-list
Le samedi 13 novembre 2021 à 15:10 -0700, John Denker via gnumeric-list a écrit : > On 11/13/21 1:38 PM, Jean Bréfort wrote: > > > Found the issue, this is actually the wanted behavior, the colors are > > not associated with 0..4 but with 0, 1, 2, 4, and 6. > > O

Re: Delete custom color map for matrix chart

2022-04-06 Thread Jean Bréfort via gnumeric-list
Hi, It is an implementation choice. If you don't need a colormap anymore, just delete the appropriate file from ~/.goffice/colormaps/ Best regards, Jean Le mardi 05 avril 2022 à 23:03 +0200, Davide Baldini via gnumeric-list a écrit : > Hello, > > the customization menu for matrix charts

Re: conditional cell formatting

2022-06-15 Thread Jean Bréfort via gnumeric-list
iseven(row()) works fine. Hope this helps, Jean Le mercredi 15 juin 2022 à 09:52 -0400, Geoff Sullivan via gnumeric- list a écrit : > I want to figure out how to add color to alternate rows of a > spreadsheet using conditional formatting. In LibreOffice Calc there > is a way to do this by

Re: Aw: Re: need help in some points to get gnumeric 'long' mature. introspection, GDA support, GNOME-DB support, Psiconv, PDF documentation.

2022-05-02 Thread Jean Bréfort via gnumeric-list
Le lundi 02 mai 2022 à 06:20 +0200, newbie nullzwei via gnumeric-list a écrit : >   > hello Jean,  >   > thanks for your fast response :-)  >   > > > a new field for 'fun with linux': >   > -  > meson.build:254:2: ERROR: Dependency "json-glib-1.0" not

<    1   2   3