Title: Szalai Kálmán
Hello Niklas!
On 2010-06-04 10:42, Niklas Nebel wrote:
On 06/04/10
09:12, Kálmán „KAMI” Szalai wrote:
We are working on a Validator that checks the
formulas, cells, etc in Calc. The extension is written in Java. What is
the main conditions that we should check and
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.
Hi Eike, Could you tell me why modifying the spreadsheet while interpreting
a function is not the right approach and what is the workaround or the right
approach ?
Many thanks,
Rashi
On Thu, Jun 3, 2010 at 6:47 PM, Eike Rathke e...@sun.com wrote:
Hi rashi,
On Thursday, 2010-06-03 17:52:10
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
Hi Eike,
same additional information:
I use the odffmap entry
{ IMCOT, IMCOT, false,
com.sun.star.sheet.addin.Analysis.getImcot,
COM.SUN.STAR.SHEET.ADDIN.ANALYSIS.GETIMCOT }
(1) Save document in setting ODF 1.2.
(2) Open it in OOo2.4.3 and save there. That results in document version
Hi Fellowship of Calc!
I uploaded the extensions here:
ftp://ftp.devall.hu/kami/calc/
Validator.oxt - validator for calc
watchwindow_1.1.2.1_kohei.oxt - watchwindow Kohei version (A1 and R1C1
noatation reference problem)
watchwindow_1.1.2.1_original.oxt - watchwindow original version (only
Hi Daniel,
Daniel Rentz schrieb:
Hi Regina,
Regina Henschel schrieb:
If I use ocExternal the prefix is set, but the functions are not
distinct, only one name is written and on import the whole function
name is stripped, so only =(z) remains from =_xlfnodf.IMSECH(z).
I see no way to add the
Hi,
Regina Henschel schrieb:
I have now used in analysis_deffuncnames.src an entry:
StringArray ANALYSIS_DEFFUNCNAME_Imcot
{
ItemList =
{
_xlfnodf.IMCOT; ;
_xlfnodf.IMCOT; ;
};
};
And for comparison an entry
StringArray
On 06/04/10 16:21, Kálmán „KAMI” Szalai wrote:
I uploaded the extensions here:
ftp://ftp.devall.hu/kami/calc/
Validator.oxt - validator for calc
watchwindow_1.1.2.1_kohei.oxt - watchwindow Kohei version (A1 and R1C1
noatation reference problem)
watchwindow_1.1.2.1_original.oxt - watchwindow