diff options
| author | Jurriaan Pruis <[email protected]> | 2014-04-04 11:39:25 +0200 |
|---|---|---|
| committer | Jurriaan Pruis <[email protected]> | 2014-04-04 11:39:25 +0200 |
| commit | 5ccab460b65f597398f1d8a1b2a5a83039b80a9e (patch) | |
| tree | 6fa3a9e38f81e6f59693acf8861b12938d0030bf /lib/axlsx/workbook/worksheet/data_validation.rb | |
| parent | c649ee7d5ac699d0fc5a36550f502216f9b7318f (diff) | |
| download | caxlsx-5ccab460b65f597398f1d8a1b2a5a83039b80a9e.tar.gz caxlsx-5ccab460b65f597398f1d8a1b2a5a83039b80a9e.zip | |
Fix boolean values so the output matches Excel and works on Numbers
Use 1 or 0 instead of 'true' or 'false' in the XML output
Diffstat (limited to 'lib/axlsx/workbook/worksheet/data_validation.rb')
| -rw-r--r-- | lib/axlsx/workbook/worksheet/data_validation.rb | 4 |
1 files changed, 3 insertions, 1 deletions
diff --git a/lib/axlsx/workbook/worksheet/data_validation.rb b/lib/axlsx/workbook/worksheet/data_validation.rb index 67aef4e5..ab018695 100644 --- a/lib/axlsx/workbook/worksheet/data_validation.rb +++ b/lib/axlsx/workbook/worksheet/data_validation.rb @@ -216,7 +216,9 @@ module Axlsx valid_attributes = get_valid_attributes str << '<dataValidation ' - str << instance_values.map { |key, value| '' << key << '="' << value.to_s << '"' if (valid_attributes.include?(key.to_sym) and not CHILD_ELEMENTS.include?(key.to_sym)) }.join(' ') + str << instance_values.map do |key, value| + '' << key << '="' << Axlsx.booleanize(value).to_s << '"' if (valid_attributes.include?(key.to_sym) && !CHILD_ELEMENTS.include?(key.to_sym)) + end.join(' ') str << '>' str << ('<formula1>' << self.formula1 << '</formula1>') if @formula1 and valid_attributes.include?(:formula1) str << ('<formula2>' << self.formula2 << '</formula2>') if @formula2 and valid_attributes.include?(:formula2) |