Android Question [Solved] [XLUtils] Unknown member: valuecached

[angel_]

When I test an example with XLUtils, for example this:

[XLUtils] Writing Excel Workbooks

Main concepts and reading MS Excel workbooks with XLUtils: https://www.b4x.com/android/forum/threads/xlutils-jpoi-5-read-and-write-ms-excel-workbooks.129969/#content Writing workbooks is also simple but does require a bit more code. There are several types that we will use, in addition to...

www.b4x.com

I get this error

B4J Version: 8.90
Parsing code.    (0.04s)
    Java Version: 8
Building folders structure.    (0.01s)
Compiling code.    Error
Error compiling program.
Error description: Unknown member: valuecached
Error occurred on line: 165
If FetchFormulasInsteadOfCachedValues Then Return cell.Value Else Return cell.ValueCached
Word: valuecached

 

[DonManfred]

You are using an old jpoi class it seems.
Redownload anything and put the into the right place.
Rdownload the additional JAR/AARs too!

 

[angel_]

I have this:

What am I missing or what do I have to delete?

On the other hand, if I delete jPOI of aditional libraries appears this error:

Unknown type: poicell<br />Are you missing a library reference?
Unknown type: poisheet<br />Are you missing a library reference?

(If possible move to the B4J forum)

 

[Erel]

My fault. The updated jPOI was missing.

It is online: https://www.b4x.com/android/forum/t...-and-write-ms-excel-workbooks.129969/#content