Re: OpenDocument Spreadsheet support on Gnumeric INdT collaboration

2005-06-22 Thread Morten Welinder
I've read Morten's blog entry on which he comments about the OASIS OpenDocument standard, and appreciated it very much from start to end. Thanks. (That would be http://blogs.gnome.org/view/mortenw/2005/06/16/0 for reference.) Unfortunately, as it happens with the AbiWord filter, we

coupnum bug

2005-06-22 Thread Ivan Garcia
First of all I should say that im using that latest windows release candidate (1.5.2 RC1). I found a bug with the coupnum function. Its specifications say that it can take a frequency number of 1,2,4,6, or 12 but in practice I found that (like excel) it only works with values 4 or lower. With

Re: Conditional formatting

2005-06-22 Thread Richard Bumby
Chris Potter wrote: I've read a few of the discussions on conditional formatting, but I haven't seen one possible route to solving this puzzle mentioned. If cells can contain RTF, why not just make it possible to insert formatting codes (eg \b{} \i{}) into an RTF cell? That is, if you want a

Re: Conditional formatting

2005-06-22 Thread Jody Goldberg
On Wed, Jun 22, 2005 at 10:02:46AM -0700, Chris Potter wrote: I've read a few of the discussions on conditional formatting, but I haven't seen one possible route to solving this puzzle mentioned. I have a partial implementation of conditional formatting in my tree that will land for 1.5.3.

Re: Conditional formatting

2005-06-22 Thread Jody Goldberg
On Wed, Jun 22, 2005 at 11:44:29AM -0700, Hal Eisen wrote: Chris, I don't think the Conditional Formatting is blocked by the *technical* side of the solution. What is lacking is a good description of the GUI and how the user should interact with the software. To that end, I've been

Re: Conditional formatting

2005-06-22 Thread Jody Goldberg
On Wed, Jun 22, 2005 at 11:53:30AM -0700, Chris Potter wrote: Hal, I understand. It's just that I'm trying to port a project into gnumeric, but it's heavily dependent on conditional formatting, so that's not possible at present. That's the way the cookie crumbles, I guess. You've got

Re: Conditional formatting

2005-06-22 Thread Jody Goldberg
On Wed, Jun 22, 2005 at 03:18:44PM -0400, Richard Bumby wrote: I recently needed a very simple form of this, but found no mention of a way to implement it. I want a single cell, whose height I will adjust, to contain several lines of text. That is, I want the content of the cell to be a

Date arithmetic

2005-06-22 Thread Dave Feustel
How is date arithmetic done in Gnumeric? I want to put a date in a cell and have 6 incremental dates generated in successive cells in the row. So I need a function that adds 1 to the date in the cell immediately to the left. I didn't see any obvious way to do this looking at the gnumeric

Re: Date arithmetic

2005-06-22 Thread Morten Welinder
In A1, enter 2005-06-21 In A2, enter =A1+1 Dates are just numbers formatted to look like dates. Morten ___ gnumeric-list mailing list gnumeric-list@gnome.org http://mail.gnome.org/mailman/listinfo/gnumeric-list

Re: Date arithmetic

2005-06-22 Thread Richard Bumby
Dave Feustel wrote: How is date arithmetic done in Gnumeric? I want to put a date in a cell and have 6 incremental dates generated in successive cells in the row. So I need a function that adds 1 to the date in the cell immediately to the left. I didn't see any obvious way to do this looking

Re: Conditional formatting

2005-06-22 Thread Hal Eisen
On Wed, 2005-06-22 at 15:32 -0400, Jody Goldberg wrote: On Wed, Jun 22, 2005 at 11:44:29AM -0700, Hal Eisen wrote: Chris, I don't think the Conditional Formatting is blocked by the *technical* side of the solution. What is lacking is a good description of the GUI and how the user

Re: Date arithmetic

2005-06-22 Thread Dave Feustel
On Wednesday 22 June 2005 03:48 pm, Morten Welinder wrote: In A1, enter 2005-06-21 In A2, enter =A1+1 Dates are just numbers formatted to look like dates. Morten This works on sheet 1 and fails on sheet 2 in cells with formatting identical to sheet 1. On sheet 2 I get I get ###. On sheet

Re: Multi-line Headers

2005-06-22 Thread Dave Feustel
On Wednesday 22 June 2005 03:56 pm, Morten Welinder wrote: There seems to be no reasonable way to doing that, but at least there is an unreasonable way: Enter the text in a cell, using Alt-Enter to seperate lines. Select the whole text in the edit line, and select Copy. The paste it into

Re: Date arithmetic

2005-06-22 Thread Dave Feustel
On Wednesday 22 June 2005 04:29 pm, Uri David Akavia wrote: Dave Feustel wrote: How is date arithmetic done in Gnumeric? I want to put a date in a cell and have 6 incremental dates generated in successive cells in the row. So I need a function that adds 1 to the date in the cell

Re: Date arithmetic

2005-06-22 Thread Dave Feustel
On Wednesday 22 June 2005 03:57 pm, Richard Bumby wrote: This has been around and documented since at least version 1.0.8.  Consult the manual for details on entering data in many cells simultaneously or autofilling. I have found so far my experience with Excel stands me in good stead wrt

Re: Date arithmetic

2005-06-22 Thread Morten Welinder
This works on sheet 1 and fails on sheet 2 in cells with formatting identical to sheet 1. On sheet 2 I get I get ###. On sheet 1 the value runs over the next cell which is blank. I can get the value to display properly in sheet 2 by reducing the font size to 4, but it's hard to read :-)

Re: Date arithmetic

2005-06-22 Thread Jody Goldberg
On Wed, Jun 22, 2005 at 05:43:16PM -0500, Dave Feustel wrote: On Wednesday 22 June 2005 03:57 pm, Richard Bumby wrote: This has been around and documented since at least version 1.0.8.  Consult the manual for details on entering data in many cells simultaneously or autofilling. On my

Re: Date arithmetic

2005-06-22 Thread Dave Feustel
On Wednesday 22 June 2005 07:01 pm, Jody Goldberg wrote: On Wed, Jun 22, 2005 at 05:41:27PM -0500, Dave Feustel wrote: On Wednesday 22 June 2005 03:57 pm, Richard Bumby wrote: This has been around and documented since at least version 1.0.8.  Consult the manual for details on entering

Re: Date arithmetic

2005-06-22 Thread Dave Feustel
On Wednesday 22 June 2005 07:02 pm, Jody Goldberg wrote: On Wed, Jun 22, 2005 at 05:43:16PM -0500, Dave Feustel wrote: On Wednesday 22 June 2005 03:57 pm, Richard Bumby wrote: This has been around and documented since at least version 1.0.8.  Consult the manual for details on entering

Re: Date arithmetic

2005-06-22 Thread Jody Goldberg
On Wed, Jun 22, 2005 at 08:25:19PM -0500, Dave Feustel wrote: On Wednesday 22 June 2005 07:01 pm, Jody Goldberg wrote: On Wed, Jun 22, 2005 at 05:41:27PM -0500, Dave Feustel wrote: On Wednesday 22 June 2005 03:57 pm, Richard Bumby wrote: This has been around and documented since at least

Re: Date arithmetic

2005-06-22 Thread Jody Goldberg
On Wed, Jun 22, 2005 at 08:30:21PM -0500, Dave Feustel wrote: Sounds like another bug in the BSD package. I have worked my way through my printing problems What was the solution ? and am now looking forward to upgrading to OpenBSD 3.7 which will have a newer version of Gnumeric. I am

Re: Date arithmetic

2005-06-22 Thread Dave Feustel
On Wednesday 22 June 2005 08:41 pm, Jody Goldberg wrote: On Wed, Jun 22, 2005 at 08:30:21PM -0500, Dave Feustel wrote: Sounds like another bug in the BSD package. I have worked my way through my printing problems What was the solution ? Adding Headers and Footers, then getting them

Re: Date arithmetic

2005-06-22 Thread Jody Goldberg
On Wed, Jun 22, 2005 at 09:01:48PM -0500, Dave Feustel wrote: On Wednesday 22 June 2005 08:41 pm, Jody Goldberg wrote: On Wed, Jun 22, 2005 at 08:30:21PM -0500, Dave Feustel wrote: Sounds like another bug in the BSD package. I have worked my way through my printing problems

should pie plot labels appear ?

2005-06-22 Thread Sven Crouse
Hello everybody. I'm unable to get any labels on a pie plot. I've tried both the graph guru and manually typing {a,b,c} in the labels field of a pie plot unsuccesfully. The Gnumeric Manual shows images of pie plots with labels and I see nothing about this release having issues with pie plot