From: Hannes Wyss Date: 2009-02-12T17:47:01+09:00 Subject: Re: Float in Spreadsheet Jim, Victor, On Thu, Feb 12, 2009 at 9:39 AM, Victor H. Goff III wrote: > This looks like a formatting problem. I don't have an answer for you, but > if the format for that cell has no trailing zeros, then this would be the > affect you are seeing. That's exactly right. Add a Format: fmt = Spreadsheet::Format.new :number_format => '0.0' row = @invoice.row(32+i) row.push '',i, groups[i-1],'',groups_ue[i-1], 34.00, tot row.set_format 5, fmt (There is also a Column Default-Format, but that seems not to work atm - will fix asap.) hth Hannes