basig.blogg.se - Openoffice for mac

OPENOFFICE FOR MAC MAC OS
OPENOFFICE FOR MAC CODE

The Obba spreadsheet functions are available in Excel (running on Windows), in OpenOffice and LibreOffice (running on Windows, Mac OS X, Linux, etc.) and in NeoOffice (running on Mac OS X). If the Java execution raises an exception, Obba lists the spreadsheet cell containing the function that raised the exception in the Obba Control Panel. Obba for Excel tracks the calling spreadsheet cell. This allows tracking which objects are used as well as (implicitly) their dependencies. Since objects are instantiated through the Obba functions and handled by Obba handles, Obba knows the object you are referencing in your spreadsheet. A spreadsheet-specific factory method is not necessary. Objects are instantiated by their original constructor.

OPENOFFICE FOR MAC CODE

in that it requires no glue code to link the spreadsheet to the library. Obba is different from interfaces such as XLL4J, XLW, ExcelDNA, etc. Exception tab: showing exceptions associated with the spreadsheet cell containing the function that raised the exception. Obba allows to create an object from Java source code (dynamically compile source to, re-load the class definition and instantiate an object from it), see Class to Object Demo (movie).įor a more detailed introduction see Obba documentation.

Using spreadsheets as GUI to your object while debugging.

For Java Developers: Testing, debugging and analyzing Java libraries with spreadsheets.

For Spreadsheet Users: Creating powerful spreadsheet calculations using external libraries, running calculations in Java.

All this through spreadsheet functions, without any additional line of code (no VBA needed, no additional Java code needed).

Serialization and de-serialization (save Serializable objects to a file, restore them any time later).

Allows arbitrary number of arguments for constructors or methods (avoids the limitation of the number of arguments for Excel worksheet functions).

Asynchronous method invocation and tools for synchronization, turning your spreadsheet into a multi-threaded calculation tool.

Invocation of methods on objects referenced by their object handle, storing the handle to the result under a given object label.

Instantiation of Java objects, storing the object reference under a given object label.

Loading of arbitrary jar or class files at runtime through a spreadsheet function.

Client/server support: The Java virtual machine providing the add-in may run on the same computer or a remote computer - without any change to the spreadsheet.

Stateful access to almost all objects and methods running in a Java virtual machine via a fixed set of spread sheet functions.

With Obba, you can use spreadsheets as GUIs (Graphical User Interfaces) for your Java libraries. Obba provides a bridge between spreadsheets and Java classes. The spreadsheet and Obba JVM may run on different machines. Schema of Obba Interaction: Obba provides access from the spreadsheet to objects created from classes of your library - without any additional coding.