On Wed, 2004-22-12 at 14:09 +0000, Nomine Mutato wrote:
On Tue, 21 Dec 2004 20:39:45 -0700 "Andreas J. Guelzow" <aguelzow taliesin ca> wrote:On Wed, 2004-22-12 at 02:54 +0000, Nomine Mutato wrote:Sometimes number on my Gnumeric sheet are substitute with # on print.This means that the cell was too small to contain the number.No! If I add apos (') before number (example: <gmr:Cell>'1</gmr:Cell>), It is print correctly. :-(
That doesn't mean anything. If you add an apostrophe in front of the number, it will be interpreted as a string and printed in exactly the format as entered. Without the apostrophe it is considered a number and is being formatted as a number. A formatted number must fit into the cell. A string may stick into the following (or preceding) cell if that one is empty. try it yourself in a gnumeric spreadsheet: enter 12221 into D1 and '12221 into D2. Then make the column narrower... Andreas -- Andreas J. Guelzow Taliesin Software, Shelties, Pyr Sheps and Shetland Sheep
Attachment:
signature.asc
Description: This is a digitally signed message part