BBC BASIC for Windows
« LibreOffice Calc »

Welcome Guest. Please Login or Register.
Apr 5th, 2018, 10:16pm



ATTENTION MEMBERS: Conforums will be closing it doors and discontinuing its service on April 15, 2018.
Ad-Free has been deactivated. Outstanding Ad-Free credits will be reimbursed to respective payment methods.

If you require a dump of the post on your message board, please come to the support board and request it.


Thank you Conforums members.

BBC BASIC for Windows Resources
Online BBC BASIC for Windows documentation
BBC BASIC for Windows Beginners' Tutorial
BBC BASIC Home Page
BBC BASIC on Rosetta Code
BBC BASIC discussion group
BBC BASIC for Windows Programmers' Reference

« Previous Topic | Next Topic »
Pages: 1  Notify Send Topic Print
 thread  Author  Topic: LibreOffice Calc  (Read 1083 times)
g3nrw
Junior Member
ImageImage


member is offline

Avatar




PM


Posts: 74
xx LibreOffice Calc
« Thread started on: Nov 22nd, 2014, 9:02pm »
I plan to write a BB4W program that reads data from a COM port and saves it in a LibreOffice Calc spreadsheet. Ideas/techniques/example code for accessing the Calc data structures anyone?

--
Ian
« Last Edit: Nov 22nd, 2014, 9:05pm by g3nrw » User IP Logged
rtr2
Guest
xx Re: LibreOffice Calc
« Reply #1 on: Nov 22nd, 2014, 9:31pm »
on Nov 22nd, 2014, 9:02pm, g3nrw wrote:
I plan to write a BB4W program that reads data from a COM port and saves it in a LibreOffice Calc spreadsheet.

Will a CSV (or tab-separated) file meet your requirements? I'm presuming LibreOffice will read such a file - MS Excel definitely will - and if so it would be the simplest solution.

Richard.
User IP Logged
g3nrw
Junior Member
ImageImage


member is offline

Avatar




PM


Posts: 74
xx Re: LibreOffice Calc
« Reply #2 on: Nov 23rd, 2014, 06:05am »
Not really.

What I have in mind is replicating an Excel VBA app I wrote some time ago, but now want to rewrite for LibreOffice to make the functionality available for people who don't have Excel.

In essence, the app displays a spreadsheet, and has several buttons, including a CONNECT and a READ button. After CONNECTing to the external device, the program READs data and plugs it into individual spreadsheet cells in real time.

To do this, I need to know how to make BB4W identify and write into individual Calc cells. As Calc and BB4W executables are separate entities (as opposed to Excel which is tightly integrated with VBA), it may not be practical to do what I want. At this time I am just wondering if anyone here has done anything broadly similar.

--
Ian
« Last Edit: Nov 23rd, 2014, 06:15am by g3nrw » User IP Logged
rtr2
Guest
xx Re: LibreOffice Calc
« Reply #3 on: Nov 23rd, 2014, 09:36am »
on Nov 23rd, 2014, 06:05am, g3nrw wrote:
To do this, I need to know how to make BB4W identify and write into individual Calc cells.

OK, in that case your question is effectively a duplicate of this thread:

http://bb4w.conforums.com/index.cgi?board=libraries&action=display&num=1409648031

You will find the answers there. Sounds like an interesting challenge, but it shouldn't be too difficult. If you've not used COMLIB before I would recommend studying the relevant section of the main Help docs and working through the examples on the wiki:

http://www.bbcbasic.co.uk/bbcwin/manual/bbcwing.html#comlib
http://bb4w.wikispaces.com/Component+Object+Model+programming

Richard.
User IP Logged
g3nrw
Junior Member
ImageImage


member is offline

Avatar




PM


Posts: 74
xx Re: LibreOffice Calc
« Reply #4 on: Nov 23rd, 2014, 11:01am »
Thanks Richard. That will wipe the smile off my face for an hour or two smiley

--
Ian
User IP Logged
Pages: 1  Notify Send Topic Print
« Previous Topic | Next Topic »

| |

This forum powered for FREE by Conforums ©
Terms of Service | Privacy Policy | Conforums Support | Parental Controls