Ticket #125 (closed enhancement: fixed)

Opened 13 years ago

Last modified 13 years ago

Automatically launch spreadsheet application when exporting overlays

Reported by: sorber Owned by: sorber
Priority: critical Milestone:
Component: visbio Severity:
Keywords: Cc:
Blocked By: Blocking:

Description

Use system calls to automatically launch Excel, OpenOffice, etc. when overlays are exported.

In order to launch the application, may need to create a new Process object. Can use Runtime.exec() (just launch, don't worry about the handle).

Add an option for path to program to launch. This option may be altered by the user, but it's value should be guessed based on the OS. To determine OS:

  • Use JGoodies utility method Looks.is...
  • Use utility methods in VisBio, if they exist
  • Check System.getProperty("os.name"), if neither of the above are possible

To add an option, need to add method OptionManager.addStringOption (basically the same as addNumericOption).

Change History

comment:1 Changed 13 years ago by sorber

  • Priority changed from major to critical

comment:2 Changed 13 years ago by sorber

Support OpenOffice Calc, gnumeric, MS Excel, MS Excel Mac (hard-code default paths). Need to add a StringOption to OptionManager for specifying path to spreadsheet app.

  • Microsoft Excel on Mac OS X: '/Applications/Microsoft Office 2004/Microsoft Excel'
  • 'C:\Program Files\Microsoft Office\...'

comment:3 follow-up: ↓ 5 Changed 13 years ago by sorber

Added basic launch feature. Need to add options for toggling launch and specifying spreadsheet path. Need to update looks jar file if we want to use the jgoodies...LookUtils methods for determining the OS type.

comment:4 follow-up: ↓ 6 Changed 13 years ago by sorber

Decide where spreadsheet launcher should live as an instance. Should it belong to the OverlayManager, the OverlayWidget? Should it have any static methods (as it does now, for getting the path to the default spreadsheet application)?

comment:5 in reply to: ↑ 3 Changed 13 years ago by sorber

Replying to sorber:

Need to update looks jar file if we want to use the jgoodies...LookUtils methods for determining the OS type.

Made a new ticket for this task: #142

comment:6 in reply to: ↑ 4 Changed 13 years ago by sorber

Replying to sorber:

Decide where spreadsheet launcher should live as an instance. Should it belong to the OverlayManager, the OverlayWidget? Should it have any static methods (as it does now, for getting the path to the default spreadsheet application)?

New ticket: #141

comment:7 Changed 13 years ago by sorber

  • Status changed from new to closed
  • Resolution set to fixed
Note: See TracTickets for help on using tickets.