Re: [libreoffice-users] Macro issue

On 10/22/2013 01:35 AM, Heena Gupta wrote: Hi guys, When i run the MS Excel macro in libre office, it runs correctly but shows the output while clicking on the cell on which output comes. Option VBASupport 1 Sub Button1_Click() Dim a As Integer Dim b As Integer Dim c As Integer Range("B1").

Re: [libreoffice-users] LO Base Sub Forms

If I remember correctly (and I have not looked at this in a while), I think that you need to link the "master and slave fields". So, if you open your form in edit mode, load the form navigator, right click on your sub-form and choose properties, navigate to the Data tab, do the values in the

Re: [libreoffice-users] [CALC] row_only and column_only cell references

On 10/12/2013 07:55 AM, Ady wrote: Hello, I've been having problems with certain type of *references* in Calc. For example, the formula "sum(1:2)" works correctly in other spreadsheet software, but it errors in Calc. I was not aware that you could do that in any product. It is not supported

Re: [libreoffice-users] Numbering multiple equation

I use the same mechanism used to number things like tables and figures, but I create a new field for my equations and then I enter them manually. On 10/06/2013 02:09 AM, fajar2 wrote: How to numbering multiple equation in libre office math. Current implementation numbered equation in libre Offi

Re: [libreoffice-users] replace normal font with superscript

When I had to do something similar, I wrote a macro :-) If you do not know much about macros, you probably need to record one, and I expect that the macro recorder is poor enough that the only real solution would be to do the first one by hand, copy the correct result to the clipboard, then record

Re: [libreoffice-users] Re: FTP Access - Can you Test a Bug

On 09/25/2013 04:06 AM, Alex Thurgood wrote: Le 24/09/2013 20:49, Joel Madero a écrit : Hi Joel, Can someone with access to ftp and using Linux test this bug out, it's been hanging and needs a tester, please comment directly on bug with results (if possible), else email me and I'll report o

Re: [libreoffice-users] FTP Access - Can you Test a Bug

/24/2013 05:42 PM, Joel Madero wrote: It would indeed be nice to get a second check with nautilus as well. If nautilus fails but dolphin works then it seems like it's NOTOURBUG. Anyone with nautilus capable of giving this a go? Best, Joel On 09/24/2013 01:53 PM, Andrew Douglas Pitonyak

Re: [libreoffice-users] Re: Libreoffice, excel macros problem

On 09/24/2013 12:12 PM, Tom wrote: Andrew Pitonyak's guide is a good in-depth guide if you need more. It might cost money but it's well worth it. Thanks for the kind words but you can download the latest updated copy for free from my web site. http://www.pitonyak.org/OOME_3_0.odt -- A

Re: [libreoffice-users] FTP Access - Can you Test a Bug

On 09/24/2013 02:49 PM, Joel Madero wrote: Hi All, Can someone with access to ftp and using Linux test this bug out, it's been hanging and needs a tester, please comment directly on bug with results (if possible), else email me and I'll report on bug. https://bugs.freedesktop.org/show_bug.c

Re: [libreoffice-users] replacing only text portions

On 09/22/2013 12:21 PM, Thomas Blasejewicz wrote: > Good evening > I am writing a book with Writer (3.6.6.2 / Windows). In connection with > this endeavor I already asked a few questions and there are more to come ... > > Well, the original is written in Japanese, about 200 pages A5 size with > 60

Re: [libreoffice-users] Security vulnerabilities

Not many to speak of, no, and you kind of need to reach a bit to worry about them: http://www.libreoffice.org/advisories/ http://www.cvedetails.com/vulnerability-list/vendor_id-11439/product_id-21008/Libreoffice-Libreoffice.html http://www.securityfocus.com/archive/1/526071 On 09/11/2013 09

Re: [libreoffice-users] Base: Automatically Open a Form?

Off hand, the only way I know to do that is to 1. write a macro that is able to open a form 2. Assign the macro to run on a document open event. There may be another way, but not of which I am aware. On 09/06/2013 05:49 PM, Tod Hopkins wrote: I am looking for a method to automatically openi

Re: [libreoffice-users] Can't print basic macro code

I ran a test with 4.1.1.1 on Fedora The previous seemed to show the Object Catalog rather than the macro itself. The final printed thing is exactly as you state. On 09/05/2013 11:31 AM, Jim Byrnes wrote: Ubuntu 12.04 LO 3.5.7.2 When I go to the built in basic ide and try to print the code for

