My biggest wish would be for type checking. E.g. if a cell seems to hold a currency value, and one a date, than <currency> + <date> is an error.
So, the idea is to verify that types are used in proper calculations. Some options may specify the stringency of the validation, e.g.: - allow or disallow <currency> + scalar This is more for the financial system, but it would be of huge benefit in that case. Sincerely, Leonard -------- Original-Nachricht -------- > Datum: Fri, 04 Jun 2010 11:47:12 +0200 > Von: Niklas Nebel <niklas.ne...@sun.com> > An: dev@sc.openoffice.org > Betreff: Re: [sc-dev] Validator for Calc > On 06/04/10 10:59, Kálmán „KAMI” Szalai wrote: > > We started this out of OpenOffice.org Intership program. I am thinking > > about the possible other checkt (the current version of Validator > > extension implements these checks, so we are looking more. For example > > excluded cells from sum, for example. Excel has this functionality. > > Oh, I see. Yes, excluded cells would be a possible check. Or a set of > repeated formulas where one is different from the others. I don't have a > list of possible errors, it's still open to define them. > > > Because this extension is not production quality we are still working on > > it, but we hit a problem that we can't avoid. If you interested I can > > send two version of it, > > one that works well with A1 reference modell another (patched by Kohei) > > works well with A1 and R1C1 notation but drops mystery reference errors. > > So that is why we did not uploaded to the extension repo. > > It would be best to have it available for everyone to take a look. But > if that isn't possible, you can send it to me. > > Niklas > > --------------------------------------------------------------------- > To unsubscribe, e-mail: dev-unsubscr...@sc.openoffice.org > For additional commands, e-mail: dev-h...@sc.openoffice.org -- GRATIS für alle GMX-Mitglieder: Die maxdome Movie-FLAT! Jetzt freischalten unter http://portal.gmx.net/de/go/maxdome01 --------------------------------------------------------------------- To unsubscribe, e-mail: dev-unsubscr...@sc.openoffice.org For additional commands, e-mail: dev-h...@sc.openoffice.org