PRODUCTS
Purchase
Support
Tutorials
Corporation
Forum
/
Libraries
/
中文技术支持
Change font size
User Control Panel
View your posts
FAQ
Login
自定义数字格式
Post a reply
为有中文需求的客户提供多渠道中文技术支持.
Sat Aug 13, 2022 10:24 am
excel里设置中文大写数字后 ,自定义里 [DBNum2][$-zh-CN]G/通用格式
sheet.Range["B5"].NumberFormat = "[DBNum2][$-zh-CN]G/通用格式";
然后生成的xlsx这个单元格的格式显示 [DBNum2][$-zh-CN]g/"通""用""格""式"
Login to view the files attached to this post.
wzspr007
Posts:
6
Joined:
Sat Aug 06, 2022 6:09 am
Sat Aug 13, 2022 12:58 pm
如果是不设置格式,直接使用公式
sheet.Range["B5"].Formula = "=IF(-RMB(C5,2),TEXT(C5,\";负\")&TEXT(INT(ABS(C5)+0.5%),\"[dbnum2]G/通用格式元;;\")&TEXT(RIGHT(RMB(C5,2),2),\"[dbnum2]0角0分;;整\"),\"零元整\")";
会提示#NAME?
Login to view the files attached to this post.
wzspr007
Posts:
6
Joined:
Sat Aug 06, 2022 6:09 am
Display topics from previous:
All posts
1 day
7 days
2 weeks
1 month
3 months
6 months
1 year
Sort by
Author
Post time
Subject
Ascending
Descending
Post a reply
Page
1
of
1
Return to 中文技术支持
Jump to:
Select a forum
------------------
Libraries
Spire.PDF
Spire.XLS
Spire.Doc
Spire.Presentation
Spire.BarCode
Spire.Email
Spire.DocViewer
Spire.PDFViewer
Spire.Spreadsheet
Spire.OfficeViewer
Spire.DataExport
Spire.OCR
New Feature Requests
Complaints & Suggestions
中文技术支持