Warning message

This extension was not updated recently. It might not work with latest versions of OpenOffice.

Primary tabs


Average: 3.6 (5 votes)

Calc, Writer, Impress, Draw, Base, Math, Chart,
invoice, extension, gantt chart, extension
Post date:
Thursday, 29 October, 2009 - 19:57
Week: Not tracked - Month: Not tracked - Year: Not tracked - Timeline
Download extension
System Independent version - All releases
Compatible with OpenOffice 4: Unknown
User feedback:
Compatible with OpenOffice 4.x?

En: With Toools you can now creaty simply your invoice, from db, with report in .odt. No need for other part software. With this extension you can program a job and create a Gantt chart connected with HSQLDB, updating the chart in real-time. The chart can be copy-pasted and also manually modified.

It: Con Toools è possibile adesso creare facilmente le proprie fatture, dal db, con report in .odt senza bisogno di software di terze parti; programmare un lavoro e creare un diagramma di Gantt collegato con il database HSQLDB integrato in OOo, e aggiornare il grafico in tempo reale. Il grafico può essere copiato ed incollato e anche modificato manualmente.


  • English,
  • Italiano,
  • Hungarian (partial - thank to Juhász Dezső);
  • Dutch (thank to Dick Groskamp);
  • Spanish (partial - thank to Jose Lopez and David Freijeiro González);
  • French (partial - thak to Bernard Gallat);
  • Turkish (partial - thank to Turker Gulum).
  • Galician (partial - thank to David Freijeiro González);


Version Operating system Compatibility Release date
0.5.3-beta System Independent -- 29/06/2010 - 17:34 More information Download
0.5.2-beta System Independent -- 24/06/2010 - 17:53 More information Download
0.5.1-beta System Independent -- 16/06/2010 - 17:38 More information Download
0.4.4 System Independent 3.1, 3.2, 3.3, 3.4 19/03/2010 - 18:22 More information Download
0.4.2-standard Windows, Solaris Sparc, Solaris x86, Linux, Linux x86-64 3.1, 3.2, 3.3, 3.4 28/01/2010 - 17:55 More information Download
0.4.2 System Independent 2.x, 3.0, 3.1, 3.2, 3.3, 3.4 28/01/2010 - 17:53 More information Download
0.4.0-nPy-beta System Independent 2.x, 3.0, 3.1, 3.2, 3.3, 3.4 18/01/2010 - 18:16 More information Download
0.4.0-beta Windows, Solaris Sparc, Solaris x86, Linux, Linux x86-64 3.1, 3.2, 3.3, 3.4 18/01/2010 - 18:02 More information Download
0.3.1-nPy System Independent 2.x, 3.0, 3.1, 3.2, 3.3, 3.4 10/01/2010 - 17:48 More information Download
0.3.1-rc-2 Windows, Solaris Sparc, Solaris x86, Linux, Linux x86-64 3.1, 3.2, 3.3, 3.4 08/01/2010 - 17:52 More information Download


I have to install Mysql or may I use the BrOffice Base?
Do you think that is possible, in evaluation, turn the extension independent of external program, using the Base organic of OO?
BrOffice 3.2 Ubuntu and BrOffice 3.2 Windows 7

complimenti per l'estensione MADE IN ITALY!!!

When I tried to instal toools I got error message, that it can't be installed. Later, when I tried to install, remove or update any other extension crashes with error message:
Add Extension(s):
/home/xxx/ does not exist

Can anybody help with solution?

Have you tried removing the addon txe-0.7.oxt?
I think the problem is there


Your latest version do not install properly on my Windows machine
- no comments in the Extension managaer
- no "itctools" in the Top menu bar



The extension works fine in my Vista and Ubuntu too, so try to remove and reinstall it.
If you don't solve the problem, please let me know.
I saw a mis-function in Ubuntu: the Save position button work only until OOo is not closed, I don't know why (this not happen in Vista)

Hi Sergio
please find some code to automaticly selecting OOdialogss
"Hoe" means "how" and must bean true for use of "SystemDialogs and false for using OOdialogs
hope it helps

Sub UseSystemFileDialogs(Hoe as boolean)
dim aArgs(0) as Object
dim aPropValue as new
xconfig = createunoservice("")
aPropValue.Name = "nodepath"
aPropValue.Value = "org.openoffice.Office.Common/Misc"
aArgs(0) = aPropValue
xAccess = xconfig.createinstanceWithArguments("",aArgs())
aIsSystemDialog = xAccess.getHierarchicalPropertyValue("UseSystemFileDialog")
xAccess.replaceByName("UseSystemFileDialog", Hoe)
End Sub

