James Knott wrote:
Rick Bilonick wrote:
On Tue, 2008-05-06 at 10:46 -0400, James Knott wrote:
Rick Bilonick wrote:
I have a spreadsheet with numbers like 71.08929399 which when save end
up to be 71.09. I need to save all numbers in the exact precision in
which they are stored. I'm using OOo
On 9 Jul 2008 at 14:29, [EMAIL PROTECTED] wrote:
I have a case where numbers are used in a text format of xx (10
characters), that should be converted to xxx.xxx. (10 characters in
groups of 3, 3 and 4 separated by a dot)
The characters should be text, but using numbers;
mike scott wrote:
On 9 Jul 2008 at 14:29, [EMAIL PROTECTED] wrote:
I have a case where numbers are used in a text format of xx (10
characters), that should be converted to xxx.xxx. (10 characters in
groups of 3, 3 and 4 separated by a dot)
The characters should be
On Tue, 06 May 2008 10:56:40 -0400
Rick Bilonick [EMAIL PROTECTED] wrote:
The number 71.08929399 is what is actually in the .xls spreadsheet
Actually, that is not exactly true. The number in the physical cell is
a binary 64-bit floating point number.
I think James answered your question about
I have a spreadsheet with numbers like 71.08929399 which when save end
up to be 71.09. I need to save all numbers in the exact precision in
which they are stored. I'm using OOo 2.3 (Red Hat). I don't see any
options to force this.
Rick B.
Rick Bilonick wrote:
I have a spreadsheet with numbers like 71.08929399 which when save end
up to be 71.09. I need to save all numbers in the exact precision in
which they are stored. I'm using OOo 2.3 (Red Hat). I don't see any
options to force this.
You can set up to 20 decimal places for a
On Tue, 2008-05-06 at 10:46 -0400, James Knott wrote:
Rick Bilonick wrote:
I have a spreadsheet with numbers like 71.08929399 which when save end
up to be 71.09. I need to save all numbers in the exact precision in
which they are stored. I'm using OOo 2.3 (Red Hat). I don't see any
Rick Bilonick wrote:
On Tue, 2008-05-06 at 10:46 -0400, James Knott wrote:
Rick Bilonick wrote:
I have a spreadsheet with numbers like 71.08929399 which when save end
up to be 71.09. I need to save all numbers in the exact precision in
which they are stored. I'm using OOo 2.3 (Red Hat). I
Rick Bilonick wrote:
On Tue, 2008-05-06 at 10:46 -0400, James Knott wrote:
Rick Bilonick wrote:
I have a spreadsheet with numbers like 71.08929399 which when save end
up to be 71.09. I need to save all numbers in the exact precision in
which they are stored. I'm using OOo 2.3 (Red Hat). I
James Knott wrote:
Rick Bilonick wrote:
On Tue, 2008-05-06 at 10:46 -0400, James Knott wrote:
Rick Bilonick wrote:
I have a spreadsheet with numbers like 71.08929399 which when save end
up to be 71.09. I need to save all numbers in the exact precision in
which they are stored. I'm using OOo
On Tuesday 06 May 2008 15:56:40 Rick Bilonick wrote:
The number 71.08929399 is what is actually in the .xls spreadsheet but
only 2 decimal places display in the cell. When I save the spreadsheet
to a .csv file, only 71.09 is saved. I want to always and automatically
save the full precision to
On Tue, 2008-05-06 at 17:04 +0100, Lisi Reisz wrote:
On Tuesday 06 May 2008 15:56:40 Rick Bilonick wrote:
The number 71.08929399 is what is actually in the .xls spreadsheet but
only 2 decimal places display in the cell. When I save the spreadsheet
to a .csv file, only 71.09 is saved. I
On Tue, 2008-05-06 at 11:16 -0400, James Knott wrote:
Rick Bilonick wrote:
On Tue, 2008-05-06 at 10:46 -0400, James Knott wrote:
Rick Bilonick wrote:
I have a spreadsheet with numbers like 71.08929399 which when save end
up to be 71.09. I need to save all numbers in the exact precision
13 matches
Mail list logo