Re: [libreoffice-users] LO Base - Check boxes not working after upgrade??

Is it possible that the form is in edit mode? As in, you are editing the control? It is a long shot guess... On 09/05/2013 04:47 AM, Ian Whitfield wrote: Hi All I use here PClinuxOS 2013 (up-to-date), My SQL 5.1.55 and have just upgraded my LO Office to 4.1.2. Everything seems to be fine EX

Re: [libreoffice-users] problem with formala inserted by macros when decimal separator is comma

This has now been verified as a bug by the developers. On 08/28/2013 11:41 AM, Mindaugas wrote: Hello, The problem is in LO 4.1 and LO4.1.1 with lt_LT locale but i think the same must be in all locales with decimal separated by comma. I want to insert formula to Calc cell by Basic macros: c

Re: [libreoffice-users] Re: problem with formala inserted by macros when decimal separator is comma

seems that you are not the first to see this bug. Consider adding yourself to the CC list. I dropped an email to the dev list to see if I can figure out who introduced the bug. https://bugs.freedesktop.org/show_bug.cgi?id=67836 On 08/29/2013 10:30 PM, Andrew Douglas Pitonyak wrote: Thank

Re: [libreoffice-users] Re: problem with formala inserted by macros when decimal separator is comma

Thank you very much, This is exactly what I wanted to know. I was not able to run that test myself. On 08/29/2013 06:21 AM, Mindaugas wrote: In 4.0 the properties Formula and FormulaLocal give the expected result: cell.Formula = "=2.1*2"=> 4,2 cell.Formula = "=2,1*2"=> #NAME? cell

Re: [libreoffice-users] problem with formala inserted by macros when decimal separator is comma

I am not properly set to test this, but, can you test the following in older and newer LO? cell.FormulaLocal = "=2,1*2" cell.FormulaLocal = "=2.1*2" I am a very unhappy about that I think. That is a pretty major change in behavior. I had documented it as follows: When setting a cell’s formu

Re: [libreoffice-users] LibreOffice paragraph styles exported to other software/formats?

And here I thought that the word inch was another name for this symbol " You know, because people write 1" rather than 1 inch On 08/27/2013 07:57 AM, Virgil Arrington wrote: A unit of measurement in what is commonly known as the “English” system. Virgil -Original Message- From: Tom

Re: [libreoffice-users] how to save a file with security password

On 08/21/2013 01:25 PM, Gordon Burgess-Parker wrote: On 15/08/13 05:58, Andrew Douglas Pitonyak wrote: I thought that passwords were broken in the current release I was unable to open my existing password protected documents with the latest release. Removed it and installed a previous

Re: [libreoffice-users] Old or new bug in Calc Save As XSLX file

figuring this our for me! On 08/18/2013 01:35 PM, Andrew Douglas Pitonyak wrote: I generated a simple ODS document that uses HLOOKUP. I can save this document as an ODS or an XLS document, but not as an XLSX document. Can someone verify this bug in any version other than the latest release candidate

[libreoffice-users] Old or new bug in Calc Save As XSLX file

I generated a simple ODS document that uses HLOOKUP. I can save this document as an ODS or an XLS document, but not as an XLSX document. Can someone verify this bug in any version other than the latest release candidate 4.1.1.1 https://www.libreoffice.org/bugzilla/show_bug.cgi?id=68242 You ca

Re: [libreoffice-users] Can't find setting

There are mixed opinions on what to do while using a computer. In theory, I thought that the computer was assumed to do the spacing so you need not add two spaces. This is especially true if you use a layout where extra spacing is used to make proportional spacing look good. In HTML, extra spa

Re: [libreoffice-users] shifting focus to licencing

us to licencing Nino Novak wrote: Am 14.08.2013 18:39, schrieb Dave Barton: Andrew Douglas Pitonyak wrote: On 08/13/2013 02:32 AM, Dave Barton wrote: 1. http://www.oooforum.org The independent "unofficial" one Jim was referring to. For reasons nobody has been able to explain, the

Re: [libreoffice-users] Re: connecting to oooforum.org

On 08/14/2013 06:42 PM, Mirosław Zalewski wrote: On 14/08/2013 at 23:48, Andrew Douglas Pitonyak wrote: I am not aware of any way to scrape the content, perhaps someone more talented than I would know how to do that. Unfortunately, under some jurisdictions, creating backup copy of remote

