On Tue, Jul 24, 2007 at 09:59:35 +0800, Dan Jacobson wrote:
> In e.g., http://sowf.moi.gov.tw/stat/year/y06-08.xls
> many simple numbers show up as ######, and one has to click on them to
> see their value in a toolbar message.
This is documented behaviour; see
http://www.gnome.org/projects/gnumeric/doc/quick-data-input.shtml#quick-data-input-input
and
http://www.gnome.org/projects/gnumeric/doc/sect-data-types.shtml
> Also one sees (gnumeric:10353): gnumeric:read-WARNING **: extended
> string support unimplemented:ignoring 16 bytes.
Please report unrelated issues separately. Given that Gnumeric attempts to
handle Excel files as faithfully as possible, it is likely that there is
insufficient file format documentation available to implement import of
these strings.
> Also one cannot find out how to get rid of the million columns to the
> right and bottom, as clicking on help does nothing, even though
> gnumeric-doc is installed.
With the current Gnumeric packages, when gnumeric-doc is installed using a
packaging frontend that honours the "Recommends:" relationship (i.e., the
"yelp" package is installed as well), the manual should be displayed. If
that is not the case for you, please file a separate report on this.
> Also although there are a million extra columns, the columns with content
> are squeezed, and one cannot figure out how to let them expand to their
> natural size.
On Mon, Dec 03, 2007 at 15:14:24 -0800, john howard wrote:
> ### marks show up in cells when the column size is too small for the cell
> content. As column sizes are not dynamic (ie the column widths stay fixed
> according to user preferences) these marks will show up when calculations
> result in long numbers being shown in narrow columns.
I believe this part to be covered already by the two documentation sections
referred above.
> To remove the ### marks in the cells of a spreadsheet click once on the
> 'ALL' row/column header (ie the unmarked box above row 1 and to the left
> of column A) and then double click on any column divider (the control that
> is used for adjusting the width of a cell). All columns should now be
> adjusted to their minimum widths for any content in their cells.
This has not been documented explicitly AFAIK; I'll see what I can do about
that. Thanks for the pointer.
Kind regards,
Ray
--
"My golden rule of computing is reboot your system every morning."
Jon C.A. DeKeles, Technical Director, ZDNet AnchorDesk
in http://www.zdnet.com/anchordesk/story/story_4100.html
--
To UNSUBSCRIBE, email to [EMAIL PROTECTED]
with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]
