Can we do this with Calc?

avada-it · General User Joined: 17 Nov 2008 Posts: 6

We are using OO and interfacing it with Goldmine. We have a spreadsheet that pulls the data from specific fields, and if the fields are empty it sets an alert to let the user know that information is missing before the print the form
.
I am wondering if there is a way to have Calc check the entire form to make sure all the fields are filled before printing, and not allow a print till they are? Maybe its a pipe dream, but can't hurt to ask!

Villeroy · Posted: Fri May 04, 2012 10:41 am Post subject:

if A1:A999 has as many numbers as rows then calculate something, else return an empty string:
=IF(COUNT($A$1:$A$999)=ROWS($A$1:$A$999) ; something ; "")
_________________
Rest in peace, oooforum.org
Get help on http://forum.openoffice.org