Re: [libreoffice-users] LO WRITER BASIC: insert an image, put a drawing-text on top and jump to next page

I believe that there are examples of inserting an image AndrewMacro.odt and probably also OOME (also available from my web site). Does this at least get you started? You stated that you were pulling data from a DB, how do you get your data from your database? On 08/15/2013 05:48 AM, Alain Va

Re: [libreoffice-users] how to save a file with security password

On 08/15/2013 01:27 AM, Brian Barker wrote: At 00:58 15/08/2013 -0400, Andrew Douglas Pitonyak wrote: I thought that passwords were broken in the current release I was unable to open my existing password protected documents with the latest release. Removed it and installed a previous

Re: [libreoffice-users] how to save a file with security password

On 08/14/2013 08:12 PM, Brian Barker wrote: At 20:24 14/08/2013 +, Farrukh Munir wrote: ... I could not find the way to put a password to my created document for security purpose. Will you please guide me as to how I can solve this problem? As has already been explained, when you use Fil

Re: [libreoffice-users] Re: connecting to oooforum.org

On 08/14/2013 12:39 PM, Dave Barton wrote: Andrew Douglas Pitonyak wrote: On 08/13/2013 02:32 AM, Dave Barton wrote: 1. http://www.oooforum.org The independent "unofficial" one Jim was referring to. For reasons nobody has been able to explain, their server is at best unreliable and

Re: [libreoffice-users] Re: Including code example in documents

On 08/12/2013 12:44 PM, Jim Byrnes wrote: On 08/12/2013 09:04 AM, Kracked_P_P---webmaster wrote: If none of the suggestions you have received already work for you. You might want to look at Andrew Pitonyak's book [1]. It has syntax highlighted basic code. I don't know if you can tell how he

Re: [libreoffice-users] Re: Including code example in documents

On 08/11/2013 09:22 PM, aihaike wrote: Hey Miguel, thank you for you reply. This the kind of macro I need but it does not seem to work with LibreOffice 4 unfortunately. I think I'm going to make a snapshot of my codes and include them as a picture. Éric. I use it in LO 4 all the

Re: [libreoffice-users] Re: connecting to oooforum.org

On 08/13/2013 06:38 AM, Tom Davies wrote: Hi :) If it is a completely independant forum and one that is owned by the community could we just copy it and host on TDF or LO servers? Alternatively might they be in a better position to ask Apache to host it or donate a better server to them? or

Re: [libreoffice-users] Re: connecting to oooforum.org

On 08/13/2013 02:32 AM, Dave Barton wrote: 1. http://www.oooforum.org The independent "unofficial" one Jim was referring to. For reasons nobody has been able to explain, their server is at best unreliable and frequently times out. oooforum was setup and is controlled by a single very busy person

Re: [libreoffice-users] Re: How to Find Dangling Cross References in Writer

On 08/12/2013 12:42 PM, Sina Momken wrote: On 08/12/2013 02:53 PM, Adam Tauno Williams wrote: On Fri, 2013-08-09 at 07:25 +1000, Tim Lloyd wrote: Hi, Probably not the solution you were hunting for but I create a PDF and search for the offending text. It gets the job done in a roundabout sort o

[libreoffice-users] Can LO still read password protected documents?

Silly question, can the latest version of LO read password protected documents? I installed the latest on one computer and I was no longer able to read any of my password protected documents. Rolled back one version and I was able to read my documents again. Is it just me? -- Andrew Pitonyak

Re: [libreoffice-users] How to Find Dangling Cross References in Writer

I suppose that if you are willing to do that, you could also just write a macro that looks for the "error" text. Even in a macro, it is not always clear to me that a reference is bad. Even worse, sometimes the display text does not update to indicate that the reference is broken - LO is doing t

Re: [libreoffice-users] Base: In basic, how do you open a form to a particular record number?

https://wiki.documentfoundation.org/images/5/50/BH40-BaseHandbook.odt http://www.baseprogramming.com/OOBasicDatabaseDev.pdf http://www.pitonyak.org/database/ http://www.pitonyak.org/database/AndrewBase.odt http://www.pitonyak.org/oo.php These links just provide some ideas of other places to loo

