Obba-4.0.8

Extension:
Extension ID:
info.obba.Obba.
Release date:
18/08/2013 - 16:48
Version:
4.0.8
Operating system:
System Independent
Compatibility:
3.0, 3.0.1, 3.1, 3.2, 3.3, 3.4, 4.0
Binary type:
OpenOffice extension (.oxt)
Release Notes: 

Version 4.0.8 of Obba brings the following changes:

- Improved memory managment when runinng tasks concurrently (via obRun). (For details, see http://stackoverflow.com/questions/18292928/freeing-up-resources-in-comp... (very deep details))

Version 4.0.7 of Obba brings the following changes:

- List of exceptions including the causing function call in Obba Control Panel (Obba for LibreOffice/OpenOffice only)
- Improved compatiblity with VBA and XLW (for using Obba via VBA and passing XLW return values to Obba functions)

Version 4.0.5 of Obba brings the following changes:

- List of exceptions including the causing spreadsheet cells in Obba Control Panel (Obba for Excel only)
- Improved exception handling of Obba for Excel.
- Improved error treatment for Obba for Excel: If arguments are #NA, results will display #NA.
- Allowed creation of empty arrays (use an array constructor with a missing or empty range)

Version 4.0.2 of Obba brings the following changes:

- Obba now uses .Net Framework 4.0 and ICE Version 3.5.0 (note: you need Obba server version 4.x for Obba client 4.x).
- The unregistered version may be used for an unlimited time.
- Improvements to performance and exception handling.

Version 3.2.2 of Obba brings the following changes:

- The default installation of Obba for Excel has been changed to %LOCALAPPDATA%\Obba (previously %APPDATA%\Obba).
- The port of the server can be configured using Obba.Server.Port in Obba.properties and ObbaClient.properties (allows one machine to run different servers).
- Fixed a problem in the uninstaller of Obba for Excel leaving a small (but harmless) file in the installation directory.

Version 3.1.19 of Obba brings the following changes:

- If the JVM is started by the client ("local server"), it starts with 1GB of heap space (-Xmx1024m). The parameter may be configured via Obba.Client.LocalServer.Params in ObbaClient.properties
- Improved startup of local server from Excel.
- Fixed a problem related to locating Obba.properties.
- Fixed a problem with obGet operating on String[][] arrays (e.g. in VBA).

Version 3.1.12 of Obba brings the following changes:

- Added convenient way to create Maps from the Spreadsheet (see "Datatypes Demo").
- Some log messages (java.uitl.logging) are now at LogLevel.FINE (instead of LogLevel.INFO).

Version 3.1.10 of Obba brings the following changes:
- Improved startup of local server from Microsoft Excel.

Version 3.1.9 of Obba brings the following changes:

- Fixed a bug which resulted in a manually started server shutting down when the client disconnects. The server now keeps on running. Note: The behavior can be customized in the servers Obba.properties file.
- Fixed a bug which resulted in an error when creating an array consisting just on one element.
- Some improvements to error messages.

Version 3.1.7 of Obba brings the following changes:

- obGet makes a default conversion to a string (using the toString-method on the specific object), when calling obGet on an object for which no corresponding or suitable spreadsheet datatype is available.

Version 3.1.6 of Obba brings the following changes:

- Stability improvements to the OpenOffice version.

Version 3.1.2 of Obba brings the following changes:

- Ability to dynamically compile a class from Java source (provided as a spreadsheet string) and instantiate objects from it (using the spreadsheet function obMake): Obba now includes a utility class (info.obba.javatool.Compiler) which allows to dynamically compile a class from a string source. Obba's obMake accepts object handles to java.lang.Class object to specify the class. See "04 - Class to Object Demo" in the "Demos" folder.

Version 3.0.12 of Obba brings the following changes:

- Stability improvements to the OpenOffice version. In some situations an odt sheet failed to load external JARs through the spreadsheet function right after opening. A forced manual re-calculation was necessary. (Note that it is no longer recommended to load a JAR via a spreadsheet function. Instead place all JARs side by side to the server and lauch the server manually).

Version 3.0.8 of Obba brings the following changes:

- Rewrite of Obba add-ins for Microsoft Excel and OpenOffice / LibreOffice / NeoOffice.

- Allows to run the Obba server Java virtual machine in a separate process (run "java -jar Obba.jar").

- Allows to run the Obba server Java virtual machine on a remote machine (edit the ip address in ObbaClient.properties).

- Easier creation of java.util.Date form Excel Date / OpenOffice Date using obMake(;"Date";...).

- Added conversion from java.util.Date to Excel Date / OpenOffice Date via obGet.

- The Excel functions obLoadObjects / obSaveObjects were renamed to obLoad / obSave respectively (to create compatibility with the OO implementation).

- Added support for Excel 2010 64 bit.

- Worked around a problem resulting in Obba Control Panel not showing up under OS X.

- Fixed a bug resulting in a hang of OpenOffice (once) after installing Obba.

- Improved error / exception handling: much clearer log output of Java exceptions.

Version 2.2.15 of Obba brings the following changes:

- The Obba properties file allows to disable the access to the Obba control panel via "controlpanel=disallow".

- The Obba properties file allows to hide the Obba menu in Excel via the "menu=hide".

Version 2.2.10 of Obba brings the following changes:

- Obba for Excel now prints the calling spreadsheet cell to the log file, when a Java exception occurs. This may come in handy when debugging spreadsheets.

Version 2.1.8 of Obba brings the following changes:

- Complete rewrite of Obba logging.

- Added a log window to the Obba Control Panel (enable it via Window -> Show Log Window)

- Many improvements to the diagnostic output.

Version 1.9.34 of Obba brings the following changes:

- Fixed a problem which prevented loading of some classes. The current thread's context class loader was null. This appears to be a problem with the Java plugin. A workaround was created. Note: This problem resulted in the XMLDecoder not working.

- Fixed a problem which prevented installation of Obba for OpenOffice.

- More improvements for OpenOffice

Version 1.9.29 of Obba brings the following changes:

- Arrays of objects can be created using obMake with a class name of ClassName[] where ClassName is the component type (see documentation for an example).

- Added a demo sheet showing how to access data from finance.yahoo.com. Include the Java source code for the class handling the web access.

Version 1.9.13 of Obba brings the following changes:

- Added a window to the Obba Control Panel which visualizes the objects and their dependencies in a graph. The dependencies are determined by the objects used during construction an object.

- Improved the handling of transient object handles.

Version 1.8.26 of Obba brings the following changes:

- Invocation of static methods (class methods) now uses dynamic method lookup (before this was only supported for methods on objects)

Version 1.8.25 of Obba brings the following changes:

- Bug fix. Accessing elements of an array of primitives returns a primitive (before the wrapper object was returned)

Version 1.8.21 of Obba brings the following changes:

- Access fields of an object directly through a spreadsheet function call using 'obCall'. In this case the method name has to be dot + fieldname (e.g '.myMember').

- Access elements of an array through a spreadsheet function call using 'obCall'. In this case the method name has to be '[]' and the argument of the call is integer specifying the index. Element of multi-dimensional arrays can be accessed likewise.

- Vector arguments can be passed as arbitrary ranges (columns, rows or two dimensional ranges which are then flattened using row major).