When a cell is using the Accounting format and the workbook is converted to HTML, the cell value will get replaced with # characters even though the value would fit.
@page {mso-header-data: ; mso-footer-data: ; margin: 0.75in 0.7in 0.75in 0.7in; mso-header-margin: 0.3in; mso-footer-margin: 0.3in; mso-page-orientation: Portrait; } TABLE { mso-displayed-decimal-separator: "."; mso-displayed-thousand-separator: "," } TR { mso-height-source: auto; mso-ruby-visibility: none } COL { mso-width-source: auto; mso-ruby-visibility: none } BR { mso-data-placement: same-cell } RUBY { RUBY-ALIGN: left } .style0 { BORDER-TOP-STYLE: none; FONT-SIZE: 10pt; FONT-FAMILY: "Arial","sans-serif"; VERTICAL-ALIGN: middle; WHITE-SPACE: nowrap; BORDER-BOTTOM-STYLE: none; FONT-WEIGHT: 400; COLOR: #000000; FONT-STYLE: normal; BORDER-RIGHT-STYLE: none; BORDER-LEFT-STYLE: none; mso-number-format: General; mso-pattern: auto; mso-protection: locked visible; mso-style-name: Normal; mso-style-id: 0 } .font0 { FONT-SIZE: 10pt; FONT-FAMILY: "Arial","sans-serif"; FONT-WEIGHT: 400; COLOR: #000000; FONT-STYLE: normal } .font1 { FONT-SIZE: 11pt; FONT-FAMILY: "Tahoma","sans-serif"; FONT-WEIGHT: 400; COLOR: #000000; FONT-STYLE: normal } TD { BORDER-TOP-STYLE: none; FONT-SIZE: 10pt; FONT-FAMILY: "Arial","sans-serif"; VERTICAL-ALIGN: middle; WHITE-SPACE: nowrap; BORDER-BOTTOM-STYLE: none; FONT-WEIGHT: 400; COLOR: #000000; FONT-STYLE: normal; BORDER-RIGHT-STYLE: none; BORDER-LEFT-STYLE: none; mso-number-format: General; mso-pattern: auto; mso-protection: locked visible; mso-style-parent: style0; mso-ignore: padding } .style0 { FONT-SIZE: 10pt; FONT-FAMILY: "Arial","sans-serif"; VERTICAL-ALIGN: middle; WHITE-SPACE: nowrap; FONT-WEIGHT: 400; FONT-STYLE: normal; mso-pattern: auto; mso-protection: locked visible; mso-style-name: "Normal" } .style1 { FONT-SIZE: 10pt; FONT-FAMILY: "Arial","sans-serif"; VERTICAL-ALIGN: middle; WHITE-SPACE: nowrap; FONT-WEIGHT: 400; FONT-STYLE: normal; mso-pattern: auto; mso-protection: locked visible } .style2 { FONT-SIZE: 10pt; FONT-FAMILY: "Arial","sans-serif"; VERTICAL-ALIGN: middle; WHITE-SPACE: nowrap; FONT-WEIGHT: 400; FONT-STYLE: normal; mso-pattern: auto; mso-protection: locked visible } .style3 { FONT-SIZE: 10pt; FONT-FAMILY: "Arial","sans-serif"; VERTICAL-ALIGN: middle; WHITE-SPACE: nowrap; FONT-WEIGHT: 400; FONT-STYLE: normal; mso-pattern: auto; mso-protection: locked visible } .style4 { FONT-SIZE: 10pt; FONT-FAMILY: "Arial","sans-serif"; VERTICAL-ALIGN: middle; WHITE-SPACE: nowrap; FONT-WEIGHT: 400; FONT-STYLE: normal; mso-pattern: auto; mso-protection: locked visible } .style5 { FONT-SIZE: 10pt; FONT-FAMILY: "Arial","sans-serif"; VERTICAL-ALIGN: middle; WHITE-SPACE: nowrap; FONT-WEIGHT: 400; FONT-STYLE: normal; mso-pattern: auto; mso-protection: locked visible } .style6 { FONT-SIZE: 10pt; FONT-FAMILY: "Arial","sans-serif"; VERTICAL-ALIGN: middle; WHITE-SPACE: nowrap; FONT-WEIGHT: 400; FONT-STYLE: normal; mso-pattern: auto; mso-protection: locked visible } .style7 { FONT-SIZE: 10pt; FONT-FAMILY: "Arial","sans-serif"; VERTICAL-ALIGN: middle; WHITE-SPACE: nowrap; FONT-WEIGHT: 400; FONT-STYLE: normal; mso-pattern: auto; mso-protection: locked visible } .style8 { FONT-SIZE: 10pt; FONT-FAMILY: "Arial","sans-serif"; VERTICAL-ALIGN: middle; WHITE-SPACE: nowrap; FONT-WEIGHT: 400; FONT-STYLE: normal; mso-pattern: auto; mso-protection: locked visible } .style9 { FONT-SIZE: 10pt; FONT-FAMILY: "Arial","sans-serif"; VERTICAL-ALIGN: middle; WHITE-SPACE: nowrap; FONT-WEIGHT: 400; FONT-STYLE: normal; mso-pattern: auto; mso-protection: locked visible } .style10 { FONT-SIZE: 10pt; FONT-FAMILY: "Arial","sans-serif"; VERTICAL-ALIGN: middle; WHITE-SPACE: nowrap; FONT-WEIGHT: 400; FONT-STYLE: normal; mso-pattern: auto; mso-protection: locked visible } .style11 { FONT-SIZE: 10pt; FONT-FAMILY: "Arial","sans-serif"; VERTICAL-ALIGN: middle; WHITE-SPACE: nowrap; FONT-WEIGHT: 400; FONT-STYLE: normal; mso-pattern: auto; mso-protection: locked visible } .style12 { FONT-SIZE: 10pt; FONT-FAMILY: "Arial","sans-serif"; VERTICAL-ALIGN: middle; WHITE-SPACE: nowrap; FONT-WEIGHT: 400; FONT-STYLE: normal; mso-pattern: auto; mso-protection: locked visible } .style13 { FONT-SIZE: 10pt; FONT-FAMILY: "Arial","sans-serif"; VERTICAL-ALIGN: middle; WHITE-SPACE: nowrap; FONT-WEIGHT: 400; FONT-STYLE: normal; mso-pattern: auto; mso-protection: locked visible } .style14 { FONT-SIZE: 10pt; FONT-FAMILY: "Arial","sans-serif"; VERTICAL-ALIGN: middle; WHITE-SPACE: nowrap; FONT-WEIGHT: 400; FONT-STYLE: normal; mso-pattern: auto; mso-protection: locked visible } .x15 { FONT-SIZE: 10pt; FONT-FAMILY: "Arial","sans-serif"; VERTICAL-ALIGN: middle; WHITE-SPACE: nowrap; FONT-WEIGHT: 400; FONT-STYLE: normal; mso-number-format: General; mso-pattern: auto; mso-protection: locked visible; mso-style-parent: style0 } .style16 { FONT-SIZE: 10pt; FONT-FAMILY: "Arial","sans-serif"; VERTICAL-ALIGN: middle; WHITE-SPACE: nowrap; FONT-WEIGHT: 400; FONT-STYLE: normal; mso-number-format: "0%"; mso-pattern: auto; mso-protection: locked visible; mso-style-name: "Percent" } .style17 { FONT-SIZE: 10pt; FONT-FAMILY: "Arial","sans-serif"; VERTICAL-ALIGN: middle; WHITE-SPACE: nowrap; FONT-WEIGHT: 400; FONT-STYLE: normal; mso-number-format: "_("$"* #,##0.00_);_("$"* (#,##0.00);_("$"* "-"??_);_(@_)"; mso-pattern: auto; mso-protection: locked visible; mso-style-name: "Currency" } .style18 { FONT-SIZE: 10pt; FONT-FAMILY: "Arial","sans-serif"; VERTICAL-ALIGN: middle; WHITE-SPACE: nowrap; FONT-WEIGHT: 400; FONT-STYLE: normal; mso-number-format: "_("$"* #,##0_);_("$"* (#,##0);_("$"* "-"_);_(@_)"; mso-pattern: auto; mso-protection: locked visible; mso-style-name: "Currency [0]" } .style19 { FONT-SIZE: 10pt; FONT-FAMILY: "Arial","sans-serif"; VERTICAL-ALIGN: middle; WHITE-SPACE: nowrap; FONT-WEIGHT: 400; FONT-STYLE: normal; mso-number-format: "_(* #,##0.00_);_(* (#,##0.00);_(* "-"??_);_(@_)"; mso-pattern: auto; mso-protection: locked visible; mso-style-name: "Comma" } .style20 { FONT-SIZE: 10pt; FONT-FAMILY: "Arial","sans-serif"; VERTICAL-ALIGN: middle; WHITE-SPACE: nowrap; FONT-WEIGHT: 400; FONT-STYLE: normal; mso-number-format: "_(* #,##0_);_(* (#,##0);_(* "-"_);_(@_)"; mso-pattern: auto; mso-protection: locked visible; mso-style-name: "Comma [0]" } .x21 { FONT-SIZE: 11pt; FONT-FAMILY: "Tahoma","sans-serif"; VERTICAL-ALIGN: bottom; WHITE-SPACE: nowrap; FONT-WEIGHT: 400; COLOR: #000000; FONT-STYLE: normal; mso-number-format: General; mso-pattern: auto; mso-protection: locked visible; mso-style-parent: style0 } .x22 { FONT-SIZE: 10pt; BORDER-TOP: windowtext 1px solid; FONT-FAMILY: "Arial","sans-serif"; BORDER-RIGHT: windowtext 1px solid; VERTICAL-ALIGN: bottom; BACKGROUND: #d3d3d3; WHITE-SPACE: nowrap; BORDER-BOTTOM: windowtext 1px solid; FONT-WEIGHT: 400; FONT-STYLE: normal; TEXT-ALIGN: center; BORDER-LEFT: windowtext 1px solid; mso-number-format: General; mso-pattern: auto none; mso-protection: locked visible; mso-style-parent: style0; mso-diagonal-down: none; mso-diagonal-up: none } .x23 { FONT-SIZE: 11pt; BORDER-TOP: windowtext 1px solid; FONT-FAMILY: "Tahoma","sans-serif"; BORDER-RIGHT: #d3d3d3 1px solid; VERTICAL-ALIGN: bottom; WHITE-SPACE: nowrap; BORDER-BOTTOM: #d3d3d3 1px solid; FONT-WEIGHT: 400; COLOR: #000000; FONT-STYLE: normal; BORDER-LEFT: windowtext 1px solid; mso-number-format: "_("$"* #,##0.00_);_("$"* \(#,##0.00\);_("$"* "-"??_);_(@_)"; mso-pattern: auto; mso-protection: locked visible; mso-style-parent: style17; mso-diagonal-down: none; mso-diagonal-up: none } .x24 { FONT-SIZE: 11pt; BORDER-TOP: windowtext 1px solid; FONT-FAMILY: "Tahoma","sans-serif"; BORDER-RIGHT: #d3d3d3 1px solid; VERTICAL-ALIGN: bottom; WHITE-SPACE: nowrap; BORDER-BOTTOM: #d3d3d3 1px solid; FONT-WEIGHT: 400; COLOR: #000000; FONT-STYLE: normal; BORDER-LEFT: #d3d3d3 1px solid; mso-number-format: General; mso-pattern: auto; mso-protection: locked visible; mso-style-parent: style0; mso-diagonal-down: none; mso-diagonal-up: none } .x25 { FONT-SIZE: 11pt; BORDER-TOP: windowtext 1px solid; FONT-FAMILY: "Tahoma","sans-serif"; BORDER-RIGHT: #d3d3d3 1px solid; VERTICAL-ALIGN: bottom; WHITE-SPACE: nowrap; BORDER-BOTTOM: #d3d3d3 1px solid; FONT-WEIGHT: 400; COLOR: #000000; FONT-STYLE: normal; BORDER-LEFT: #d3d3d3 1px solid; mso-number-format: "_("$"* #,##0.00_);_("$"* \(#,##0.00\);_("$"* "-"??_);_(@_)"; mso-pattern: auto; mso-protection: locked visible; mso-style-parent: style17; mso-diagonal-down: none; mso-diagonal-up: none }
A | B | C | |
1 | ######### | 500 | ######### |
@page {mso-header-data: ; mso-footer-data: ; margin: 0.75in 0.7in 0.75in 0.7in; mso-header-margin: 0.3in; mso-footer-margin: 0.3in; mso-page-orientation: Portrait; } TABLE { mso-displayed-decimal-separator: "."; mso-displayed-thousand-separator: "," } TR { mso-height-source: auto; mso-ruby-visibility: none } COL { mso-width-source: auto; mso-ruby-visibility: none } BR { mso-data-placement: same-cell } RUBY { RUBY-ALIGN: left } .style0 { BORDER-TOP-STYLE: none; FONT-SIZE: 10pt; FONT-FAMILY: "Arial","sans-serif"; VERTICAL-ALIGN: middle; WHITE-SPACE: nowrap; BORDER-BOTTOM-STYLE: none; FONT-WEIGHT: 400; COLOR: #000000; FONT-STYLE: normal; BORDER-RIGHT-STYLE: none; BORDER-LEFT-STYLE: none; mso-number-format: General; mso-pattern: auto; mso-protection: locked visible; mso-style-name: Normal; mso-style-id: 0 } .font0 { FONT-SIZE: 10pt; FONT-FAMILY: "Arial","sans-serif"; FONT-WEIGHT: 400; COLOR: #000000; FONT-STYLE: normal } .font1 { FONT-SIZE: 11pt; FONT-FAMILY: "Tahoma","sans-serif"; FONT-WEIGHT: 400; COLOR: #000000; FONT-STYLE: normal } TD { BORDER-TOP-STYLE: none; FONT-SIZE: 10pt; FONT-FAMILY: "Arial","sans-serif"; VERTICAL-ALIGN: middle; WHITE-SPACE: nowrap; BORDER-BOTTOM-STYLE: none; FONT-WEIGHT: 400; COLOR: #000000; FONT-STYLE: normal; BORDER-RIGHT-STYLE: none; BORDER-LEFT-STYLE: none; mso-number-format: General; mso-pattern: auto; mso-protection: locked visible; mso-style-parent: style0; mso-ignore: padding } .style0 { FONT-SIZE: 10pt; FONT-FAMILY: "Arial","sans-serif"; VERTICAL-ALIGN: middle; WHITE-SPACE: nowrap; FONT-WEIGHT: 400; FONT-STYLE: normal; mso-pattern: auto; mso-protection: locked visible; mso-style-name: "Normal" } .style1 { FONT-SIZE: 10pt; FONT-FAMILY: "Arial","sans-serif"; VERTICAL-ALIGN: middle; WHITE-SPACE: nowrap; FONT-WEIGHT: 400; FONT-STYLE: normal; mso-pattern: auto; mso-protection: locked visible } .style2 { FONT-SIZE: 10pt; FONT-FAMILY: "Arial","sans-serif"; VERTICAL-ALIGN: middle; WHITE-SPACE: nowrap; FONT-WEIGHT: 400; FONT-STYLE: normal; mso-pattern: auto; mso-protection: locked visible } .style3 { FONT-SIZE: 10pt; FONT-FAMILY: "Arial","sans-serif"; VERTICAL-ALIGN: middle; WHITE-SPACE: nowrap; FONT-WEIGHT: 400; FONT-STYLE: normal; mso-pattern: auto; mso-protection: locked visible } .style4 { FONT-SIZE: 10pt; FONT-FAMILY: "Arial","sans-serif"; VERTICAL-ALIGN: middle; WHITE-SPACE: nowrap; FONT-WEIGHT: 400; FONT-STYLE: normal; mso-pattern: auto; mso-protection: locked visible } .style5 { FONT-SIZE: 10pt; FONT-FAMILY: "Arial","sans-serif"; VERTICAL-ALIGN: middle; WHITE-SPACE: nowrap; FONT-WEIGHT: 400; FONT-STYLE: normal; mso-pattern: auto; mso-protection: locked visible } .style6 { FONT-SIZE: 10pt; FONT-FAMILY: "Arial","sans-serif"; VERTICAL-ALIGN: middle; WHITE-SPACE: nowrap; FONT-WEIGHT: 400; FONT-STYLE: normal; mso-pattern: auto; mso-protection: locked visible } .style7 { FONT-SIZE: 10pt; FONT-FAMILY: "Arial","sans-serif"; VERTICAL-ALIGN: middle; WHITE-SPACE: nowrap; FONT-WEIGHT: 400; FONT-STYLE: normal; mso-pattern: auto; mso-protection: locked visible } .style8 { FONT-SIZE: 10pt; FONT-FAMILY: "Arial","sans-serif"; VERTICAL-ALIGN: middle; WHITE-SPACE: nowrap; FONT-WEIGHT: 400; FONT-STYLE: normal; mso-pattern: auto; mso-protection: locked visible } .style9 { FONT-SIZE: 10pt; FONT-FAMILY: "Arial","sans-serif"; VERTICAL-ALIGN: middle; WHITE-SPACE: nowrap; FONT-WEIGHT: 400; FONT-STYLE: normal; mso-pattern: auto; mso-protection: locked visible } .style10 { FONT-SIZE: 10pt; FONT-FAMILY: "Arial","sans-serif"; VERTICAL-ALIGN: middle; WHITE-SPACE: nowrap; FONT-WEIGHT: 400; FONT-STYLE: normal; mso-pattern: auto; mso-protection: locked visible } .style11 { FONT-SIZE: 10pt; FONT-FAMILY: "Arial","sans-serif"; VERTICAL-ALIGN: middle; WHITE-SPACE: nowrap; FONT-WEIGHT: 400; FONT-STYLE: normal; mso-pattern: auto; mso-protection: locked visible } .style12 { FONT-SIZE: 10pt; FONT-FAMILY: "Arial","sans-serif"; VERTICAL-ALIGN: middle; WHITE-SPACE: nowrap; FONT-WEIGHT: 400; FONT-STYLE: normal; mso-pattern: auto; mso-protection: locked visible } .style13 { FONT-SIZE: 10pt; FONT-FAMILY: "Arial","sans-serif"; VERTICAL-ALIGN: middle; WHITE-SPACE: nowrap; FONT-WEIGHT: 400; FONT-STYLE: normal; mso-pattern: auto; mso-protection: locked visible } .style14 { FONT-SIZE: 10pt; FONT-FAMILY: "Arial","sans-serif"; VERTICAL-ALIGN: middle; WHITE-SPACE: nowrap; FONT-WEIGHT: 400; FONT-STYLE: normal; mso-pattern: auto; mso-protection: locked visible } .x15 { FONT-SIZE: 10pt; FONT-FAMILY: "Arial","sans-serif"; VERTICAL-ALIGN: middle; WHITE-SPACE: nowrap; FONT-WEIGHT: 400; FONT-STYLE: normal; mso-number-format: General; mso-pattern: auto; mso-protection: locked visible; mso-style-parent: style0 } .style16 { FONT-SIZE: 10pt; FONT-FAMILY: "Arial","sans-serif"; VERTICAL-ALIGN: middle; WHITE-SPACE: nowrap; FONT-WEIGHT: 400; FONT-STYLE: normal; mso-number-format: "0%"; mso-pattern: auto; mso-protection: locked visible; mso-style-name: "Percent" } .style17 { FONT-SIZE: 10pt; FONT-FAMILY: "Arial","sans-serif"; VERTICAL-ALIGN: middle; WHITE-SPACE: nowrap; FONT-WEIGHT: 400; FONT-STYLE: normal; mso-number-format: "_("$"* #,##0.00_);_("$"* (#,##0.00);_("$"* "-"??_);_(@_)"; mso-pattern: auto; mso-protection: locked visible; mso-style-name: "Currency" } .style18 { FONT-SIZE: 10pt; FONT-FAMILY: "Arial","sans-serif"; VERTICAL-ALIGN: middle; WHITE-SPACE: nowrap; FONT-WEIGHT: 400; FONT-STYLE: normal; mso-number-format: "_("$"* #,##0_);_("$"* (#,##0);_("$"* "-"_);_(@_)"; mso-pattern: auto; mso-protection: locked visible; mso-style-name: "Currency [0]" } .style19 { FONT-SIZE: 10pt; FONT-FAMILY: "Arial","sans-serif"; VERTICAL-ALIGN: middle; WHITE-SPACE: nowrap; FONT-WEIGHT: 400; FONT-STYLE: normal; mso-number-format: "_(* #,##0.00_);_(* (#,##0.00);_(* "-"??_);_(@_)"; mso-pattern: auto; mso-protection: locked visible; mso-style-name: "Comma" } .style20 { FONT-SIZE: 10pt; FONT-FAMILY: "Arial","sans-serif"; VERTICAL-ALIGN: middle; WHITE-SPACE: nowrap; FONT-WEIGHT: 400; FONT-STYLE: normal; mso-number-format: "_(* #,##0_);_(* (#,##0);_(* "-"_);_(@_)"; mso-pattern: auto; mso-protection: locked visible; mso-style-name: "Comma [0]" } .x21 { FONT-SIZE: 11pt; FONT-FAMILY: "Tahoma","sans-serif"; VERTICAL-ALIGN: bottom; WHITE-SPACE: nowrap; FONT-WEIGHT: 400; COLOR: #000000; FONT-STYLE: normal; mso-number-format: General; mso-pattern: auto; mso-protection: locked visible; mso-style-parent: style0 } .x22 { FONT-SIZE: 10pt; BORDER-TOP: windowtext 1px solid; FONT-FAMILY: "Arial","sans-serif"; BORDER-RIGHT: windowtext 1px solid; VERTICAL-ALIGN: bottom; BACKGROUND: #d3d3d3; WHITE-SPACE: nowrap; BORDER-BOTTOM: windowtext 1px solid; FONT-WEIGHT: 400; FONT-STYLE: normal; TEXT-ALIGN: center; BORDER-LEFT: windowtext 1px solid; mso-number-format: General; mso-pattern: auto none; mso-protection: locked visible; mso-style-parent: style0; mso-diagonal-down: none; mso-diagonal-up: none } .x23 { FONT-SIZE: 11pt; BORDER-TOP: windowtext 1px solid; FONT-FAMILY: "Tahoma","sans-serif"; BORDER-RIGHT: #d3d3d3 1px solid; VERTICAL-ALIGN: bottom; WHITE-SPACE: nowrap; BORDER-BOTTOM: #d3d3d3 1px solid; FONT-WEIGHT: 400; COLOR: #000000; FONT-STYLE: normal; BORDER-LEFT: windowtext 1px solid; mso-number-format: "_("$"* #,##0.00_);_("$"* \(#,##0.00\);_("$"* "-"??_);_(@_)"; mso-pattern: auto; mso-protection: locked visible; mso-style-parent: style17; mso-diagonal-down: none; mso-diagonal-up: none } .x24 { FONT-SIZE: 11pt; BORDER-TOP: windowtext 1px solid; FONT-FAMILY: "Tahoma","sans-serif"; BORDER-RIGHT: #d3d3d3 1px solid; VERTICAL-ALIGN: bottom; WHITE-SPACE: nowrap; BORDER-BOTTOM: #d3d3d3 1px solid; FONT-WEIGHT: 400; COLOR: #000000; FONT-STYLE: normal; BORDER-LEFT: #d3d3d3 1px solid; mso-number-format: General; mso-pattern: auto; mso-protection: locked visible; mso-style-parent: style0; mso-diagonal-down: none; mso-diagonal-up: none } .x25 { FONT-SIZE: 11pt; BORDER-TOP: windowtext 1px solid; FONT-FAMILY: "Tahoma","sans-serif"; BORDER-RIGHT: #d3d3d3 1px solid; VERTICAL-ALIGN: bottom; WHITE-SPACE: nowrap; BORDER-BOTTOM: #d3d3d3 1px solid; FONT-WEIGHT: 400; COLOR: #000000; FONT-STYLE: normal; BORDER-LEFT: #d3d3d3 1px solid; mso-number-format: "_("$"* #,##0.00_);_("$"* \(#,##0.00\);_("$"* "-"??_);_(@_)"; mso-pattern: auto; mso-protection: locked visible; mso-style-parent: style17; mso-diagonal-down: none; mso-diagonal-up: none }
A | B | C | |
1 | $ 800.00 | 500 | ######### |
wbCopy.Save(outputStream, new HtmlSaveOptions(SaveFormat.Html) { ExportActiveWorksheetOnly = true, ExportImagesAsBase64 = true, });