Re: numer substitute with # on print

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

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 J. Guelzow
Taliesin Software, Shelties, Pyr Sheps
and Shetland Sheep

Attachment: signature.asc
Description: This is a digitally signed message part

[Date Prev][Date Next]   [Thread Prev][Thread Next]   [Thread Index] [Date Index] [Author Index]