StarOffice: Supressing error messages in cells

Bill Campbell linux-sxs
Mon May 17 12:01:03 PDT 2004


On Sat, Apr 03, 2004, Tim Wunder wrote:
...
>That's fin if you want to suppress for the values of i44=<blank> or 0, but if 
>i44=null, then that won't work. 
>Try using =iserr, or =iserror:
>=if(iserr(i44/c44);"";i44/c44) or
>=if(iserror(i44/c44);"";i44/c44)

While we're on the subject of StarOffice/OpenOffice.org, can anybody
recommend good documentation or tutorials, particularly those that might
describe integration of data sources?  I have JDBC working between
OpenOffice.org, mysql, and postgresql, but am not good at figuring out what
to do with data sources after they're defined.

I've never been a Microsoft Office user, or any of the other modern office
suites (the last word processor I really used was Scripsit :-).

Bill
--
INTERNET:   bill at Celestial.COM  Bill Campbell; Celestial Systems, Inc.
UUCP:               camco!bill  PO Box 820; 6641 E. Mercer Way
FAX:            (206) 232-9186  Mercer Island, WA 98040-0820; (206) 236-1676
URL: http://www.celestial.com/

Just because you do not take an interest in politics doesn't mean politics
won't take an interest in you. -- Pericles



More information about the Linux-users mailing list