Return-Path: X-Original-To: apmail-openoffice-users-archive@www.apache.org Delivered-To: apmail-openoffice-users-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id 5B01E1084E for ; Sun, 6 Apr 2014 07:09:39 +0000 (UTC) Received: (qmail 13037 invoked by uid 500); 6 Apr 2014 07:09:38 -0000 Delivered-To: apmail-openoffice-users-archive@openoffice.apache.org Received: (qmail 13001 invoked by uid 500); 6 Apr 2014 07:09:37 -0000 Mailing-List: contact users-help@openoffice.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: users@openoffice.apache.org Delivered-To: mailing list users@openoffice.apache.org Delivered-To: moderator for users@openoffice.apache.org Received: (qmail 11790 invoked by uid 99); 6 Apr 2014 07:06:00 -0000 X-ASF-Spam-Status: No, hits=2.2 required=5.0 tests=HTML_MESSAGE,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (nike.apache.org: local policy) From: tony perkins Content-Type: multipart/alternative; boundary="Apple-Mail=_B130A025-3FC5-4276-BDF2-8D28816290B6" Message-Id: <1C45DA0B-837B-4118-A8D9-8E887CCEF82A@lynandtony.com> Mime-Version: 1.0 (Mac OS X Mail 6.6 \(1510\)) Subject: Re: ### Date: Sun, 6 Apr 2014 17:05:28 +1000 References: <8ED21C09-E0ED-4643-9EB4-C7AFF454B5C6@lynandtony.com> <5340FC90.8070903@tasit.net> To: users@openoffice.apache.org In-Reply-To: <5340FC90.8070903@tasit.net> X-Mailer: Apple Mail (2.1510) X-Authenticated-User: 981636 tony@lynandtony.com X-MT-ID: 410E9C06152B792670CC33D7EC0B5596F4F4592A X-Virus-Checked: Checked by ClamAV on apache.org --Apple-Mail=_B130A025-3FC5-4276-BDF2-8D28816290B6 Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset=us-ascii Thanks so much for the speedy reply - much appreciated! On 06/04/2014, at 5:04 PM, Dave Barton wrote: > -------- Original Message -------- > From: Lyn Balzer > To: users@openoffice.apache.org > Date: Sun, 6 Apr 2014 15:15:08 +1000 >=20 >> Hi - I am getting ### as the SUM total in a column - can you tell me = what this means please ?=20 >> thank you=20 >>=20 >> Lyn Balzer & Tony Perkins=20 >=20 > It means that the cell is not wide enough to display the result. Right = click on the column header containing the cell and select "Optimal = Column Width..." from the context (pop-up) menu that appears. >=20 > Regards > Dave >=20 --Apple-Mail=_B130A025-3FC5-4276-BDF2-8D28816290B6--