Formatting output from OWC Spreadsheet

[Henrik Niemann]

Hi All,

I am using OWC 10 Spreadsheet in a project, where users enter data on a web
page containing a spreadsheet. Users are using danish as their local language
and thus numbers are shown as "xxx.xxx.xxx,xx". I would like to be able to
maintain this format when entering data, but be able to format the output of
XMLData and/or HTMLData as "en-US": "xxx,xxx,xxx.xx" or any other locale.

The project is VB.Net and I have tried all kinds of tricks with CultureInfo
and NumberFormat with no luck so far.

Any help, thoughts, suggestions or comments on this issue would be
appreciated.

Best regards,

Henrik Niemann

 

[Alvin Bruney [ASP.NET MVP]]

The project is VB.Net and I have tried all kinds of tricks with

CultureInfo
and NumberFormat with no luck so far.

what have you tried so far?

--
Regards,
Alvin Bruney

[Shameless Author Plug]
The Microsoft Office Web Components Black Book with .NET
available at www.lulu.com/owc
------------------------------------------------------------

 

[Henrik Niemann]

Well, let's see..

I tried setting NumberFormat clientside in the param-tag of the object. I
tried putting XMLData in a hidden field and posting to server-side code,
where I tried setting CultureInfo and languagesettings on current thread. I
also tried setting numberformat on various combinations of active cells,
active sheet and ranges.

XMLData is always returning en-US (or equal) formatting, but HTMLData seems
to always return with the formatting of my local machine / server (which is
danish).

Regards,
Henrik Niemann

The project is VB.Net and I have tried all kinds of tricks with
CultureInfo
and NumberFormat with no luck so far.

what have you tried so far?

--
Regards,
Alvin Bruney

[Shameless Author Plug]
The Microsoft Office Web Components Black Book with .NET
available at www.lulu.com/owc
------------------------------------------------------------

Hi All,

I am using OWC 10 Spreadsheet in a project, where users enter data on a
web
page containing a spreadsheet. Users are using danish as their local
language
and thus numbers are shown as "xxx.xxx.xxx,xx". I would like to be able to
maintain this format when entering data, but be able to format the output
of
XMLData and/or HTMLData as "en-US": "xxx,xxx,xxx.xx" or any other locale.

The project is VB.Net and I have tried all kinds of tricks with
CultureInfo
and NumberFormat with no luck so far.

Any help, thoughts, suggestions or comments on this issue would be
appreciated.

Best regards,

Henrik Niemann