From: Lars Christensen <larsch@...>
Date: 2009-02-12T17:38:49+09:00
Subject: Re: Float in Spreadsheet

On Feb 12, 9:26 am, Jim Burgess <igsnh...@rub.de> wrote:
> The program still writes 34 (without the decimal) to the cell.

Excel treats 34 and 34.00 as the same number (and Ruby treat 34.0 and
34.00 the same).

fmt = Spreadsheet::Format.new(:number_format => '0.00')
sheet1.row(1).set_format(1,fmt)