Re: [libreoffice-users] Re: Base & PostgreSQL Transactions

On 07/22/2013 02:48 AM, Alex Thurgood wrote: Le 19/07/2013 22:31, Don Parris a écrit : Hi Don, One possible way is to set up your form (which after all, is only a Writer or Calc document) as a dummy interface that is not bound to any data fields, and then use Basic to manage the data entered

Re: [libreoffice-users] Base & PostgreSQL Transactions

m is more than I really have time for right now. If & when I do figure it out, I'll have to write a tutorial on it for sure. Regards, Don On Fri, Jul 19, 2013 at 8:56 AM, Andrew Douglas Pitonyak < and...@pitonyak.org> wrote: The ODF Authors are working on a DB guide, I do not

Re: [libreoffice-users] Base & PostgreSQL Transactions

The ODF Authors are working on a DB guide, I do not know the current state of it, have you looked for it (or at it)? https://wiki.documentfoundation.org/images/5/50/BH40-BaseHandbook.odt These may also be of interest: http://wiki.openoffice.org/wiki/Documentation/DevGuide/Database/Using_DBMS_Fe

Re: [libreoffice-users] Help for Calc Macros

al.libreoffice.org> Note that then you will receive all the emails for the list. Every email for the list provides instructions as to how unsubscribe if you receive too many email messages * * * * ***(**HAROLD* *)*** On 7/15/2013 5:34 PM, - Andrew Douglas Pitonyak wrote: Mr. Ek, I recommend

Re: [libreoffice-users] Fwd: Help for Calc Macros

Mr. Ek, I recommend that you subscribe to the user's mailing list and ask there; Jean forwarded your request to that list already. I am responding to the list and using CC for you in case you are not already subscribed. There are numerous materials available related to macro programming, in

Re: [libreoffice-users] Re: Base DB Connections

Very Nice! On 07/10/2013 09:08 AM, Marion & Noel Lodge wrote: Hi Mark, Here is the code - -- Andrew Pitonyak My Macro Document: http://www.pitonyak.org/AndrewMacro.odt Info: http://www.pitonyak.org/oo.php -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http:

Re: [libreoffice-users] Liber office help with Excel library

On 07/10/2013 05:21 AM, ANNADURAI V. wrote: Dear sir, Thanking you for your product of liber office. Previously i am using visual basic 6 and i used microsoft Excel 11.0 object library in my machine. Now i am using liber office instead of Microsoft office. When running by VB6 appications, my

Re: [libreoffice-users] [base] Writing form trigger macros to modify other fields?

On 06/30/2013 04:06 PM, David M. Karr wrote: Using OpenOffice/LibreOffice I've been building a small database with a form. I'm now at the point where I have two fields (radio button pair and date field) that are somewhat connected. When I set the radio button to "No", I should set the date f

Re: [libreoffice-users] close application/document

(loading time and others). Right now, the makros are doing exactly what I want them to do. Yours Walther the Am Freitag, 21. Juni 2013 schrieb Andrew Douglas Pitonyak: Off hand, it sounds like a bug... If I close a document from the GUI, it opens the desktop thing. I wonder why a macro works

Re: [libreoffice-users] close application/document

Off hand, it sounds like a bug... If I close a document from the GUI, it opens the desktop thing. I wonder why a macro works differently. This is probably due to interaction between the macro infrastructure and LO, but I am only guessing. If you open a bug against it, indicate that here and I

Re: [libreoffice-users] save state

This is how I do it in Basic oDoc.setModified(True) On 06/19/2013 09:06 AM, Vieri wrote: Hi, My java macro is trying to make an odt file "with the SAVE button enabled" (not grayed out). What's the best way to do this? I'm trying a hack such as inserting a space at end of file and removing i

Re: [libreoffice-users] create custom macro within share location (program files)

Openoffice stores individual macros in modules. Modules are stored in libraries, and libraries are stored in macro containers. Three "things" can be macro containers, documents, your user space, and one that is global to OpenOffice. It sounds like you desire to add a macro that is global to Op

Re: [libreoffice-users] Re: LibreOffice API

On 06/01/2013 07:18 AM, Johnny Rosenberg wrote: 2013/6/1 Luuk : On 01-06-2013 00:12, Bill Greenfield wrote: Where can I find information about the Methods and Properties of LibreOffice API? -- View this message in context: http://nabble.documentfoundation.org/LibreOffice-API-tp4059011.html

