M Vandenhoeke wrote:
I have written a OpenOffice writer document and I have lost the
password. Since the Save with password encrypt the document, it is
impossible to decrypt it like the Microsoft Word document. The only
way is to apply the force brut which mean that you try every
possible
Hello Stephen, I have added comments inline...
Stephen Gassner wrote:
I am a California family law attorney. Before that I was a systems
engineering consultant,
snipped impressive computer background and a little bit more...
I would like to help you. But I do not
have the immediate resources
Note: I am using OOo 2.0 Beta on Windows and Linux.
Some interfaces accept an array as the argument. In two of these
interfaces, for example XDatabaseMetaData.getTables(), it is specified
that the argument should be NULL in some cases.
I made some changes to your macro
Dim oProps(2) as New com.sun.star.beans.PropertyValue
Dim sUrl As String
Dim oDoc
'oDesktop = createUnoService(com.sun.star.frame.Desktop)
'sUrl = file:///somewhat.sxw
sUrl =
file:///andrew0/home/andy/My%20Documents/OpenOffice/AndrewFontMacro.odt
Jens Ansorg wrote:
Andrew Douglas Pitonyak wrote:
The following code works for me... I have a form called Standard,
which contains a form called Catalog, which contains a form called
Country, which contains a control called TextBox_Country. The
second example, returns the Dealer form, which
Search the OOo Forum. This should get you started anyway.
http://www.oooforum.org/forum/viewtopic.phtml?p=76328
I think that I have an example somewhere, if I can only find it.
Matthias Benkmann wrote:
I'm writing an application that creates CSV-files and automatically
loads a text template for
Download my free macro document (see link below), or get my book. If you
have my free macro document, check out the section discussing how to
traverse paragraphs (Andrew learns to ...). Also, read the section on
the selected text framework, which demonstrates how to know when to end.
It would
Department LinuxOffice Migration wrote:
How can I script this from a Java or Basic program that knows only the
name under which the database is registered?
So, do not register the database. I know that you do not have to if you
are using the new development version. Use the URL to the database
I thought that columns were usually set using a page style... Something
to consider anyway.
Ulf Lamping wrote:
Hi List!
I posted the following mail at the users list but couldn't get any real help,
so trying here (sorry if this is a known problem) ...
To format columns, I use Format/Columns
PETER EBERLEIN wrote:
On the German list we were also told that because of license reasons
this feature was not implemented into OpenOffice (contact Elizabeth
about that).
In general, if a feature exists in StarOffice and NOT in OpenOffice, it
is because another product was
I added a section in my free macro documnet, if you have not already
seen it, titled
You can not move a cursor to a TextTable anchor.
This directly answers your question with a working example in Basic
Andre B Derraik wrote:
Hi,
I'm having problems with the XTextTable.
I'm trying
Interesting questions so I copied them back to the Dev list
I am adding answers in-line.
Uwe Brauer wrote:
Hello
The OO database is unfortunately no as comfortable as the scalc.
Do you know about a macro which could do protect rows in a scalc
document against partial sorting.
Original
Matthias Benkmann wrote:
It seems that when I use a custom Basic function in a cell formula,
during the executing of this function, I can't write to any cells.
Statements such as
ThisComponent.Sheets.getByIndex(0).getCellByPosition(4,1).setValue(33)
are silently ignored. Why does this happen?
James Black wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Christian Andersson wrote:
Thats what I do also, I have created a message system that I can call
from basic that will open a dialog that holds all debug information for
me, unfourtunally this does not cover everything..
what
Peter Eberlein wrote:
Hi,
is there a way to move the standard library from the userprofile to
the shared folder?
The reason (please correct me, if I'm wrong):
I've written some global macros as calc functions, and calc functions
must be located in the standard library.
But I want to
Sandah Aung wrote:
Dear Sir/Madam,
I am writing this letter to ask you to contribute something to the
OpenOffice.Org project.
I would like to introduce myself first. I am a full-time self-employed
English teacher from Myanmar (more well-known as Burma). I help my
students prepare for
Matthias Benkmann wrote:
I have a problem with a recursive function in one of my macros. The function
is supposed to either return an array of strings or Empty (in case there's
not enough input data). However, under some circumstances the function
mysteriously returns Object/Null instead of
Michele Zarri wrote:
Hi,
I hope this is the right list, if not, apologies.
I have written a macro that relies on a configuration file where I store
some parameters. I would like to avoid to re-open the file every time the
macro is executed so I would like writer to remember whether the file
Jürgen Schmidt wrote:
Christian Junker wrote:
Hey Jürgen,
2005/10/28, Jürgen Schmidt [EMAIL PROTECTED]:
Aber nichtsdestotrotz danke für den Hinweis. Das scheint ein
Übersetungsproblem zu sein und wir werden das überprüfen und
korrigieren.
gibt es die Möglichkeit das Dokument (engl. +
Jim Barrington wrote:
Hi all
I am developing an application for the OSCommerce/Zencart community which
sorts data and builds their database using Excel then Access. Now I know
Access works with Open Office but do you have any examples of porting VB6
code which works with Excel so it works with
王彬 wrote:
Hi,all
I want to access a database,but I meet with some problems.
For example:
The SQL string is:SELECT * FROM test
When I executeQuery this SQL,a SQLException will happen -- Table not
found in statement [SELECT * FROM test]
But the table test does exist.
Then I check another SQL:
Til Schubbe wrote:
Hello,
the last parameter of VLOOKUP tells Calc if the referenced table
is sorted.
I have a Calc document (OOo 1.1.4) which contains some VLOOKUP (in
the German version SVERWEIS) functions passing 3 parameters to it.
The referenced table is unsorted. The default behaviour
Til Schubbe wrote:
* On 13.11. Andrew Douglas Pitonyak ([EMAIL PROTECTED]) muttered:
Til Schubbe wrote:
the last parameter of VLOOKUP tells Calc if the referenced table
is sorted.
I have a Calc document (OOo 1.1.4) which contains some VLOOKUP (in
the German version SVERWEIS
Noel Power wrote:
Hi All,
I've contacted Louis and he's reviewed my proposal for a new incubator
project. So now I'm asking you, the community to have a look, voice
your opinion and help get this off the ground. For a long time now its
been recognised that lack of interoperability with vba
Felix E. Klee wrote:
Uh, I forgot to mention a couple of things:
1. We're employing OO 1.1.3, soon perhaps OO 1.1.4.
I recommend the latest version
2. I do not want to store the document to disk automatically. This
should only be done manually by the user.
then you can not give it
I would have said no, it is not easily done. Are text tables counted as
a paragraph?
Gloops wrote:
Hello,
I have read somewhere that version 2.0.3 does that easily.
___
On 18th of July 2006 02:40, Mohammad Alhammouri wrote :
Hello there,
Hugo Pérez Bruno wrote:
Hi
How can I export data from a recordset in Visual Basic 6.0 to OOoCalc?
Thanks
Hugo
I see that you have had no answers..
First, you can not easily do this from VB. Your primary options are as
follows:
* Export to a format supported by Calc (such as CSV)
* Write
Joachim Lingner,
Please note that although I am subscribed to the dev list, I am not
currently subscribed to the extensions list...
-we show multiple versions of one extension or
-only show the latest version of the extension.
I think that the eclipse extension editor allows you to view
I read hundreds of messages every day. I expect to see the important
stuff close enough to the top that I do not have to scroll.
I read this from top to bottom and was highly amused; no, I laughed and
laughed and laughed...
Marco Pratesi wrote:
A: Because it messes up the order in which
Hi Cor,
I read hundreds of messages every day. I expect to see the important
stuff close enough to the top that I do not have to scroll.
Click the spacebar ...
Is this standard functionality on most email programs? It certainly
works with Thunderbird. I had never heard of such a thing
A new book relating to macros and Calc is in process and I am a
technical editor for this book. The book references Novell's code that
provides some level of support for VBA in OOo. Issues exist to integrate
Novell's code into the normal build (see
Andrew Douglas Pitonyak wrote:
A new book relating to macros and Calc is in process and I am a
technical editor for this book. The book references Novell's code that
provides some level of support for VBA in OOo. Issues exist to
integrate Novell's code into the normal build (see
http
Utomo wrote:
I am waiting and open for suggestions.
Is there somebody can help me to determine how is the performance
improvements measured ?
Utomo
I have a few comments:
Performance should be quantified and explained by the submitter. In
other words, the submitter should indicate how to
to measure how long opening a files is.
( I think judges will help decide it)
What do you think ?
Best Regards,
Utomo
-Original Message-
From: Andrew Douglas Pitonyak [mailto:[EMAIL PROTECTED]
Sent: Thursday, November 02, 2006 10:35 AM
To: dev@openoffice.org
Subject: Re: [dev] Bounty
Dyego Souza Dantas Leal wrote:
I wave a Listener in my Document return a EventObject.. i want to
intercept the event and stop the event if the user type f , it is
possible ?
In Java the listener returns the KEY typed in JTextArea , i compare
with f and call event.consume()... exists way in
Glen Hinckley wrote:
I was looking to work on base. I would like to do forms and reports.
Not a lot to go on for the question...
Perhaps this will get you started:
http://www.pitonyak.org/database/AndrewBase.odt
--
Andrew Pitonyak
My Macro Document: http://www.pitonyak.org/AndrewMacro.odt
Matthias B. wrote:
Does anyone have a suggestion for a good way to distribute data
sources to all user accounts on several machines. I want certain data
sources to be available to all users on several computers, without the
users having to do any manual registration of the data source.
The
Help with what?
shen zhao wrote:
Hi:
My name is zhaosheng, I am software developer from Beijing redflag
chinese
2000 software company, and I wanna join you guys, I need some initial
help
from you experts.
thank you very much
sincere zhaosheng
--
Andrew Pitonyak
My Macro Document:
ianmcr wrote:
Hi,
I am working on an export filter for producing accessible HTML. I first
iterate through the document and insert bookmarks at the start of each page
to indicate an automatic page break. I then iterate through the document
creating a new HTML page at each page break.
I need
Hello Gabriel,
I was surprised to see this post in the dev list (I expected the user
list) and that you did not start a new thread, but rather chose to reply
to an existing thread.
Gabriel Plana i Gavaldà wrote:
I've created a Microsoft Word 2000 document with a headline which I don't
want
Lívio Cipriano wrote:
Hi all,
What's the name of the variable in Writer that gives the total number of lines
in a document; like in Properties, Statistics?
CharacterCount, ParagraphCount, and WordCount you can get directly from
the document. Line count, however, you need to get from the
Lívio Cipriano wrote:
On 10 April 2007 03:50, Andrew Douglas Pitonyak wrote:
CharacterCount, ParagraphCount, and WordCount you can get directly from
the document.
Hi Andrew,
But in Writer File-Properties-Statistics, it gives the TOTAL Number of Lines
in a documents - after you
Ian,
I have never done this in either windows or Linux.
I know one person who has done this in a VMWare environment with Linux.
I copied the dev mailing list in case someone there knows of someone who
might have the required abilities and/or knowledge.
I can make some more queries when I
http://www.openoffice.org/issues/show_bug.cgi?id=1761
Do I understand correctly that this will be fixed in 2.3?
Brooks Golden wrote:
I am a big fan of OpenOffice and I think it is a great cause and all but
there's just one thing that really annoys me. When I'm making a text
document, I like
http://www.pitonyak.org/database/
download AndrewBase.odt
Also, check out the Base forum at the OOoForum.
bram wrote:
Hi list,
I don't know where to ask these things so forgive if this is not the
right place.
I am going to use openoffice as a filemaker alternative and have some
questions.
gaopeng wrote:
Hi , all
Would anybody tell me what's the difference between paste and paste
special when I paste somthing into OOo application ? and
why do we set the copy option(paste special and paste)
the paste special and paste option are shown , when you click Edit
menue item
Even better, will a new and improved macro recorder be implemented? I do
not remember seeing one in any road map, but I might have missed it.
Kálmán Szalai wrote:
Thank you for the information.
Are you planning to reimplement this part and make it available under
Draw/Impress?
KAMI
I am not a lawyer and I am not officially related to OOo.
But... Let me point out that people are able to sell OOo, which might
imply that you can include it with your product.
--
Andrew Pitonyak
My Macro Document: http://www.pitonyak.org/AndrewMacro.odt
My Book:
Using OOo 2.3 on Windows, I need to call a DLL from StarBasic.
The argument to the DLL is a simple array of characters. Consider a
super simple example:
Type FOO1TYPE
Dim name1 As String * 10
Dim rank1 As String * 10
End Type
Type FOO2TYPE
Dim name2 As String * 10
Dim rank2 As String *
, and send that back to OOo... Life is good!
OOo accepts Dim x As String*3, but this declares a normal string, not
a string with fixed length.
Andrew Douglas Pitonyak wrote:
Using OOo 2.3 on Windows, I need to call a DLL from StarBasic.
The argument to the DLL is a simple array of characters
[EMAIL PROTECTED] wrote:
Hello OpenOffice.org Participants! My name is Jennifer. I'm a graphic design student that would love to get involved with your quest in helping thousands by writing HOW-Tos and Tutorials. Please let me know what I should do next now that I've introduced myself.
If I understand correctly...
We start with an undesirable current state of things.
Christian Lippka - Sun Microsystems GmbH - Hamburg wrote:
in OOo you select some content, then you fire up a dialog, make
changes to 50+ settings
and hope for the best ( working undo ).
Next, a quote of
Download AndrewBase.odt
Listing 49 has a macro that demonstrates obtaining outlook addresses.
It does not, however, access the outlook object. So, it will not help
you if you wanted to manipulate outlook rather than just look at the
address book.
Geri Igou wrote:
I am trying to move a
Peter,
Although you can NOT send the document, can you create a document with
similar structure in WORD that behaves the same way, and then attach it
to a bug report?
Peter Nabbefeld wrote:
Hello!
I've got a strange word document, which I cannot correctly open
with OO.org 2.4. It has a
Dinesh Chothe wrote:
Hello,
I am developing writer based application using
java,oo sdk and netbeans.
In this application object has to travels from starting of
document up to end of document.
While moving it may come across
Andriy Rysin wrote:
Hi all,
I was just wandering if necessary level of attention is given to the
OOo crash problem (84159) - it was reported before 2.4 with target 3.x
but it seems after the bug was confirmed the interest in it was lost.
The bug basically renders OOo unusable for documents
Andriy Rysin wrote:
Andrew Douglas Pitonyak wrote:
Andriy Rysin wrote:
Hi all,
I was just wandering if necessary level of attention is given to the
OOo crash problem (84159) - it was reported before 2.4 with target
3.x but it seems after the bug was confirmed the interest in it was
lost
Pat McBride wrote:
I have experience in writing databases in dBase III and IV, and in writing
user manuals for dBase and Oracle. It's been some time since I did this
(1985 to 1991); I was also a Novell CNE from 1996 to 1998, and wrote the
MCSE exam for Windows 95 (which I failed by about 5
Andriy Rysin wrote:
I am working on a dictionary (actually about a dozen of them) and I
have only 4 main styles, e.g. MyBold, MyItalic, MyAux and MyNormal.
What I have a lot is uses of those styles: let's say I have 2
positions in one dictionary and each position may contain several
Dinesh Chothe wrote:
Hello,
I want to get current position of cursor from documents XTable or
XTextDocument
also for calc I want to get current cells position. How do I?
I am using OoSDK2.3 and java...
I believe that the view cursor has a property TextTable and
What happens if you do not load the document as hidden?
Hal Vaughan wrote:
I have a client who is using OOo 2.0 on Winodws XP as part of a Java program
I've written. I'd like to upgrade, but since my software has to install my
program and OOo -- and know where OOo is being installed to, it's
she prints a particular .odt file to that printer and then saves
the file, what happens if the program prints the file to the same printer?
Hal Vaughan wrote:
Andrew Douglas Pitonyak wrote:
What happens if you do not load the document as hidden?
That would create a serious problem
it doesnt work by passing
xSpreadsheet instead of xTextDocument.
How would I access current active cell in spreadsheet?
On Tue, Jul 8, 2008 at 5:26 PM, Andrew Douglas Pitonyak [EMAIL PROTECTED]
wrote:
Dinesh Chothe wrote:
Hello,
I want to get current position of cursor
Neither the development builds, nor the beta builds, have GUI
integration for Linux.
Will the release candidate have GUI integration?
I would like some better screen shots and instructions for an
installation article, and I would like to report an expected timeline to
the publisher.
Michael Schmidt wrote:
Furthermore we want that OOo components allow to send other users on the
messeger OOo Component features.
I do not understand this statement. Do you mean ability to send a
document to someone?
Is the vision that this will support one protocol, or many? At work, I
Primarily in C++.
Tony Glans wrote:
Hi 2008-12-01
I would like to know in what programming language(s) Open Office is written.
Why doesn't it show anywhere on techspec at www.openoffice.org
http://www.openoffice.org/ ?
[EMAIL PROTECTED] wrote:
Hello ,
You have helped me many times and now i need help again..I tried in the
previous posts to find it but i had no lack..
What i tried to do is change through java the value of a userfield..
That i have managed to do it..What is impossible is to update the field
Nguyen Vu Hung wrote:
On Sat, Dec 13, 2008 at 12:45 AM, Michael Stahl michael.st...@sun.com wrote:
On 12/12/2008 14:43, Nguyen Vu Hung wrote:
FYI,
I see a lot of can not in the file connectivity/source/resource.po.
As far as I can tell, it should be cannot.
hmm, interesting
Han Bo wrote:
Hi all,
I find a bug by an accident. That is when I filled a chat's background with a
bitmap in a CALC document, the bitmap gone after I reload the document. I
also find the bitmap which I selected in Chart Wall dialog disappeared. This
situation just happens when saved the
Gianpiero Napoli wrote:
Hi,
in an AddIn I want to store the cell position that call the function of the
addIn.
Let say that I have an AddIn in Java with the function int foo(int par0).
I want to know the name or the position of the cell that has called this
function. Is it possibile? How I can
Albert Law wrote:
Hi,
I'm looking for an OOo3 filter list similar to this one:
http://wiki.services.openoffice.org/wiki/Framework/Article/Filter/FilterList_OOo_2_1
Any ideas where I can find such a list
Dim oFilterFactory
Dim oNames
oFilterFactory =
Let me repeat back my understanding of your problem.
You have a function.
The value that the function will return changes over time based on some
external cause.
You want the function to track every cell that calls the function and
then update the value in the cell that called the function.
Frank Schönheit - Sun Microsystems Germany wrote:
Hi Rainman,
I have another ideal, it is better and safer than the last one I mentioned.
I add a conversion operator to Reference, instead of a constructor, here is it:
template class base_interface_type
inline SAL_CALL
Rainman Lee wrote:
Hi Andrew
I know that implicit conversions usually bring more side effects than
convenience. But it is not the reason that we should give all them up
I think ;)
There is no implicit conversion from std::string to const char*,
because if a string is destroyed, the pointer to
First, it is late and I am tired, so I may not be thinking clearly
Pedro wrote:
XTextViewCursor vc = xViewCursorSupplier.getViewCursor();
for (short i = 0; i 150; i++) {
vc.goRight(i, false);
Point p = (Point) vc.getPosition();
I am the author of a popular macro document for OOo. The document has
become large, and now, although I can open, edit, and save the document,
as soon as I close AndrewMacro.odt, OOo crashes.
http://qa.openoffice.org/issues/show_bug.cgi?id=104896
With Windows, there is no error text, it
On 09/08/2009 10:30 PM, Ariel Constenla-Haile wrote:
Hello Andrew,
On Tuesday 08 September 2009, 22:24, Andrew Douglas Pitonyak wrote:
I am the author of a popular macro document for OOo. The document has
become large, and now, although I can open, edit, and save the document,
as soon as I
On 09/30/2009 11:38 PM, Wei Min Teo wrote:
Hi all,
It seems that openoffice has a maximum path name of 260 chars?
However, I think the maximum path name for windows is 32,767 and file name is
260 in unicode.
Is it possible to pass in to the loadComponentFromUrl function using a
On 04/09/2010 08:49 PM, TJ Frazier wrote:
Can I get a little help from someone who knows the code, to confirm my
experimental observations? Then I can get the documentation updated,
and fix the BASIC code.
The VarType function can be used on a variant to return the type of
data therein, as
I do not know when the change was made, but, CLng used to be able to
convert negative values represented as Hex, but, not in 3.20. I last
tested in version 2.x. Here is my latest code to show this:
Sub ExampleCLngWithHex
On Error Resume Next
Dim s$, i%
Dim v()
v() = Array(HF, HFF,
On 06/14/2010 07:05 AM, Bartosz wrote:
I thought I had a patch somewhere to do some of the conversion, but I
can't find it now. I remember that I didn't go ahead with it at the time
because my first cut at it left OOo larger than it was before hand,
which was an annoying result.
Great. If
On 06/15/2010 02:55 AM, Mathias Bauer wrote:
On 14.06.2010 12:01, Caolán McNamara wrote:
A code replacement like this creates the question what shall be the goal:
- reduce memory footprint
- improve performance
- remove code duplication
- improve code quality
My primary interest is in code
On 06/17/2010 08:04 PM, George Meier wrote:
Open Folks...
I have scoured your support website and written to one of the tech people
who is available. The site doesn't come close to answering my questions and
I have gotten no response from the tech.
Here's the issue: Based on your database
On 07/07/2010 05:48 AM, Joerg Reschke wrote:
Hi,
we have to migrate a lot of MS Word documents (.doc) to OOo and we have a
problem with the empty MS Word text fields. The Writer imports these text
fields, but the value is not empty:
- MS Word displays empty text fields as ° and prints
You can
work with the documentation project to review and help with documentation
Work with the QA group to help verify bugs and similar
-
To unsubscribe, e-mail: dev-unsubscr...@openoffice.org
For additional commands,
I am updating my documentation for StarBasic, and, I found a few methods
that have me stumped for a good explanation:
RTL
I must use CompatibilityMode(True) before calling RTL.
Defined in methods.cxx. The implementaiton code is very simple:
rPar.Get( 0 )-PutObject(
can you start soffice with -norestore
On 10/04/2010 12:25 PM, Wei Min Teo wrote:
Hi all,
I'm trying to read some files programmatically with OO v2.4.x. However, as it
runs silently in the background without user input, it sometimes hangs at
some dialog boxes.
1) I can't seem to get rid
On 10/13/2010 12:43 PM, Malte Timmermann wrote:
Does it really make sense to store anything larger than USHORT, while
the SfxItemPool API is still USHORT?
I don't think so.
Feeling evil today :-)
Save all your OOo documents, better yet, close them Then Open this!
On 11/03/2010 05:31 AM, Lin CHENG wrote:
When OOo saving an existed file, I found ZipOutputStream in package module
write directly the original file. What if OOo or System crash when saving
the existed file. It's impossible to recover the file after OOo or system
restart.
My question is why not
OOo Authors are not able to release the getting started user guide
because of a bug (that I incorrectly thought was introduced with 3.3
that also exists in the development build that I installed last week).
Download a zipped copy of the master document and sub-files from here:
http://www.openoffice.org/issues/show_bug.cgi?id=115708
On 11/21/2010 03:10 PM, Andrew Douglas Pitonyak wrote:
OOo Authors are not able to release the getting started user guide
because of a bug (that I incorrectly thought was introduced with 3.3
that also exists in the development build
Off hand, this is just as likely to be a problem with the virus software
simply failing on a valid file. My recommendation is that you take the
file in question and upload it to an online virus scanning site... I
have not tested or used any of them in a while, but, here are two
possibilities
Юрий Брумштейн, I am sending this to the dev mailing list to see if they
can shed some light on this.
List,
Have VBA compatibility items been removed from OOo in version 3.3?
I do not have 3.2 to test, but, I do see that this does not function in 3.3.
On 04/17/2011 02:46 AM, Юрий Брумштейн
On 07/09/2011 01:52 AM, Shameera Rathnayaka wrote:
hi dev,
This is my problem i could delete all table in doc , but how can i
delete table in cursor position which i dont know the name and index
of that table.
I believe that the view cursor has a text table property that you can
check to
. for this
i want to select most outer table.
can anybody help me with this
*Thanks*
On Sun, Jul 10, 2011 at 7:28 PM, Andrew Douglas Pitonyak
and...@pitonyak.org mailto:and...@pitonyak.org wrote:
On 07/09/2011 01:52 AM, Shameera Rathnayaka wrote:
hi dev,
This is my problem i
95 matches
Mail list logo