Obba-4.0.16

Extension:
Extension ID:
info.obba
Release date:
16/11/2013 - 06:54
Version:
4.0.16
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.16 of Obba brings the following changes:

- Added access of static fields obCall where class referes the the classname and method name is ".FIELDNAME". Prior to version 4.0.15 this worked on objects, but not on classes.

Version 4.0.15 of Obba brings the following changes:

- Obba for Excel: Implemented a workaround for an Excel bug which prevented sheets in "proctected view" to calculate after enabling (peviously the sheet had to be reopened or unblocked in its file properties).
- Imrpoved exceptions handling displying cause for wrapped exceptions.

Version 4.0.14 of Obba brings the following changes:

- Obba for Excel: Fixed a rare compatiblity issue with Obba for LibreOffice/OpenOffice (this fix is needed to run Curve Calibration Sheets from finmath.net finmath lib 4.0.7)

Version 4.0.12 of Obba brings the following changes:

- Obba for Excel: Use of local path in obAddJar (etc.) is compatible with sheet running form Windows UNC path

Version 4.0.10 of Obba brings the following changes:

- Added status tab to Obba Control Panel
- Obba for Exce: Improved performance for large arrays and ranges.

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).