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