Re: [libreoffice-users] deploy java macro with document

On 05/16/2013 03:03 AM, Vieri wrote: --- On Wed, 5/15/13, Andrew Douglas Pitonyak wrote: If you do make this work, I am interested to hear about it. Hi, It actually works but unpacking/repacking the zip file with your jar isn't enough. You will get a "general I/O error".

Re: [libreoffice-users] deploy java macro with document

I ran out of time, but this might be of interest http://www.mail-archive.com/dev@api.openoffice.org/msg08867.html http://www.openoffice.org/api/docs/common/ref/com/sun/star/embed/Storage.html http://www.openoffice.org/api/docs/common/ref/com/sun/star/embed/StorageFactory.html Hope this helps.

Re: [libreoffice-users] deploy java macro with document

On 05/15/2013 05:25 AM, Vieri wrote: Hi, I'd like to deploy a compiled Java macro with an ODT document. Can you do that? You can do this with JavaScript, but Java, really? I had no idea. According to http://wiki.openoffice.org/wiki/Documentation/DevGuide/Scripting/Writing_Macros: " If you

Re: [libreoffice-users] How to center a pasted drawing?

On 05/13/2013 03:23 AM, Tom Davies wrote: Hi :) "If it works. Use it" as Ensign Harry Kim said. I usually find it's better to Anchor "to page" rather than the default "to paragraph" although each seems to have scenarios that suit them better than the rest and all of them are plenty good enoug

Re: [libreoffice-users] How to center a pasted drawing?

On 05/12/2013 09:38 PM, William Drago wrote: ...I can anchor the image as character, but as soon as I select the image to center it the text object menu disappears and the image object menu replaces it. If I use Format from the menu bar the expected options for alignment are gone. You place

Re: [libreoffice-users] How to center a pasted drawing?

I always anchor the image as character, then it can be manipulated as a character (so just center it as you would a line of text). On 05/12/2013 12:27 PM, William Drago wrote: All, When I paste a drawing into writer there are no options for centering it left-right on the page. Surely there mus

Re: [libreoffice-users] override the default SAVE action so a custom macro can handle it

On 05/12/2013 06:42 AM, Vieri wrote: Hi, I'd like to override the SAVE toolbar button, the FIle/save(save as) menu items and the X (close) on the top right corner of the window. In other words, I'd like a custom macro to be executed whenever a user wants to either save or exit. This macro wil

Re: [libreoffice-users] ”Artifacts” in OpenOffice and LibreOffice

I have had subtle redraw issues with OO off and on, and I always blamed it on an interaction between applications and the video drivers. Realize that I use nVidia video cards on 64-bit Fedora using the proprietary video drivers. What I saw was not remotely as bad. Admittedly, when I tried out

Re: [libreoffice-users] gettextfields

Umm, it looks like I was a few days late and you already solved your issue, so no need to send me a copy of the document :-) On 05/10/2013 12:38 AM, Andrew Douglas Pitonyak wrote: The problem is probably because these are input fields in a form. Either that, or it is because the fields are

Re: [libreoffice-users] gettextfields

: " & x.Text Next End Sub Does this help in anyway? Iain On Wednesday 08 May 2013 01:50:02 Vieri wrote: --- On Tue, 5/7/13, Vieri wrote: --- On Mon, 5/6/13, Andrew Douglas Pitonyak wrote: On 05/06/2013 05:21 AM, Vieri wrote: Hi, I have an odt writer document with 2

Re: [libreoffice-users] gettextfields

