[Solved] Amending XLS Spreadsheet

Discuss the spreadsheet application

[Solved] Amending XLS Spreadsheet

Postby neilevans » Wed Dec 05, 2007 3:21 pm

When amending an XL Spreadsheet in OpenOffice some numerals change and save OK - others when saved change to ### - any help with this appreciated
Last edited by Hagar Delest on Mon Jun 09, 2008 5:15 pm, edited 2 times in total.
Reason: tagged the thread as Solved.
neilevans
 
Posts: 2
Joined: Wed Dec 05, 2007 3:16 pm

Re: Amending XL Spreadsheet

Postby h1h » Wed Dec 05, 2007 9:31 pm

### means the column is not wide enough to display the result. Change the column width.
OOo 2.4 (from OOo-site) on Linux
User avatar
h1h
 
Posts: 40
Joined: Wed Nov 28, 2007 8:45 pm

Re: Amending XL Spreadsheet

Postby TerryE » Wed Dec 05, 2007 9:37 pm

Does the number change to the string or is it that the formatted display changes to ###?

If you enter a field and the display width is larger than the width of the field then OOo displays a string of # characters to denote display overflow in the case of a numeric filed and a left truncated version with a little red arrow in the cat of an alphabetic one.

You can remove these by resizine the columns concerned. One trick here is to select a bunch of columns and double click on the top letter button or drag the boundary to resize.
Ubuntu 11.04-x64 + LibreOffice 3 and MS free except the boss's Notebook which runs XP + OOo 3.3.
TerryE
Volunteer
 
Posts: 1402
Joined: Sat Oct 06, 2007 10:13 pm
Location: UK

Re: Amending XL Spreadsheet

Postby neilevans » Thu Dec 06, 2007 1:54 pm

Thanks, both for the prompt response - very helpful
neilevans
 
Posts: 2
Joined: Wed Dec 05, 2007 3:16 pm


Return to Calc

Who is online

Users browsing this forum: Google [Bot], MSN [Bot] and 19 guests