Stack Overflow
Stack Overflow

Questions tagged [openoffice-basic]

OpenOffice.org Basic is a programming language which is based on StarOffice Basic and bears similarity to Microsoft VBA.

Resources:

109 questions
0
votes
0 answers

Open office sdk create xls, doc,ppt files in Java

How to create a xls file using open office sdk? Please give Java example source code. Also needed to create word and power point files. I’m not able to get any examples Below is the code I tried. It tries to open in Open office App, that I don't…
user3544081
0
votes
1 answer

openoffice calc sumproduct with a twist

my first attempt in VBA apart from using simple functions; asking for a kick start here: assume this (part of a) sheet factor b-count c-count d-count A2 b2 c2 d2 ... A3 b3 c3 d3 ... Assume that…
Titus
  • 452
  • 8
  • 19
0
votes
0 answers

csv file not opening in standard view in OpenOffice

I am running a tool in Jenkins, which reads a .csv file. The computer I'm using doesn't have Microsoft Office installed, just OpenOffice. Compared to Excel, OpenOffice opens this file in a strange view, for example: connects a few columns to one…
Or Rosenblum
  • 13
  • 4
0
votes
0 answers

How to make radio buttons and check box read only in open office itext library

I have created template form using open office.Im assigning values to them from Java code.I don't want user to modify PDF after creation.Im able to implement it for textbox by using read-only property.But how to achieve same for check box and radio…
nik
  • 1,464
  • 4
  • 18
  • 32
0
votes
2 answers

Concatinate in OPEN OFFICE removing Leading zeroes

A B C D 2 DRUGS 000000000004 2 PARACETAMOL (ACETAMINOPHEN) TAB 500 MG This is my entry in my open office so we have here the row 2 with columns A-D I have create a formula =CONCATENATE("('"…
Pekka
  • 1,075
  • 2
  • 10
  • 17
0
votes
1 answer

ActiveCell.Offset for libreoffice

How can I get access to nearby of selected cell in LibreOffice (OpenOffice)? I can get only selected cell with "ThisComponent.getCurrentSelection". I just need an alternative for MS Excel VBA function "ActiveCell.Offset".
user31651
  • 3
  • 2
0
votes
1 answer

OpenOffice upgrade to 4.1.2 - Command Line with Macro No Longer Working

We've been using OpenOffice Portable to convert .docx files to PDFs. We run a command like the following in a .NET MVC web application running as NETWORK SERVICE. .\soffice.exe -invisible…
Adam
  • 1,202
  • 11
  • 25
0
votes
1 answer

OpenOffice BASIC how to insert checkbox in sheet

I'm using OpenOffice Calc. And I am writing macro's in OpenOffice BASIC. I need the right code to insert a checkbox in the sheet. I now have Dim Doc as Object Doc = ThisComponent Dim cbName As Object cbName = "checkbox_name" Dim oCheckBoxModel as…
user2190492
  • 1,174
  • 2
  • 9
  • 37
0
votes
2 answers

OpenOffice : how to load data from http address?

With an Openoffice macro, I want to load data from my local webserver. I tried this code : Dim stringWeb As String, webAddr As String Dim doc As Object Dim opts(0) As New com.sun.star.beans.PropertyValue webAddr =…
Jerry
  • 1,141
  • 1
  • 13
  • 18
0
votes
1 answer

How to make text centered in cell in openoffice spreadsheet?

Is there anyway to make text centered in cell in openoffice spreadsheet? By center， I mean the same white space between left and right, top and bottom of the text. Thanks in advance!
xxks-kkk
  • 2,336
  • 3
  • 28
  • 48
0
votes
1 answer

What does the "o" of "oSheet" stand for?

I've noticed numerous examples online where OOoBasic & Libre Office Basic use a "o" convention for naming objects. We always see oSheet, oCell, and so on. Does the "o" stand for object ? Is there a document in which those conventions are listed ?
Samuel
  • 594
  • 1
  • 6
  • 22
0
votes
1 answer

OpenOffice Basic: how to show Unicode characters in a MsgBox correctly?

I've got a problem with one of my macros. I'm showing a string with Unicode characters in a msgbox. MsgBox "ščř" But all I get in the message box are ???s - until I open the BASIC IDE. Once I open the IDE, the message box starts showing the Unicode…
jiroch
  • 414
  • 6
  • 19
0
votes
2 answers

Google Maps geocoding API in OpenOffice Calc VBA

For my project, I need to geocode a set of locations for which I would like to know the GPS coordinates. The amount of locations it too big to to it by hand, but not too much so that I will not have problems with Google's limitations of the use of…
Damien
  • 147
  • 7
0
votes
1 answer

Base data sheet form will not display calculated Field

I have a Data Sheet form which has a calculated field column. However the field will not display even though it has the correct value. The field in question is "numRisk": Sub Calculate_Risk (Form As Object) Dim OrderPrice, IfDonePrice,…
user1897830
  • 443
  • 1
  • 3
  • 10
0
votes
1 answer

OpenOffice Basic - Finding Number of Data Points in Column

I need to find the number of data points within a single column and place the value in a given cell on an OpenOffice Calc Spreadsheet. Here is my code so far I'd appreciate if someone can tell me where I'm going wrong or what is missing.…
dirty mike
  • 1
  • 1
1 2 3 4 5
6
7 8