=IF(D24 = 125000, D4 * 3650, J30)
You forgot the second comma, and 4D is invalid - it should be D4.
Uri David
On Wed, Apr 14, 2010 at 2:50 PM, ken geb...@mousecar.com wrote:
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)
Hi.
You guys should ask on the Abiword mailing list. I think they invested
a lot of effort in making the Windows version work with WMF (new and
old versions), and I'm sure they had the WMF code in a separate
library in at least one of the versions.
Yours,
Uri David
On Mon, Aug 24, 2009 at 7:17
How about doing SUMIF, which is also compatible with all other vendors?
SUMIF(Range, criteria, sum column)
For example, in your case, you would do something like
SUMIF(B:B, XyzCo, C:C)
On Sat, Jan 10, 2009 at 4:03 PM, Adam Dingle a...@medovina.org wrote:
In Gnumeric, suppose that I have a
Hi.
When pasting into an entire sheet (which just happened to me, when
pressing Ctrl-A, then Ctrl-C), Gnumeric takes an enormous amount of
memory (without any way to stop or undo the operation).
Is this what I should expect, or is it a bug?
If it is what I should expect, is there any chance of
[EMAIL PROTECTED] wrote:
Hi,
it is probably a general spreadsheet issue as witnessed by the similar
OpenOffice.org behaviour and bug-report:
http://www.openoffice.org/issues/show_bug.cgi?id=59453
Sincerely,
Leonard
Uri David Akavia wrote:
Hi.
When pasting into an entire sheet
reviews.
Hope this helps,
Uri David Akavia
On Feb 8, 2008 7:50 PM, O. A. Rondon [EMAIL PROTECTED] wrote:
Dear gnumeric team,
I have used some older version of gnumeric, and I find it perhaps a
superior application than OpenOffice Calc, etc. But the version I have
used (1.0.5), provided
Hi.
When I copy a column cells from Gnumeric 1.8 to Gedit, the cells are
pasted without any spaces or breaks.
I have to transpose the cells into a row, which is pasted with tabs
between them.
Is this intentional? If it is, can someone explain the logic to me (I
expected cells to be pasted with
large number of rows.
Best,
Jian
-Original Message-
From: Uri David Akavia [mailto:[EMAIL PROTECTED]
Sent: Thursday, October 25, 2007 4:20 PM
To: Wang, Jian
Cc: gnumeric-list@gnome.org
Subject: Re: Need a compiled version of Gnumeric that works with 600,000
rows
Hi.
Why do you
Hi.
Why do you need 600K rows?
Are you sure you need to do this with a spreadsheet, and not with a
database or text processing files (like perl/gawk/grep...)?
Yours,
Uri David
On 10/25/07, Wang, Jian [EMAIL PROTECTED] wrote:
Dear Gnumeric subscribers,
I'd like to ask for your help to
Hello.
First, I'd like to thank all the writers and reviewers of Gnumeric's
Documentation, for creating such an important part of the project.
Second - section 7.2.2.1, figure 8 has the different parts of the
Graph guru shaded, which helps identifying which section is being
referred to.
However,
.
Yours,
Uri David Akavia
On 9/3/07, jackie freeman [EMAIL PROTECTED] wrote:
Hello,
I am a new user of the 1.6.3 version. My experience consists only of using
MSW spreadsheet of which I now use GNUMERIC with great delight. It is
proving challenging to me, but I'm slow steady anyway.
My
If we're opening the floor to wishlist functions, that might be developed
during the next cycle (or not), I want to add my two cents. I generally
support the addition of these functions as well.
I'd like a resolution of the row/column limitations if possible. What I
would like is having a
for most practical purposes, and it is much
simpler (hence, but free) then more complicated code.
Yours,
Uri David Akavia
___
gnumeric-list mailing list
gnumeric-list@gnome.org
http://mail.gnome.org/mailman/listinfo/gnumeric-list
Right, maybe my explanation was unclear. I'll try to repeat (and ask
other people to check my math).
On 2/10/07, Leonard Mada [EMAIL PROTECTED] wrote:
So, even in the worst scenario, this algorithm should work faster than
n* log(n). Also, (n/2 -1)! is worst case, when all residual elements
, the other with 400,000 lines.
Yours,
Uri David Akavia
___
gnumeric-list mailing list
gnumeric-list@gnome.org
http://mail.gnome.org/mailman/listinfo/gnumeric-list
Personally, I like the one with the purple better (the default colors).
Very high contrast, and clear.
Very good job.
Uri David
On 12/13/06, Vinicius Depizzol [EMAIL PROTECTED] wrote:
Following the new Gnome Icon Theme, Tango Desktop Project is
creating[1] a lot of icons for applications that
First - I'm with Dave here - you need 4,294,967,296 rows? Maybe you
can describe your problem in depth, so I'll just figure out why on
Earth you'd need that.
Second, I'm assuming you're using a Linux distribution.
Let's say you're using Debian, or a Debian based system like Ubuntu.
1)Get the
Also, don't forget to change line 1285 in gnumeric-canvas.c
#if SHEET_MAX_COLS 700 /* a guestimate */
#error We need a better solution to the rtl event kludge with
SHEET_MAX_COLS so large
#endif
I just changed the lines in gnumeric.h and had compilation fail on this error.
BTW, has anyone
Sorry, my bad.
Selecting the Format as Text works perfectly, and doesn't change that.
I'm just surprised no one suggested that instead of adding the '.
Thanks for your work.
Yours,
Uri David
On 9/23/06, Uri David Akavia [EMAIL PROTECTED] wrote:
Maybe I misunderstood something. The original
Maybe I misunderstood something. The original post stated that Text
mode stripped the + sign from his data. Did he mean that importing via
the Text imported stripped his data, or did he mean that selecting
Text as the format stripped the + from his data?
I was under the impression it was the
I agree that there ought to be a Completely No interpretation option
somewhere in the Text import dialog.
For example, I'm a biologist which deals with Bioinformatic info.
Some genes have a symbol (or ID) that can be interpreted by Gnumeric,
for example Sep-06. An option to have this strictly be
,
and functions for combining them. Why do you need to give a new
identifier for each cell?
Yours,
Uri David Akavia
On 9/5/06, Wolfgang Keller [EMAIL PROTECTED] wrote:
___
gnumeric-list mailing list
gnumeric-list@gnome.org
http://mail.gnome.org/mailman/listinfo
On 8/17/06, Frederic Parrenin [EMAIL PROTECTED] wrote:
Please think again about the side pane. It would really be convenient to
not have to launch the property window each time you want to modify a
graph. It would also make useless the preview, because you could adopt
an instant apply
a bug request
on this feature. If it isn't, can you explain why please?
One bug:
When trying to add a column, Gnumeric doesn't give any warning that
non-blank cells are about to be pushed off the edge of the sheet. Is
this known, or should I open it in Bugzilla?
Yours,
Uri David Akavia
Thanks.
Some misunderstanding as to the definition of merged.
BTW, the bug is still valid.
Yours,
Uri David
On Thu, 2005-12-29 at 11:28 -0700, Andreas J. Guelzow wrote:
Bug 87296 of course has absolutely nothing to do with that menu item.
That bug refers to merged (combined) cells. To merge
of the coLinux project.
Yours,
Uri David Akavia
___
gnumeric-list mailing list
gnumeric-list@gnome.org
http://mail.gnome.org/mailman/listinfo/gnumeric-list
there, and log back in to Gnome.
If these fail, I'd try reinstalling Gconf, but I don't know how to do
this on RPM based systems.
Yours,
Uri David Akavia
___
gnumeric-list mailing list
gnumeric-list@gnome.org
http://mail.gnome.org/mailman/listinfo
27 matches
Mail list logo