On 17.04.2011 14:44, John P Baker wrote:
In migrating a Microsoft Office 2010 Excel spreadsheet to OpenOffice 3.3.0 Calc, I have noted that
the Accounting and URL cell formats do not appear to be supported.
Are there any plans to incorporate support for these cell formats into a future
Hello Qiyao,
If that happened in A1,put a formula into B1: =A1
Then copy and Menu:EditPasteSpecial... with optionText but without
Formulas.
You can do the same with many cells at once. Pasting the text-values
won't generate hyperlinks.
I think the point he is making is that 0 * anything is zero
If we take a fractional index it becomes root of ie 0^ half is the
square root of 0 = 0. 0^ third is cube root of zero = zero. Since the
nth root of zero is zero, the millionth root of zero is zero, how come
suddenly the infinity
On Tue, 2006-03-21 at 07:46, Jonathon Blake wrote:
Liberty wrote:
Every Calculator, Spreadsheet, Compiler, and Interperter, that I've seen
defines 0^0 as 1.
My Texas Instruments BAII Plus calculator says that 0 * 0 = 0.
MY PDA says 0 * 0 = 0.
My cell phone says 0 * 0 = 0.
Gnumeric
On Tue, 2006-03-21 at 08:30 +0100, Henrik Sundberg wrote:
2006/3/21, Bob Long [EMAIL PROTECTED]:
As the value of 0^0 seems to depend on context to some extent (either 1 or
undefined), perhaps it should be an option in Tools|Options|OpenOffice.org
Calc.|Calculate. Something like a checkbox
Henrik Sundberg wrote:
I think it is strange to be this pedantic about 0^0, and not care
about math at all when it comes to normal cases like this. Are we
looking for compatibility with Microsoft or math?
I am a mathematecian, and not exactly a Microsoft fan. So I'll vote for
math of course
On Tue, 21 Mar 2006 09:16:22 +, Daniel Carrera [EMAIL PROTECTED]
wrote:
I am a mathematecian, and not exactly a Microsoft fan. So I'll vote for
math of course (and I can get very pedantic about this). Though, in the
case of 0^0 math doesn't provide an unambiguous answer because in the
2006/3/21, Daniel Carrera [EMAIL PROTECTED]:
Henrik Sundberg wrote:
I think it is strange to be this pedantic about 0^0, and not care
about math at all when it comes to normal cases like this. Are we
looking for compatibility with Microsoft or math?
this above was referring to -(A1-B1)^2
Liberty wrote:
Every Calculator, Spreadsheet, Compiler, and Interperter, that I've seen
defines 0^0 as 1.
My Texas Instruments BAII Plus calculator says that 0 * 0 = 0.
MY PDA says 0 * 0 = 0.
My cell phone says 0 * 0 = 0.
Gnumeric says 0 * 0 = 0, and gives a page full of error messages.
Excel
On Tue, 21 Mar 2006 09:16:22 +, Daniel Carrera [EMAIL PROTECTED]
wrote:
Henrik Sundberg wrote:
I think it is strange to be this pedantic about 0^0, and not care
about math at all when it comes to normal cases like this. Are we
looking for compatibility with Microsoft or math?
I am a
2006/3/21, Daniel Carrera [EMAIL PROTECTED]:
This is the third time I give this example. Aren't people listening? It
is *NOT* true that x^y approaches 1, it DOESN'T. It only approaches 1 in
a special case i.e. if you approach along the a curve y = f(x) where
f(x) is analytic.
Listening.
* /= ^
/$
2006/3/21, Jonathon Blake [EMAIL PROTECTED]:
Liberty wrote:
Every Calculator, Spreadsheet, Compiler, and Interperter, that I've seen
defines 0^0 as 1.
My Texas Instruments BAII Plus calculator says that 0 * 0 = 0.
MY PDA says 0 * 0 = 0.
My cell phone says 0 * 0 = 0.
Gnumeric
Daniel Carrera wrote:
Liberty wrote:
Every Calculator, Spreadsheet, Compiler, and Interperter, that I've seen
defines 0^0 as 1. If Calc handles it differently than other programs
it could
cause compatabilty issues.
Compatibility is a fair argument. The first calculator I tried (the one
2006/3/21, Rod Engelsman [EMAIL PROTECTED]:
Excel 2000 gives an error.
My bet is that this makes the circle full, considering the mail that
started this thread looked like this:
On 3/18/06, Marco [EMAIL PROTECTED] wrote:
Dear sirs,
we would like to inform you that we have found a bug on the
In news:[EMAIL PROTECTED],
Daniel Carrera [EMAIL PROTECTED] typed:
[..]
So, what should we pick in the context of a spread sheet? I think
that a spread sheet should err on the side of caution and not
magically hide things that are likely to be user error. So I think
that 0^0 should give an
2006/3/21, Bob Long [EMAIL PROTECTED]:
As the value of 0^0 seems to depend on context to some extent (either 1 or
undefined), perhaps it should be an option in Tools|Options|OpenOffice.org
Calc.|Calculate. Something like a checkbox saying Define 0^0=1, else
undefined.
I consider this the
THANK YOU!
It works !
cono [EMAIL PROTECTED] schrieb im Newsbeitrag
news:[EMAIL PROTECTED]
Hello Jens,
Jens Kellermann wrote:
First of all :Sorry for my bad english !
No prob for me.
I need some help with following problem :
If i insert a graphic in a new table and bring it
17 matches
Mail list logo