text fields, that is sufficient (in other words, you can remove all the text that you like). On 05/07/2013 03:12 AM, Vieri wrote: --- On Mon, 5/6/13, Andrew Douglas Pitonyak wrote: On 05/06/2013 05:21 AM, Vieri wrote: Hi, I have an odt writer document with 2 input text fields (added with the

Re: [libreoffice-users] gettextfields

On 05/06/2013 05:21 AM, Vieri wrote: Hi, I have an odt writer document with 2 input text fields (added with the form designer toolbar). I manually type text into one of the fields. I copy/pasted a macro to see if I could grab the text within the input field but haven't had any luck. This is

Re: [libreoffice-users] Odd behavior using DATE() function in calc

On 05/02/2013 09:52 PM, vsharris wrote: I have a spreadsheet with three columns: year, month, day. In the 4th column I use the DATE() function to create a date from these columns. It works fine if there are valid data, but if the month and day column are empty, the results are surprising. For

Re: [libreoffice-users] Re: Serious application development with LibreOffice and LibreOffice Basic

On 05/02/2013 12:47 PM, Alexander Thurgood wrote: I seriously doubt that using LO Basic, you would be able to attain a similar goal in any meaningful timeframe and with decent performance. However, using another language via one of the UNO bindings might be a more viable (if somewhat daunting)

Re: [libreoffice-users] Re: Crashing OOo Creating Dialogs in the IDE

On 05/01/2013 09:25 AM, V Stuart Foote wrote: Andrew, Here is the link to download prior versions libreoffice/old . With a couple of exceptions the x.x.x.2 are the rc2 that become final for each build. So do you think there was

Re: [libreoffice-users] Crashing OOo Creating Dialogs in the IDE

Thank you Johnny Rosenberg for pointing out how I can download the stable version rather than version 4. Not sure how I missed that. On 05/01/2013 08:40 AM, Andrew Douglas Pitonyak wrote: I was editing my book on OpenOffice macros using LO 4.0.2.2 yesterday. I am updating the section on

[libreoffice-users] Crashing OOo Creating Dialogs in the IDE

I was editing my book on OpenOffice macros using LO 4.0.2.2 yesterday. I am updating the section on Dialogs. While attempting to make simple updates to a dialog (change name, update properties, add button, change button properties), LO crashed. This occurred four times in a row, so I starte

Re: [libreoffice-users] Using UNO API

From: Adriam Delgado Rivero To: libre Sent: Sunday, 28 April 2013, 1:25 Subject: [libreoffice-users] Using UNO API Using UNO API for java and charge a template that contains a table Did not really follow that there is a template that contains a

Re: [libreoffice-users] Printing speed is glacial for large file

Have you attempted anything in particular to see if it allows for a speed improvement? For example: 1. Check on memory usage. How high is it? Are you running out of memory? 2. Change graphics settings: Tools > Options > LibreOffice > Memory Then try increasing the memory for things such as g

Re: [libreoffice-users] Changing The Mouse Cursor to an HourGlass

Read section "5.21. Changing The Mouse Cursor" in AndrewMacro.odt, which discusses this topic. It begins as follows: The quick answer is: This is not supported. A desire to change the mouse cursor sparked an interesting discussion that I took the time to follow but I did not test. I have edit

Re: [libreoffice-users] Macros don't run

Does that mean that you have solved your problem / answered your own question? On 03/07/2013 08:39 AM, Malcolm Moore wrote: I think I may have sussed this one Ta M _ From: Malcolm Moore [mailto:st-malcolm.mo...@whsg.info] To: users@global.libreoffice.org Sent: Thu, 07 Mar 2013 12:18

Re: [libreoffice-users] oooforum.org

was causing it problems. On 02/25/2013 07:06 PM, Hal Vaughan wrote: Wouldn't it be possible to write a Perl screen scraper and spider through it? Or would that be a copyright issue? Hal On Feb 25, 2013, at 7:03 PM, Andrew Douglas Pitonyak wrote: Help and resources have been offered

Re: [libreoffice-users] oooforum.org

Help and resources have been offered, but it is currently under sole ownership by someone that may not let anyone else into his playground and will not allow it to move into one not controlled by him. So, unless he has a change of heart, it is doomed to die unless the current owner (Ed) decid

Re: [libreoffice-users] Is LO BASIC Limited to Only 1 Dialog Box at a Time?

On 02/25/2013 01:52 PM, Hal Vaughan wrote: I've been experimenting because I want to write a sticky-note program that will allow a user to write sticky notes that accompany a document. When you switch from one document window to another, the notes from the 1st would close and the notes from

Re: [libreoffice-users] oooforum.org

On 02/24/2013 10:17 PM, Tim Lloyd wrote: I am just flicking through the LO4.0 "getting started" guide and there is a reference to http://www.oooforum.org/. When I click on that link (fedora/firefox/seamonkey) the browser just sits there and eventually times out. Is this address still valid?

Re: [libreoffice-users] Going to an "OnExit' Routine On Dialog Button Event

On 02/23/2013 03:24 AM, Hal Vaughan wrote: I have a macro in LO BASIC that sets up a dialog, then, instead of executing it, I do: oDialog.setVisible(TRUE) This dialog box contains a progress bar and, while testing it, I realized it's frustrating for longer documents to have a progress bar an

Re: [libreoffice-users] Save as doc crashes LO

On 02/13/2013 02:56 PM, steveedmonds wrote: Hi. Saving a writer document as .doc crashes my LO on OpenSuse. Could someone please try on 4.0 and if it persists I will file a bug. perf_calc_translations.odt Cheers, Ste

Re: [libreoffice-users] irritating problem 4.0

On 02/13/2013 01:16 AM, Tim Lloyd wrote: Hi, created a FAQ for myself in Fedora 16 using LO3.6. When I upgraded to Fedora 18 I was also using 3.6. I really can't remember but I would say the version of LO came from the Fedora repository (it isn't installed by default in F18). It was for me.

