Re: how to shade the background in every other row?

Thanks!  That's something I've wanted to do in gnumeric for a long time-- decades!  I tested it out, works good, but found also that things got messed up when I inserted a row in the Autoformated part.  Then doing the same again on the new (but the same) selected area really messed things up... mad

Re: Freezing top x lines in a table

On 01/03/2018 12:49 PM, Bruno Baumgärtner wrote: Hello I am in train to leave LibreOffice as this Methuselah is aeons to large for me. I need a simple calculation program to follow a few sales figures. I have imported one of these files from Calc and all works well. But I can not freeze the

Re: How to have correct citation of gnumeric

I was referring specifically to the R package. Much the same-- credits and copyrights etc.-- for gnumeric would likewise be found in the files which came in the gnumeric package. On 01/29/2016 07:22 AM, ken wrote: If she's after names of people, that's going to be a few names. Th

Re: How to have correct citation of gnumeric

see. There are a lot of *.html files too in that package. Anyway, maybe she needs to look in the files already installed on her computer. On 01/29/2016 06:26 AM, Tim Schofield wrote: Ken, I think Gabriela is asking how Gnumeric should be credited in the paper they are publishing. Tim On

Re: How to have correct citation of gnumeric

On 01/28/2016 11:33 AM, Gabriela Hoff wrote: Dear Sir or Madam I am using R statisitcal tookit and Gnumeric to perform statistical analysis to a paper and I would like to have the correct citation to gnumeric in this paper. I am using the statistical package of the last gnumeric version availabl

Re: move worksheet to another Workbook problem

Good job, Ryoji! And thanks too. I was wondering if gnumeric had such a function just a few weeks ago. I assumed that it did, but I guess I assumed too much. Well, now you've done it. Hope it becomes part of the standard distribution eventually. On 05/13/2013 11:32 AM RYOJI KODAKARI wrot

gnumeric spreadsheets for US taxes

For years I've been doing my (US) taxes, along with the state and local taxes, using gnumeric. I decided I should share what I've done with others. So grab the package if you want... from: ___ gnumer

Re: gnumeric api

On 03/04/2011 01:18 PM Guy Deleeuw wrote: > Hello > It is possible to call gnumeric functions from an api in C or C++ ? > for create/open/save/convert sheets ? > If yes where can I find examples and witch library I need to link ? > > Regards > Guy Though I've never done it before, I'd start by l

Re: Initiate project: US Federal tax form 1040

at it if you want. Enjoy. -- Find research and analysis on US healthcare, health insurance, and health policy at: <http://healthpolicydaily.blogspot.com/> On 04/12/2010 04:09 PM Jim Tarvid wrote: > I'd like to try out a copy. > > On Mon, Apr 12, 2010 at 11:10 AM, ken

format of 'if' statement

I'm trying to assign the result of an 'if' statement to a cell... put this in the cell: =if(d24>=125000,3650*4d,j30) but it's rejected ("Invalid expression"). So how to do: "IF d24 is greater-than-or-equal-to 125000, THEN multiply 4d by 3650, ELSE use the value in cell j30". tnx _

Initiate project: US Federal tax form 1040

