spec/lib/roo/excelx/format_spec.rb in roo-1.11.1 vs spec/lib/roo/excelx/format_spec.rb in roo-1.11.2
- old
+ new
@@ -19,24 +19,26 @@
'mmm-yy' => :date,
'h:mm AM/PM' => :date,
'h:mm:ss AM/PM' => :date,
'h:mm' => :time,
'h:mm:ss' => :time,
- 'm/d/yy h:mm' => :date,
+ 'm/d/yy h:mm' => :datetime,
'#,##0 ;(#,##0)' => :float,
'#,##0 ;[Red](#,##0)' => :float,
'#,##0.00;(#,##0.00)' => :float,
'#,##0.00;[Red](#,##0.00)' => :float,
+ '#,##0_);[Red](#,##0)' => :float,
'mm:ss' => :time,
'[h]:mm:ss' => :time,
'mmss.0' => :time,
'##0.0E+0' => :float,
'@' => :float,
#-- zusaetzliche Formate, die nicht standardmaessig definiert sind:
"yyyy\\-mm\\-dd" => :date,
'dd/mm/yy' => :date,
'hh:mm:ss' => :time,
"dd/mm/yy\\ hh:mm" => :datetime,
+ 'dd/mmm/yy\\ hh:mm' => :datetime,
'dd/mmm/yy' => :date, # 2011-05-21
'yyyy-mm-dd' => :date, # 2011-09-16
'yyyy-mm-dd;@' => :date
}.each do |format, type|
it "translates #{format} to #{type}" do