Re: Fwd: [libreoffice-users] Value and Date function in Macro

ries if not possible. I'm not asking someone to do it for me, more like "tutor me when you have time" to get the code up to snuff. Thanks for everyone's help up to date, much help. Best Regards, Joel On Sun, Feb 10, 2013 at 9:02 PM, Andrew Douglas Pitonyak < and...@pi

Re: [libreoffice-users] MS Excel file macros cause infinite loop of errors

LO is not macro compatible with MS Office products. If it is a VBA macro meant for use with Excel, the macro is not expected to work with LO. In some trivial cases, it may just happen to work, but that is the exception (in my experience), not the rule. On 02/11/2013 12:52 PM, Todd E. Moore

Re: [libreoffice-users] Can someone verify this writer bug?

Tested and seen in 3.6. On 02/11/2013 04:15 PM, Joel Madero wrote: Hi All, Can someone take a look at this one, try to reproduce, if you can reproduce, mind leaving a comment on it? https://bugs.freedesktop.org/show_bug.cgi?id=60154 60154 Li

Re: Fwd: [libreoffice-users] Value and Date function in Macro

On 02/10/2013 04:49 AM, Johnny Rosenberg wrote: Oh no, I did it again! I sent yet another reply directly to the original poster. I feel your pain! :-) -- Andrew Pitonyak My Macro Document: http://www.pitonyak.org/AndrewMacro.odt Info: http://www.pitonyak.org/oo.php -- For unsubscribe instru

Re: [libreoffice-users] Re: Value and Date function in Macro

On 02/09/2013 02:21 AM, Alex Thurgood wrote: On 02/08/2013 11:15 PM, Joel Madero wrote: Hi Joel, I have some vague recollection that the Date function in Calc (i.e. the one used when entering manually) and the Date function in Basic are not the same... You could always see whether any of the

Re: [libreoffice-users] Value and Date function in Macro

On 02/08/2013 05:15 PM, Joel Madero wrote: Hi All, I have a macro setup that can easily do the following: pasteValue = mid(currentCellValue,1,4) What is the format of "currentCellValue"? You grab the first four characters in your example above? Your code is dependent on how it is formatted.

Re: [libreoffice-users] Macro to Convert Date in Text Format to Date in Date Format (Spreadsheet)

On 01/31/2013 11:08 PM, Joel Madero wrote: Hi All, I have a macro that converts QIF files to a spreadsheet. I have a few things left to do and one of these is that the column for dates are currently in text format: "dd.mm." I want to convert this to a date format through a macro. Note th

Re: [libreoffice-users] - novice question about scalc and C++ uno objects

sdk/include. Is there any other dir I should look in ? Thanks Neeraj -Original Message- From: Andrew Douglas Pitonyak [mailto:and...@pitonyak.org] Sent: Tuesday, November 13, 2012 12:20 AM To: users@global.libreoffice.org Subject: Re: [libreoffice-users] - novice question about scalc and C++ uno o

Re: [libreoffice-users] - novice question about scalc and C++ uno objects

On 11/12/2012 06:28 PM, Rai, Neeraj wrote: Hi , I am trying to learn about UNO objects and how to remotely update scalc data. I have looked at Scalc.java and would like to convert it to c++. What is the best way to go about it and are there cpp examples publicly available ? The cpp examples th

Re: [libreoffice-users] Re: how to crack a PW in LO?