e... not that I know of anyway (but maybe I'm just out of the loop). So where should I put this project? I know of sourceforge, but is there a better place? Thanks, ken -- Find research and analysis on US healthcare, health insurance, and health policy at

Re: where to get gnumeric rpm?

Thanks, Ray and others. Didn't know about Fedora's epel. -- War is a failure of the imagination. --William Blake On 10/05/2009 12:35 PM J.H.M. Dassen (Ray) wrote: > On Fri, Oct 02, 2009 at 23:46:30 -0400, ken wrote: >> Just setting up a new (CentOS) system and

Re: where to get gnumeric rpm?

ast, known reputable sites satisfy security concerns. -- War is a failure of the imagination. --William Blake On 10/03/2009 03:12 AM Emmanuel Pacaud wrote: > Hi, > > On sam., 2009-10-03 at 05:46 +0200, ken wrote: >> Just setting up a new (CentOS) system and can't find gnu

Re: 2 Qs: size of tables & worksheets? graphed output to html?

Leonard, Thanks for the great tips. But what's R? On 10/02/2009 03:23 PM Leonard Mada wrote: > Dear Ken, > > I came across a similar problem a few month ago. > > I always thought that the chances of hitting a rows limit are minimal, > but then one day I got an err

where to get gnumeric rpm?

Just setting up a new (CentOS) system and can't find gnumeric here or anywhere (RPM for CentOS/RH). Has it become a secret weapon or something? -- War is a failure of the imagination. --William Blake ___ gnumeric-list mailing list gnumeric-lis

2 Qs: size of tables & worksheets? graphed output to html?

I have two questions. Both pertain to a systems monitoring project I'm developing for a college I work for. We want to monitor two linux servers. Data (on mem, disk, cpu, etc. usage) will be collected every ten seconds. This will then be graphed to show what's been going on with the systems for

Re: dbf

The standard way to do this is to export the (gnumeric) data to a comma-delimited file (or tab-delimited). Then import this file into whatever db you're using. -- War is a failure of the imagination. --William Blake On 09/24/2009 04:48 AM Agustin Lobo wrote: > Hi! > Is it possible to

specifying a cell by referencing another cell

gurus know the right combination of letters and characters to do this? tia, ken -- "To make an apple pie from scratch, first create the universe." -- Carl Sagan ___ gnumeric-list mailing list gnumeric-list@gnome.org http://mail.gnome.org/mailman/listinfo/gnumeric-list

ternary (?:) operator syntax

What's the syntax for the ternary operator? I tried something as simple as =(D6>3) ? 30 : 40 and many permutations of that and always get an error: "Invalid expression". Thanks. -- "To make an apple pie from scratch, first create the universe." -- Carl Sagan

Re: Add trend line to XY graph

On 09/12/2007 08:19:22 AM, Pedro Lino wrote: > It is quite easy although apparentely undocumented :) (I > couldn't find > it in the Windows help file) > Double click your graph. In the Customize Chart dialog: > select from the > object tree on the top left corner the Series you want to > add the T

Re: interest rates

ealings with one another. It should be immediately clear, at least to McLuhan kin, that, with the ease in which so many snap off, society needs all the help it can get in coming to cordial or even mutually accepting agreements. JN, thanks for

Re: calculate interest for one-time payment on loan

On 02/08/2007 03:59 PM somebody named John Machin wrote: > On 9/02/2007 3:37 AM, ken wrote: >> Hi, people, >> >> This should be a simple thing to do. I'm surprised there's not a >> function for it. Or maybe there is one. I've looked at the FAQ, read &g

calculate interest for one-time payment on loan

above can be hardcoded into a formula or fetched from a cell. I could hardcode everything but DateEnd; that needs to be fetched from a cell. Anyone know a way to do this? tnx much, ken -- "The mark of a moderate man is freedom from his own ideas. Tolerant like the sky all-pervading

Re: spreadsheet file is missing changes

On Fri, 2006-02-24 at 17:18 -0600, David Stanaway wrote: On Fri, 2006-02-24 at 14:57 -0800, Ken Hill wrote: > I closed the screen of the laptop and I went to bed. The battery ran > out of juice, thus, the drive was probably not properly unmounted. > However, I saved the file befor

Re: spreadsheet file is missing changes

On Fri, 2006-02-24 at 16:16 -0700, Andreas J. Guelzow wrote: On Fri, 2006-24-02 at 14:57 -0800, Ken Hill wrote: > I closed the screen of the laptop and I went to bed. The battery ran > out of juice, thus, the drive was probably not properly unmounted. > However, I saved the fi

Re: spreadsheet file is missing changes

On Fri, 2006-02-24 at 10:47 -0700, Andreas J. Guelzow wrote: On Thu, 2006-23-02 at 22:35 -0800, Ken Hill wrote: > I just did a search for files with a name containing ".gsf" and found > nothing. I went ahead and spent a good half day recreating the > spreadsheet - it was

Re: spreadsheet file is missing changes

nd the data was lost. Morten, thank you very much for you assistance with my isssue. -Ken On Thu, 2006-02-23 at 18:57 -0500, Morten Welinder wrote: Also, after doing > the gunzip, the file is now completely empty. I guess it is completely lost. The gunzip command I showed does not change the s

Re: spreadsheet file is missing changes

When I try the gunzip... command I get: "gunzip: stdin: unexpected end of file" I'm using version 1.5.90 (that came with Ubuntu Breezy). Also, after doing the gunzip, the file is now completely empty. I guess it is completely lost. Does gnumeric store a backup of the files somewhere? On Thu

spreadsheet file is missing changes

Last night I updated a spreadsheet (race_cars.gnumeric) and saved it as a gnumeric XML file. Today, when I opened the file my changes/updates were lost and I got an error message "internal error". I added additional sheets the file. Is there a way I can recover this f