Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
HomeAnnouncementsFree MagazinesWhite PapersSubmit Content
Discussion GroupsASP.NETWindows FormsLanguages.NET FrameworkVisual Studio.NET
Articles.NET FrameworkASP.NETToolsWindows Forms
.NET DirectoryOpen Source ProjectsUser GroupsWeb Resources
Related Topics
Visual Basic 6SQL ServerMS AccessOther DB ProductsMS Server ProductsMore Topics ...

.NET Forum / .NET Framework / Interop / September 2006

Tip: Looking for answers? Try searching our database.

excel NumberFormat AND localization

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
swayze - 31 Aug 2006 14:10 GMT
Hi All,

I wrote an app (c# 1.1 framework) that formats excel files generated
from html.

I am using numberFormat ("#,##0.00") on certain columns that display
pricing. i am in Turkey but, I use XP pro with regional settings set to
Canada. The computers that display these worksheets have localization
set to  ("tr"). So prices dont display as "10,258.98" like on my pc,
they display as "10,258,98" with a comma instead of a dot. the rest of
our systems use american currency systems (with the dot)

I read somewhere that i can save localization "inside" individual
worksheets or workbooks as to override so-to-speak the computer
settings, but ive googled and cant find anything.

Does anyone have any ideas?

Thanks in advance for ANY insight

Regards

Swayze
Cindy M. - 04 Sep 2006 14:52 GMT
Hi Swayze,

> I wrote an app (c# 1.1 framework) that formats excel files generated
> from html.
[quoted text clipped - 9 lines]
> worksheets or workbooks as to override so-to-speak the computer
> settings, but ive googled and cant find anything.

Since you haven't received a response here, you might try in the
excel.programming newsgroup. They've a generally tendency to be allergic
towards anything .NET, especially C#, but there are a couple of people
there with a strong localization background; look especially for Stephen
Bullen. State the localization problem first, then add you're automating
through a .NET interface at the end, so that their heads first start
working on the actual problem...

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 17 2005)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question or
reply in the newsgroup and not by e-mail :-)
swayze - 04 Sep 2006 16:07 GMT
Hi Cindy,

Thanks for the heads up.

Swayze

> Hi Swayze,
>
[quoted text clipped - 27 lines]
> This reply is posted in the Newsgroup; please post any follow question or
> reply in the newsgroup and not by e-mail :-)

Free Magazines

Get these publications absolutely FREE for up to 12 months. There are no hidden fees and no obligation. Simply choose a title, complete the application form and submit it. Read more ...

Oracle MagazineNetwork ComputingComputer WorldBio-IT WorldeWeekInformation WeekInfosecurity
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.