On 10/16/2012 10:07 PM, rost52 wrote: Dennis, When I am reading your long and excellent explanation, I wonder again how some PW removing tools, which offer a demo with opening the file or showing the PW removed, can claim that the file could be open within a few seconds to a minute? I vaguely

Re: [libreoffice-users] Re: how to crack a PW in LO?

I wrote my own password cracker for OOo files, but as you found, they run for a very long time. I did it just to see how well it would, or would not work. Unless you have a lot of time to kill (days, weeks, months, etc), you are much better off not forgetting your password. -- For unsubscr

Re: [libreoffice-users] BASIC script how to read/write system files, like /dev/null in Linux

If you have trouble with these methods, then check out the SimpleFileAccess service. I have not tried it, but I am interested to know if it works. http://www.openoffice.org/api/docs/common/ref/com/sun/star/io/module-ix.html http://www.openoffice.org/udk/common/man/concept/streams.html On 10/1

Re: [libreoffice-users] Re: Find and replace graphics

It all seems so difficult.. If you have a write document, run this macro and remove ALL graphic objects Sub RemoveAllGraphics Dim i As Integer Dim oGraphic If ThisComponent.GraphicObjects.getCount() = 0 Then Exit Sub End If For i = ThisComponent.GraphicObjects.getCount() - 1

Re: [libreoffice-users] Re: How to determine FilterName of loaded document?

On 08/29/2012 12:59 PM, Andreas Säger wrote: Am 29.08.2012 17:00, Walther Koehler wrote: Hi, how to find out the FilterName of a loaded document? (other than try to "save under" and look what is marked) I would like to find it by a Basic Makro, but didnt find a hint even in Andrew Pitonyaks

Re: [libreoffice-users] Re: Reply settings on this list have changed

On 08/16/2012 03:11 AM, Tom Davies wrote: Hi :) Bottom posting is a good way to alienate most of the target I strongly dislike bottom posting Just saying... If it were obviously the correct and logical choice, then I expect more people would tend towards it naturally. I usually follow

Re: [libreoffice-users] Reply settings on this list have changed

I would bet that you have used a Linux based machine. and you just never knew it. Seems like Linux is everywhere. Seems that I own a DVR, a fancy Panasonic DVD player, and a phone that all seem to be based on Linux. It is everywhere, we just don't know it! :-) On 08/13/2012 07:55 PM, ann

Re: [libreoffice-users] complicating Reply settings ...

This was a long running discussion before the change was made. Off hand, I would say that the sides were roughly split and, as with many things with LO, many of the people seemed to have pretty strong opinions. I expect that in the grand scheme of things, we won't see any serious problems re

Re: [libreoffice-users] Forcing a paragraph onto odd numbered pages

On 08/01/2012 10:48 PM, Brian Barker wrote: At 09:47 01/08/2012 -0400, Andrew Douglas Pitonyak wrote: I do this with page styles. I have a style called "chapter_first_page", which is always a left page. Is it worth mentioning that this is the opposite of the usual convention?

Re: [libreoffice-users] Forcing a paragraph onto odd numbered pages

On 08/01/2012 09:55 AM, rob wood wrote: I can't seem to see how to get a paragraph (or page) to only be on odd (or even) pages If your primary concern is that a chapter starts on a "left" or "right" page I do this with page styles. I have a style called "chapter_first_page", which is alw

Re: [libreoffice-users] Forcing a paragraph onto odd numbered pages

On 08/01/2012 09:37 AM, rob wood wrote: Hi, I can't seem to see how to get a paragraph (or page) to only be on odd (or even) pages i.e each chapter should start on an odd page, if the page is even, it needs to insert a page break before the style starts so it becomes an odd numbered page. Is t

Re: [libreoffice-users] Searching for ”empty” cell (LibreOffice BASIC macro)

You may also try using the cell range and calling GetDataArray() to get all of the data including numbers and strings. If you are simply running through about 2000 cells, this should be very fast, especially if you know that the cells are filled sequentially because then you can use a binary

Re: [libreoffice-users] Re: Correct Syntax to address a table or form field in Base's Basic

You may find some working examples in here: http://www.pitonyak.org/database/AndrewBase.odt On 07/17/2012 06:08 PM, Andreas Säger wrote: RTFM -- View this message in context: http://nabble.documentfoundation.org/Correct-Syntax-to-address-a-table-or-form-field-in-Base-s-Basic-tp3996103p39961

<    1   2   3   4   >