Data types Questions
 

Hi group

I am porting several Excel files to Winforms C# .NET application. but I
having problems with some calc with lost precition.

so How can I find the internal representation in memory of the Excel data
types. i.e , When I put a number (INteger, float,Decimal.....) in cells.

Best Regard
Mario

Data types Questions
 

As I understand it:
all numerical data in an excel worksheet is stored as an IEEE double.
Maximum precision of approxmately 15 digits.

--
Regards,
Tom Ogilvy

"Mario Reiley" wrote in message
...
Hi group

I am porting several Excel files to Winforms C# .NET application. but I
having problems with some calc with lost precition.

so How can I find the internal representation in memory of the Excel data
types. i.e , When I put a number (INteger, float,Decimal.....) in cells.

Best Regard
Mario

Data types Questions
 

OK, let me try understad:

if I put 1 or 0.1 or 11.50 or 234 in one cell , all this number are doble
presicition 64 bit. ?

Thanks for respond me
Mario

"Tom Ogilvy" escribió en el mensaje
...
As I understand it:
all numerical data in an excel worksheet is stored as an IEEE double.
Maximum precision of approxmately 15 digits.

--
Regards,
Tom Ogilvy

"Mario Reiley" wrote in message
...
Hi group

I am porting several Excel files to Winforms C# .NET application. but I
having problems with some calc with lost precition.

so How can I find the internal representation in memory of the Excel
data
types. i.e , When I put a number (INteger, float,Decimal.....) in cells.

Best Regard
Mario

Data types Questions
 

that is my understanding.

--
Regards,
Tom Ogilvy

"Mario Reiley" wrote in message
...
OK, let me try understad:

if I put 1 or 0.1 or 11.50 or 234 in one cell , all this number are doble
presicition 64 bit. ?

Thanks for respond me
Mario

"Tom Ogilvy" escribió en el mensaje
...
As I understand it:
all numerical data in an excel worksheet is stored as an IEEE double.
Maximum precision of approxmately 15 digits.

--
Regards,
Tom Ogilvy

"Mario Reiley" wrote in message
...
Hi group

I am porting several Excel files to Winforms C# .NET application. but
I
having problems with some calc with lost precition.

so How can I find the internal representation in memory of the Excel
data
types. i.e , When I put a number (INteger, float,Decimal.....) in
cells.

Best Regard
Mario