Port the referencing addin for OpenOffice.org Calc

Details

  • Type: Task Task
  • Status: Resolved Resolved
  • Priority: Minor Minor
  • Resolution: Fixed
  • Affects Version/s: 3.09, 3.10, 3.11, 3.12, 3.13, 3.14, 3.15, 3.16, 3.17, 3.18, 3.19
  • Fix Version/s: 3.20
  • Component/s: Referencing
  • Labels:

Description

Old versions of GeoTools had an add-in for OpenOffice 2, which allowed the use of many of the power of the referencing module inside a Calc spreadshet. It provides services for coordinate transformations, querying informations about CRS, calculating orthodromic distances, etc. The add-in was broken with OpenOffice 3, but a contributor patched it using the NetBeans support of OpenOffice. Unfortunatly the OpenOffice plugin - which was working great with NetBeans 6.5 - has not yet been ported to NetBeans 6.7, as mentioned here:

Given the popular demand for this the Referencing add-in to Calc, we should port it as soon as the NetBeans plugin is available.

Issue Links

depends upon

Improvement - An improvement or enhancement to an existing feature or task. GEOTK-77 EPSG factory should be able to work with the HSQL database too

  • Minor - Minor loss of function, or other problem where easy workaround is present.
  • Closed - The issue is considered finished, the resolution is correct. Issues which are closed can be reopened.

Activity

Ascending order - Click to sort in descending order
Hide
Permalink
Martin Desruisseaux added a comment -

For the archive, the old add-in was available there: http://www.espace.ird.nc/sicade/addin-openoffice/fr/

Show
Martin Desruisseaux added a comment - For the archive, the old add-in was available there: http://www.espace.ird.nc/sicade/addin-openoffice/fr/
Hide
Permalink
Martin Desruisseaux added a comment -

The add-in has been ported, but we still need a connection to an embedded EPSG database. The lightest solution is to use HSQL since this is the database provided by OpenOffice - this avoid the need to bundle JavaDB in the OXT file.

Show
Martin Desruisseaux added a comment - The add-in has been ported, but we still need a connection to an embedded EPSG database. The lightest solution is to use HSQL since this is the database provided by OpenOffice - this avoid the need to bundle JavaDB in the OXT file.
Hide
Permalink
Martin Desruisseaux added a comment -

The only missing part is to find how to ask OpenOffice.org to put its own HSQL implementation on the classpath. HSQL was in the classpath when using OpenOffice.org 2, but doesn't seem to be anymore with OpenOffice.org 3.

Show
Martin Desruisseaux added a comment - The only missing part is to find how to ask OpenOffice.org to put its own HSQL implementation on the classpath. HSQL was in the classpath when using OpenOffice.org 2, but doesn't seem to be anymore with OpenOffice.org 3.
Hide
Permalink
Martin Desruisseaux added a comment -

Question about HSQLDB classpath has been posted on OOo forum there:
http://user.services.openoffice.org/en/forum/viewtopic.php?f=47&t=34720

Show
Martin Desruisseaux added a comment - Question about HSQLDB classpath has been posted on OOo forum there: http://user.services.openoffice.org/en/forum/viewtopic.php?f=47&t=34720
Hide
Permalink
Martin Desruisseaux added a comment -

Various experiments trying to locate the OpenOffice.org HSQL installation directory and augmenting the classpath with a custom ClassLoader didn't worked. Abandon the idea of using OpenOffice.org HSQL database. Instead, embedded our own HSQL dependency in the OXT file.

Show
Martin Desruisseaux added a comment - Various experiments trying to locate the OpenOffice.org HSQL installation directory and augmenting the classpath with a custom ClassLoader didn't worked. Abandon the idea of using OpenOffice.org HSQL database. Instead, embedded our own HSQL dependency in the OXT file.

People

  • Assignee:
    Martin Desruisseaux
    Reporter:
    Martin Desruisseaux
Vote (0)
Watch (0)

Dates

  • Created:
    Updated:
    Resolved:

Time Tracking

Estimated:
1d
Original Estimate - 1 day
Remaining:
0m
Remaining Estimate - 0 minutes
Logged:
1d
Time Spent - 1 day