summaryrefslogtreecommitdiffhomepage
path: root/lib/axlsx/workbook/worksheet/worksheet.rb
diff options
context:
space:
mode:
Diffstat (limited to 'lib/axlsx/workbook/worksheet/worksheet.rb')
-rw-r--r--lib/axlsx/workbook/worksheet/worksheet.rb7
1 files changed, 5 insertions, 2 deletions
diff --git a/lib/axlsx/workbook/worksheet/worksheet.rb b/lib/axlsx/workbook/worksheet/worksheet.rb
index 8cbf876f..9a08a345 100644
--- a/lib/axlsx/workbook/worksheet/worksheet.rb
+++ b/lib/axlsx/workbook/worksheet/worksheet.rb
@@ -199,12 +199,15 @@ module Axlsx
# @return [String]
def to_xml
builder = Nokogiri::XML::Builder.new(:encoding => ENCODING) do |xml|
- xml.worksheet(:xmlns => XML_NS, :'xmlns:r' => XML_NS_R) {
+ xml.worksheet(:xmlns => XML_NS,
+ :'xmlns:r' => XML_NS_R,
+ :'xmlns:mc' => XML_NS_MC,
+ :'xmlns:x14ac' => XML_NS_X14AC) {
if @auto_fit_data.size > 0
xml.cols {
@auto_fit_data.each_with_index do |col, index|
min_max = index+1
- xml.col(:min=>min_max, :max=>min_max, :width => auto_width(col), :customWidth=>"true")
+ xml.col(:min=>min_max, :max=>min_max, :width => ("%.2f" % auto_width(col)), :customWidth=>"true")
end
}
end