Open Office

Robin_Meads · 6 June 2017 18:38

Is it possible to run Sailwave on a laptop that only has Open Office and not Excel ?

Sailwave · 6 June 2017 19:16

You don’t need office or excel to run Sailwave normally. It is fully self contained. You only need excel if you wish to use the progressive handicap system in custom or debug mode.

Jon

···

On Tue, 6 Jun 2017 at 20:04, rmeads1944@yahoo.co.uk [sailwave] sailwave@yahoogroups.com wrote:

Is it possible to run Sailwave on a laptop that only has Open Office and not Excel ?

–

Jon Eskdale

03333 443377

07530 112233

Huw2 · 6 June 2017 20:02

Hi,

  This is something I would personally like to see, an interface

between Sailwave and LibreOffice/OpenOffice, but I do not see it
happening unfortunately. Such an interface would then work on
Linux & MacOS systems as well.

  Could you please provide more information about what you would

like to achieve.

  If you mean RYA NHC in external mode then no. But if you want to

publish to LibreOffice/OpenOffice Calc then yes.

  Sailwave makes use of Windows Messaging Interface [WMI] to

bi-directionally exchange data with Microsoft Excel. This WMI
functionality is available in the development environment
[Clarion] that is used to code Sailwave.

  So whilst I know that LibreOffice has an API, it is not available

in the Clarion environment. As the Sailwave .BLW file [data file]
is just a plain text file, it would technically be possible parse
the data into a program, manipulate the data and write it back but
that write back needs to be absolutely correct otherwise Sailwave
will bomb.

  There is known to be one environment which has written data into

Sailwave from a database front-end and extracted data from
Sailwave into a back-end database [MySQL] using WMI. There is
another environment which just extracts data that uses open source
PHP/MySQL combination.

Kind regards,

Huw

···

On 06/06/2017 19:38,
[sailwave] wrote:

rmeads1944@yahoo.co.uk

          Is it possible to run Sailwave on a laptop that only has

Open Office and not Excel ?

Virus-free. www.avast.com

Sailwave · 6 June 2017 22:04

Just to hopefully clarify this subject. For normal operation you don’t require Excel or Open Office - Sailwave is self contained and will run on Windows or Linux or Mac under wine/winebottler. In this mode you can still publish to other applications so I see no reason if you wanted to, you should be able to publish to open office or similar.
Sailwave has the ability to communicate and be controlled by an external application using the Windows Messaging. This Windows messaging is used for NHC and ISAF interface amongst others. The Windows Messaging will still work on Linux and Mac with Wine/WineBottler.

The area which probably won’t work is the Excel interface for NHC when used in Custom/Debug mode. This is because it uses the COM Automation of Excel to populate, control and read Excel. The NHC application communicates with Sailwave using the Windows Messaging and with Excel using the COM Automation. Open Office doesn’t support a compatible COM automation hence it has to be Excel.

Jon

···

On 6 June 2017 at 21:02, Huw Pearce huw.pearce@bcs.org.uk [sailwave] sailwave@yahoogroups.com wrote:

Hi,

  This is something I would personally like to see, an interface
between Sailwave and LibreOffice/OpenOffice, but I do not see it
happening unfortunately. Such an interface would then work on
Linux & MacOS systems as well.

  Could you please provide more information about what you would

like to achieve.

  If you mean RYA NHC in external mode then no. But if you want to
publish to LibreOffice/OpenOffice Calc then yes.

  Sailwave makes use of Windows Messaging Interface [WMI] to
bi-directionally exchange data with Microsoft Excel. This WMI
functionality is available in the development environment
[Clarion] that is used to code Sailwave.

  So whilst I know that LibreOffice has an API, it is not available
in the Clarion environment. As the Sailwave .BLW file [data file]
is just a plain text file, it would technically be possible parse
the data into a program, manipulate the data and write it back but
that write back needs to be absolutely correct otherwise Sailwave
will bomb.

  There is known to be one environment which has written data into
Sailwave from a database front-end and extracted data from
Sailwave into a back-end database [MySQL] using WMI. There is
another environment which just extracts data that uses open source
PHP/MySQL combination.