It would be more accessible for an international audience if English was used for everything.

Thank you Fernand, very useful!
I'll include in my code asap.

hm - a mini-help, that could be fair enough, but it does not help me - and I guess the screenshots will come later .
I gave it a try under ooo-portable german, and looks, it is not working:

Setting up: You mean: at first go to CALC and the new menu-item "icstools" and "settings" to try to build the .odb?
it terminates with the missing mysql-facilities - as the connector is not available, whereas it should have used the HSQLDB. Also I did not understand what you mean by "go first to MACRO/Dialog-settings ... )
At actual: I regret, to me it is not working


Test the last release.
Simply open IcsTools -> IcsGantt -> Project and select a directory.
Nothing else to do!
Hope it helps.
N.B. If you have registered a MySQL db without having created it, remove it. MySQL db creation is not automatic, only registering is.

tja - what to say, you should not use the extensions-board as a playground, 3 versions for today, but of none them working.
I gave it a try with 0.1.9
at actual the hsql-odb is build, but it has no content (data-file with table-structure or forms is missing - all sitting unused in the UNO-cache)
First run of macro gives a "illegal Argument - it.icstools..." not registered.

hmm ..


I've hidden the 2 releases you refer, they should be invisible...
I tried the extension in my newest installed Ubuntu 9.10, and the creation of Hsqldb works fine, as Windows Vista too. I haven't an XP by hand.
Perhaps the error you encountered could help me, would you give me the entire message? If too long, feel free to send me a mail.

the extension is not working
I just started it - this time from a new empty .odb and the error is the same as above;
see screenshot on:

You could be proud of having 1500 downloads, however, why is nobody else commenting on this issue?
Nobody gave it a try?


but trust me, the 0.18 is not working too

the board is blocking screenshots, so you please read the above mail and try to understand the error-message:
the skript is brooken in the first line (Function OpenForm without arguments)
and thereon the reports that it.icstools.toools is no registered extension

1500 downbloads but no comments, looks as nobody gave it a try sofar


0.18? Do you mean 0.1.9?
0.1.8 had a problem, download the 0.1.9 if you haven't done yet.
If you have the non registered extension problem, please try to remove the extension, close OOo and reinstall the extension (0.1.9).
Please let me know if you don't solved.
(n.b.: for the download, I hope it's because the extension usually works fine)

it would be very kind if you could show some willingness in understand me.
As written above, I tried 0.18. aswell as 0.19 - both not working.
Well, didn't you receive direct support from SUN? However, it is not working, a withdrawl might be a good decision.


I posted a new release, whithout no news, only redone, hoping to solve the problem of Martin.
I am aware that this system of reporting bug is not efficient and is impossible to know the real usability and use of the extension, so I am working to a facility to send feed-back on the extension with a button. Is also impossible to know if what Martin is saying is experienced from other users (@Fernand: you solved?), as I am unable to repete the error.
For now, on reporting bug please let me know the o.s. and version of OOo.

Well, "Toools" looks ambicious, the more it comes from a non-developer. respect.
But what you read in here is not for reporting bugs, you have received comments on droping a programm thats seems not to be matured enough to have it here. Hope you can do better next time.


Well Sergio,
i gave it a new try and find, that the installation always will fail, when installation is for EVERYBODY, as in that case the variable USER will lead to nowhere, but in case it is installed for the very user only, it works and installs correct.

However, no draw back from here, as it is sort of a beast, not really usable, neither is there a workflow nor did you meet the basics in dealing with data. So it just remains as a clever business-idea: Nothing forced, just putting a link into an application for to purchase the Help-File.
Me personal I could accept that, not too much anyway, if it is working and part of a well formed calendar and task-tool, with reports etc.
But until now thats no the case.
So you may need to find someone that will help you, or you drop the code as free for anybody in any ooo-related forum for further development, what could be the better idea.

my 2 cents (or had it been more?) - Hope that had helped


For the first part of your message, the installation is now correctly limited to user.
For the second part, I am strongly determined to improve and enlarge this extension. Any different opinion won't be considered.
However if you have something positive to say is ever welcome.

hm - rather useless, with a nonworking homepage, missing screenshots and without any hint on the how-to-use, meaning with a link to the user-guide available as a commercial e-book only.

Ok, you're right, I think so too. I was waiting for someone who asked me :-)

So I've done two things:
1. I put a free Tutorial (part of the User Guide) on the link above (or here);
2. I put some screenshots on the home-page.