Re: [drools-user] excel worksheet caching

2006-01-13 Thread Michael Neale
no there is no caching. What version of excel are you using? I have added CSV support as it is less prone to strange variances in the file format which xls is. Unfortunately Excel 97 format is very much a closed format, so it can be a little hard to account for all versions saveing in strange sta

Re: [drools-user] Re: excel worksheet conditions ignored

2006-01-13 Thread Michael Neale
sometimes the excel format can cause havok with the apache POI parser (depends on exact versions of excel). On 1/14/06, Pascal Chanteux <[EMAIL PROTECTED]> wrote: > > The problem seems to be a cell format/formula problem. I need to use the > 'general' format because my cell has a formulas. In th

[drools-user] excel worksheet caching

2006-01-13 Thread Pascal Chanteux
Hi , Is there any form of caching during the parsing/loading of an excel worksheet ? I have an excel worksheet for my drools test. The result of my test case is correct. Everything is OK. When I change something in the content of my cell, I have this exception : *org.drools.decisiontable.parser.D

[drools-user] Re: excel worksheet conditions ignored

2006-01-13 Thread Pascal Chanteux
The problem seems to be a cell format/formula problem. I need to use the 'general' format because my cell has a formulas. In this case my condition is ignored. When I hard code the result of the formula in the cell, it's ok. Is it forbidden to have excel formulas in the cells belonging to the cond

Re: [drools-user] excel worksheet conditions ignored

2006-01-13 Thread Pascal Chanteux
Yes I know, but in my case there is always somtehing in the cell. On 1/13/06, Michael Neale <[EMAIL PROTECTED]> wrote: > > if there is no text in the cell, the condition will not be included. > > On 1/13/06, Pascal Chanteux <[EMAIL PROTECTED]> wrote: > > > > Hi everybody ! > > > > I am using droo

Re: [drools-user] excel worksheet conditions ignored

2006-01-13 Thread Michael Neale
if there is no text in the cell, the condition will not be included. On 1/13/06, Pascal Chanteux <[EMAIL PROTECTED]> wrote: > > Hi everybody ! > > I am using drools 2.1 with excel worksheet. Sometimes, some conditions > columns are completely ignored by the engine, and thus my actions are > execut

[drools-user] excel worksheet conditions ignored

2006-01-13 Thread Pascal Chanteux
Hi everybody ! I am using drools 2.1 with excel worksheet. Sometimes, some conditions columns are completely ignored by the engine, and thus my actions are executed without testing the conditions . If I generate a DRL file from the worksheet, I see that my conditions are not included in the genera