From fd4cabdf511f016d9d2a6f0691f0752ae7ce8859 Mon Sep 17 00:00:00 2001 From: Randy Morgan Date: Fri, 16 Dec 2011 18:25:43 +0900 Subject: number format needs to be applied if a format is specified. --- lib/axlsx/stylesheet/styles.rb | 2 ++ 1 file changed, 2 insertions(+) diff --git a/lib/axlsx/stylesheet/styles.rb b/lib/axlsx/stylesheet/styles.rb index 9db0a805..cb858884 100644 --- a/lib/axlsx/stylesheet/styles.rb +++ b/lib/axlsx/stylesheet/styles.rb @@ -222,6 +222,8 @@ module Axlsx applyProtection = (options[:hidden] || options[:locked]) ? 1 : 0 xf = Xf.new(:fillId => fill, :fontId=>fontId, :applyFill=>1, :applyFont=>1, :numFmtId=>numFmtId, :borderId=>borderId, :applyProtection=>applyProtection) + + xf.applyNumberFormat = true if xf.numFmtId > 0 if options[:alignment] xf.alignment = CellAlignment.new(options[:alignment]) -- cgit v1.2.3