[libreoffice-users] Can you please associate my extension to me?

2020-09-30 Thread Andrew Douglas Pitonyak
Is anyone able to associate this extension to me: https://extensions.libreoffice.org/en/extensions/show/code-colorizer-formatter If you cannot associate the extension to "and...@pitonyak.org", can I email the latest version for upload. -- Andrew Pitonyak My Macro Document:

[libreoffice-users] Bug selecting text using the API

2019-10-20 Thread Andrew Douglas Pitonyak
Tested using LO 6.2.0.3 on Fedora Linux. I wanted to find all instances of Italic text using the API and select that text. I created a simple document with four areas that were Italic. I used the following macro and, although FindAll does return all italic text, it only selects the last

Re: [libreoffice-users] Base - automatically running a macro on form opening

2016-02-12 Thread Andrew Douglas Pitonyak
Well, for sure you can fire a macro when a document opens. I expect it is the same for a form, but I have not tried it. Try this: Tools > Customize > Events You can set macros for Document loading finished (for example). There is a drop-down in the bottom for "Save in". Set this to the form,

Re: [libreoffice-users] Save UNO state?

2015-08-19 Thread Andrew Douglas Pitonyak
Andrew Douglas Pitonyak and...@pitonyak.org: On 08/16/2015 03:53 PM, Hi-Angel wrote: Often it is really hard to figure out for how to do something in UNO unless someone already did it, and left a description on the Internet. Even in the presence of MRI. So I'm wondering: perhaps is there a way

Re: [libreoffice-users] OEditModel - set focus pre-select all text?

2015-06-08 Thread Andrew Douglas Pitonyak
Sorry for the late reply, but, does this help https://forum.openoffice.org/en/forum/viewtopic.php?f=45t=20279 On 05/31/2015 07:28 AM, JTeagle wrote: If this is not the best list for this question, please let me know of a more appropriate one. I'm using a few simple controls on a Calc sheet,

Re: [libreoffice-users] Can't change font color in LO 4.3.3 (Linux)

2015-05-14 Thread Andrew Douglas Pitonyak
No problem with 4.4.2.2 on Fedora, not back leveling to test. Are you using the standard version or a distribution specific version? On 05/14/2015 11:19 PM, minhsien0330 wrote: Hi~ I found I can not change font color in LO 4.3.3 under Linux. The procedure is: (1) Open Writer or Calc. (2) Type

Re: [libreoffice-users] [LibreOffice Writer] Table with alternat[]e row color

2015-04-20 Thread Andrew Douglas Pitonyak
On 04/19/2015 07:22 PM, Brian Barker wrote: At 14:10 15/04/2015 +0200, Alain Ronly wrote: I'm looking for a simple and automatic way how to tell to my tables in a writer document, to be formatted with alternat[]e rows color for example even rows will be blue in the background and odd rows

[libreoffice-users] Open File dialog is too large

2015-03-07 Thread Andrew Douglas Pitonyak
I am running Fedora Linux (64-bit). I use LO 4.4.1.2 (official release). I have two monitors I use LO dialogs for open / close. When I choose file open, the dialog is about 1.5 screens wide and it will NOT allow me to resize the dialog to make it narrower. Anyone else see this? I saw it when I

[libreoffice-users] Search Calc Notes from GUI and API (macros)

2015-03-05 Thread Andrew Douglas Pitonyak
Sergey, I am copying you so that you know that I am more widely distributing your question. Is it possible to search a Calc document and find comments? I tried this recently using LO 4.4.1.2, and I cannot find text in a comment using the GUI. To my knowledge this search has always

Re: [libreoffice-users] Syntax highlighting

2015-03-04 Thread Andrew Douglas Pitonyak
On 03/04/2015 07:48 AM, Mohsen Pahlevanzadeh wrote: body p { margin-bottom: 0cm; margin-top: 0pt; }Dear All,I need to export my articles as EPUB, My context of my odt, contais of code , so i need to syntax highlighting, How can i enable syntax highlighting in odt ?--Regards,Mohsen

Re: [libreoffice-users] When will LO have MS macro and function support?

2015-02-09 Thread Andrew Douglas Pitonyak
On 02/09/2015 01:44 PM, Thisis theone wrote: Hello, if we open up an example MS excel file, the macros and functions are not 100% working in LibreOffice. When will LibreOffice have 100% MS macro and function support? Or this is something that it's not worth it to do in LibreOffice? IMHO if

Re: [libreoffice-users] Re: LinuxQuestions.org's Office Suite of the Year: LibreOffice!

2015-02-06 Thread Andrew Douglas Pitonyak
On 02/06/2015 04:59 PM, jonathon wrote: -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 06/02/15 09:09, Paul wrote: Surely running MSO under Wine on Linux is a valid choice? Not one I would choose, for sure, but a choice that should be on the poll none the less? The idea is to highlight

Re: [libreoffice-users] Re: Repository with LibreOffice 4.4 for Fedora 21+?

2015-02-05 Thread Andrew Douglas Pitonyak
On 02/05/2015 07:07 AM, Tom Davies wrote: Hi :) I think you can usually just install over the top to wipe the previous version. However on an extremely rare occasion that might not work in which case you might need to remove/uninstall everything and then reinstall the newer version. however

Re: [libreoffice-users] syntax hilighter for writer

2015-01-28 Thread Andrew Douglas Pitonyak
what do you want to syntax highlight? On 01/28/2015 01:39 AM, m_pahlevanzadeh wrote: Dear All, I have been searhed for syntax highliter, But i found a set of under milestone 4.x , Do you know compatiable with milestone 4.x? --Regrads Mohsen -- View this message in context:

Re: [libreoffice-users] Shouldn't it be more secure to by default disable macro support in LibreOffice?

2015-01-24 Thread Andrew Douglas Pitonyak
Although yes, not allowing macros of any sort to run would be more secure, the default installation is to only allow macros from trusted sources and unsigned macros are disabled. So, macros signed by a trusted source are allowed and nothing else. This includes macros included with LO that may

Re: [libreoffice-users] Program Abort - Service Manager not available

2015-01-04 Thread Andrew Douglas Pitonyak
Does the problem go away if you completely exist LO and then rename your LO user profile? On 01/04/2015 01:03 AM, Dr. Jim Ishler wrote: When I try to start LibrOffice I get an error that the program cannot be started. It says the service manager is not available. Premature end of

Re: [libreoffice-users] BASIC StrComp and tricky Unicode for example) SOLVED

2015-01-03 Thread Andrew Douglas Pitonyak
On 01/03/2015 01:00 PM, libreoffice-ml.mbou...@spamgourmet.com wrote: Andrew Douglas Pitonyak wrote: Yep, it pulls the value from the application language settings, so that if I set that to Turkish for the application, I can test in Turkish. Print StrComp(ı, I, 0) ' compare Turkish

Re: [libreoffice-users] BASIC StrComp and tricky Unicode (Turkish, for example) SOLVED

2015-01-02 Thread Andrew Douglas Pitonyak
Zeki, I think that I managed to sort this out! I resorted to reading the source code... The short answer is that the application's language setting determines how the compare is done for a case-insensitive compare! Also, based on what I read in the source code, I figured out how the locale

[libreoffice-users] BASIC StrComp and tricky Unicode (Turkish, for example)

2015-01-01 Thread Andrew Douglas Pitonyak
I am updating some of my documentation on using BASIC with LO and I wondered if case-sensitive comparisons are done with locale specific information. I am in the US with ENGLISH locale, and I am not certain how easily I can test this sort of thing, but I expect that a simple compare such as

Re: [libreoffice-users] BASIC StrComp and tricky Unicode (Turkish, for example)

2015-01-01 Thread Andrew Douglas Pitonyak
On 01/01/2015 02:16 PM, Luuk wrote: On 1-1-2015 18:51, Andrew Douglas Pitonyak wrote: I am updating some of my documentation on using BASIC with LO and I wondered if case-sensitive comparisons are done with locale specific information. I am in the US with ENGLISH locale, and I am not certain

Re: [libreoffice-users] Re: Macro to open form + pass on value from current form

2014-12-18 Thread Andrew Douglas Pitonyak
And, when you can solve a problem without a macro, that is generally the better path :-) On 12/17/2014 01:02 PM, Andreas Säger wrote: Am 17.12.2014 um 03:05 schrieb Joel Madero: Hi All, I have a form that has bookID as a unique key. I want to have a button that is to open a second form and

Re: [libreoffice-users] Adequate API

2014-12-14 Thread Andrew Douglas Pitonyak
On 12/13/2014 06:22 PM, RAM B wrote: Why there is no adequate API for so long time to program office suite? OO:=CreateOleObject('com.sun.star.ServiceManager'); ddd:=oo.createinstance('com.sun.star.frame.Desktop'); varr := VarArrayCreate([0, 1], varvariant); doc:=ddd.LoadComponentFromURL(

Re: [libreoffice-users] Re: macro pasting text instead of formula

2014-12-10 Thread Andrew Douglas Pitonyak
On 12/10/2014 12:23 PM, Joel Madero wrote: Hi All, Well, you set the string of a cell. Set the formula instead. So I just started from scratch because I had a ton of if statements before, decided to go to switch to make it faster but I'm hitting the same type of problem. Document:

Re: [libreoffice-users] Re: macro pasting text instead of formula

2014-12-10 Thread Andrew Douglas Pitonyak
On 12/10/2014 07:13 PM, Joel Madero wrote: Hey Andrew, First - thanks for giving explicit examples of where I went wrong :) I'll study your examples and learn for the future. Sometimes you need to specifically spelled out, I get that and your welcome. Second - as for the switch, I

Re: [libreoffice-users] Re: Sphinx - voice translation - Linux

2014-12-03 Thread Andrew Douglas Pitonyak
I have not looked in a long time... I have trouble with my wrists sometime, so, it would be nice if I had something that would integrate... Been a few years since I looked so perhaps it is time for another look. On 12/03/2014 04:48 AM, Tom Davies wrote: Hi :) We have the same thread going on

Re: [libreoffice-users] Linux Users - Sphinx use

2014-12-01 Thread Andrew Douglas Pitonyak
Can you be more specific? Numerous packages named Sphinx, could not begin to guess which. Perhaps I am simply not well informed. My best guess is this: https://pypi.python.org/pypi/sphinxcontrib-libreoffice On 12/01/2014 11:19 PM, charles meyer wrote: I hope it's OK to post about Linux

Re: [libreoffice-users] Re: How does 4.4 compress PDFs so well? Is there a quality problem?

2014-11-21 Thread Andrew Douglas Pitonyak
Note, I am not looking at the code, I am just guessing in my answers, but, if you are testing, perhaps you can test these things: On 11/21/2014 05:43 AM, Paddy Landau wrote: As for a pattern, I've not been able to find one. As mentioned before, there seems to be no pattern as to whether the

Re: [libreoffice-users] Re: macro to add annotation to selected text range

2014-11-19 Thread Andrew Douglas Pitonyak
Matt, It occurs to me that I might come off a bit arrogant in my response, but, my intention is to point you at a couple of places that contain the answer to one of your questions. So, please grant me some grace while reading and assume that I have the best of intentions. I have been having

Re: [libreoffice-users] Base Help Anyone

2014-11-18 Thread Andrew Douglas Pitonyak
On 11/18/2014 07:32 AM, Alan B wrote: On Tue, Nov 18, 2014 at 6:35 AM, Alan Pedder alanped...@hotmail.co.uk wrote: I have been using Base to provide a database for my paintings via a simple form. I recorded 200 records and then added the facility to include a photograph .jpg file and this

Re: [libreoffice-users] LO Writer page numbering resets itself halfway through document

2014-11-14 Thread Andrew Douglas Pitonyak
On a whim, can you run the macro below. As a paranoid sort, I would say... 1. Save your document. 2. Run this macro. 3. If I missed something and it modifies the document, do not save the changes (it should not change the document). Sub FindPageBreaks REM Author: Andrew Pitonyak Dim iCnt

Re: [libreoffice-users] Printing Reports from BASE extends to Writer?

2014-10-31 Thread Andrew Douglas Pitonyak
this, but it should work. Also, don't just close the document On 10/30/2014 10:18 AM, Paul D. Mirowsky wrote: Yes, that seems correct. On 10/29/2014 4:55 PM, Andrew Douglas Pitonyak wrote: Are you asking if it is possible to use a macro to open a document and then print it? On 10/28/2014 11:56

Re: [libreoffice-users] Printing Reports from BASE extends to Writer?

2014-10-29 Thread Andrew Douglas Pitonyak
Are you asking if it is possible to use a macro to open a document and then print it? On 10/28/2014 11:56 PM, Paul D. Mirowsky wrote: Can this be extended to Writer document, eliminating the requirement of opening Writer and selecting 'Print'? On 10/28/2014 4:05 AM, Walther Koehler wrote:

Re: [libreoffice-users] Help with Conditional Macro Please

2014-10-26 Thread Andrew Douglas Pitonyak
On 10/26/2014 06:29 PM, Budgie wrote: Yes, apostrophe sorry. DATEVALUE, that was it. Many thanks once more. Will report back if problems, else thanks again, Budgie In general, it is better to use the built-in methods when ever possible since they will easily stay with the sheet without

Re: [libreoffice-users] SOT - interesting article!

2014-09-22 Thread Andrew Douglas Pitonyak
On 09/22/2014 01:00 PM, Brian Barker wrote: At 17:05 22/09/2014 +0100, Gordon Burgess-Parker wrote: http://www.computerweekly.com/blogs/public-sector/2014/09/microsoft-gets-flack-over-rubb-8.html What a pity they cannot spell flak - even in a headline! Brian Barker I suppose that it

Re: [libreoffice-users] Table presented totally wrong.

2014-09-12 Thread Andrew Douglas Pitonyak
On 09/11/2014 02:15 PM, Stef Bon wrote: I got a template.docx of my education institution, and tried to open it using LibreOffice. I found out too late - after I sent it, I got comments of receiver - that writer did show the table totally wrong. I have seen that some tables do not show proper

Re: [libreoffice-users] dateValue() to dateText()?

2014-09-05 Thread Andrew Douglas Pitonyak
I have never tried conditional formatting, but, it may apply, sorry I don't have time to investigate further, but, hopefully it helps. https://help.libreoffice.org/Calc/Conditional_Formatting On 09/05/2014 11:04 PM, Ross wrote: I have a spreadsheet to keep track of payments. In one column

Re: [libreoffice-users] Re: Running a Macro from a form

2014-08-31 Thread Andrew Douglas Pitonyak
I always assume that it might be useful, which is why any of my documents exist :-) So, by all means, post the code. On 08/31/2014 02:58 AM, Marion Noel Lodge wrote: Hi Allan, With the help of Andrew and Alex, you may have solved your problem by now. But if not, I run lots of SQL commands

Re: [libreoffice-users] Running a Macro from a form

2014-08-28 Thread Andrew Douglas Pitonyak
On 08/28/2014 07:46 AM, Allan Newton wrote: In a database of mine a very convenient way to execute some operations is by running a small series of SQL statements. As Base has no direct way to run a text file of SQL statements I asked on Ask Libre Office and was given code in Basic that

Re: [libreoffice-users] Schema in Calc

2014-07-30 Thread Andrew Douglas Pitonyak
The most of which I am aware is the ability to see which cells reference the current cell, and, even then, you won't see the cells if they are not visible on screen. It requires a macro to turn on and off. It is rather obscure; I think it is meant for debugging. On 07/30/2014 02:37 AM,

Re: [libreoffice-users] status of macro in ODF interoperability?

2014-07-25 Thread Andrew Douglas Pitonyak
On 07/23/2014 11:40 AM, M. Fioretti wrote: Greetings, When I wrote this, almost 10 years ago, things didn't looking too good for inter-suite macro compatibility: http://archive09.linux.com/feature/47935 today, I have the feeling thing's haven't really improved, when it comes to macros

Re: [libreoffice-users] status of macro in ODF interoperability?

2014-07-25 Thread Andrew Douglas Pitonyak
On 07/25/2014 03:17 AM, M. Fioretti wrote: On Fri, Jul 25, 2014 02:25:29 AM -0400, Andrew Douglas Pitonyak wrote: On 07/23/2014 11:40 AM, M. Fioretti wrote: that is supported (roughly speaking although not totally accurate). This part of the language means things such as how do I wrote a loop

Re: [libreoffice-users] How to locate python macro for editing?

2014-07-25 Thread Andrew Douglas Pitonyak
On 07/25/2014 06:16 PM, Jim Byrnes wrote: I am using Ubuntu 12.04 and LibreOffice 3.5.7.2. A couple of years ago I created a python macro and a custom menu entry to run it. It still works but I am going to change the underlying sheet and will need to change the macro. The problem is I

Re: [libreoffice-users] Calc macro - selection by keyboard not recorded

2014-07-18 Thread Andrew Douglas Pitonyak
On 07/17/2014 01:41 AM, je...@lang.hm wrote: david_lynch david_ly...@blueyonder.co.uk posted to users@global.libreoffice.org at 0:23 on Sun, 13 Jul 2014 about Calc macro - selection by keyboard not recorded: On 13/07/2014 01:46, Andrew Douglas Pitonyak wrote: On 07/12/2014 04:41 PM, david_lynch

Re: [libreoffice-users] Calc macro - selection by keyboard not recorded

2014-07-13 Thread Andrew Douglas Pitonyak
On 07/13/2014 03:22 AM, david_lynch wrote: On 13/07/2014 01:46, Andrew Douglas Pitonyak wrote: On 07/12/2014 04:41 PM, david_lynch wrote: Although reasonably experienced using calc, I haven't used macros much. snip What am I doing wrong please? David Lynch 4.2.4.2 on Windows 8 You

Re: [libreoffice-users] Bug with Chapter Title in running headers

2014-07-10 Thread Andrew Douglas Pitonyak
I wanted to applaud you for a well done bug report. Spent some time looking at this so that when the QA team looks at this someone will have already tested. More thoughts at the bottom. On 07/10/2014 11:30 AM, Kartik Subbarao wrote: I seem to be running into a bug with Libreoffice

Re: [libreoffice-users] Templates as Extensions in Calc

2014-06-18 Thread Andrew Douglas Pitonyak
On 06/18/2014 10:23 AM, Kevin O'Brien wrote: I noted in the document CG4004 - Using Styles and Templates in Calc there is a discussion about installing Templates using the Extension Manager. So far I have not had any success in finding any Templates packaged in this manner. Am I just looking in

Re: [libreoffice-users] Macro problem

2014-06-12 Thread Andrew Douglas Pitonyak
On 06/11/2014 07:53 AM, Gavin Buxton wrote: Hi I'm writing a book on using spreadsheets for computer modeling, and on my last model I've ran into a slight problem. Libreoffice calc is doing something new. I'm using macro's to update the time step by simply copying the new information over the

Re: [libreoffice-users] Extensions by Openoffice

2014-06-12 Thread Andrew Douglas Pitonyak
I publish the same extension to both LO and AOO and it works fine in both. The extension will work, or not, based on how the extension is written. What is the extension? Do you know the implementation language? If My extension is in basic so there is no external dependency, which means that

Re: [libreoffice-users] Macro's in Libre Calc

2014-06-09 Thread Andrew Douglas Pitonyak
Be certain to only do what you really need to do using a macro, and then let things such as formulas do the rest of the work. It sounds like you want to have a Calc document with 366 sheets (so that it will work with leap years) with the same sheet on each page. Well, the sheet is the same

Re: [libreoffice-users] making graphics stay where you put them

2014-05-25 Thread Andrew Douglas Pitonyak
On 05/22/2014 07:52 AM, Virgil Arrington wrote: I think, conceptually, that is a problem. You can anchor to page, paragraph, character, and as character, whatever that means. If you anchor it as a character, then just think of it as one huge character. You can type text before and after it,

Re: [libreoffice-users] making graphics stay where you put them

2014-05-25 Thread Andrew Douglas Pitonyak
On 05/25/2014 10:44 AM, Regina Henschel wrote: Hi Andrew, Andrew Douglas Pitonyak schrieb: On 05/22/2014 07:52 AM, Virgil Arrington wrote: I think, conceptually, that is a problem. You can anchor to page, paragraph, character, and as character, whatever that means. If you anchor

Re: [libreoffice-users] making graphics stay where you put them

2014-05-22 Thread Andrew Douglas Pitonyak
On 05/21/2014 03:16 PM, Bruce Byfield wrote: If you've done much work positioning graphics in text, then you know how difficult it can be to make sure that the graphics stay in place. In the past, many experts have come up with recommendations about the best settings to use, but these

Re: [libreoffice-users] Re: Intentionally crashing LibreOffice when frozen/LibreOffice will not start.

2014-05-01 Thread Andrew Douglas Pitonyak
allowing you to tailor individual machines to specific use-cases and yet still retain the ability to share files between different machines and different people using different OSes and programs. Regards from Tom ) On 5 April 2014 06:43, Andrew Douglas Pitonyak [hidden email] http://user

Re: [libreoffice-users] forums, The AOO one

2014-04-26 Thread Andrew Douglas Pitonyak
brief skim-read. No, this forum is well maintained. I refer to oooforum.org Regards from Tom :) On 25 April 2014 12:18, Charles-H. Schulz charles.sch...@documentfoundation.org mailto:charles.sch...@documentfoundation.org wrote: Hi On 25 avril 2014 13:06:20 CEST, Andrew Douglas

Re: [libreoffice-users] forums, The AOO one

2014-04-25 Thread Andrew Douglas Pitonyak
On 04/24/2014 03:05 PM, Tom Davies wrote: Hi :) Just popped into the Apache OpenOffice forum https://forum.openoffice.org/en/forum/ and noticed their header claims User community support forum for Apache OpenOffice, LibreOffice and all the OpenOffice.org They were very intentional about that.

Re: [libreoffice-users] Retrofitting a template to a document

2014-04-18 Thread Andrew Douglas Pitonyak
I think that you want an extension called template-changer that allows you to set the document's template. A quick internet search showed this as one link to it http://extensions.services.openoffice.org/en/project/template-changer Same template will likely work for AOO or LO. On 04/17/2014

Re: [libreoffice-users] Any thoughts on Tutor.com's policy of MS Word only?

2014-04-17 Thread Andrew Douglas Pitonyak
First, if you opt to go this route, be prepared to spend the money to buy the software. On 04/17/2014 11:14 AM, Jeffrey Deutsch wrote: Hello, I'm thinking of applying for an online tutoring position at Tutor.com. However, they require that tutors (and applicants, for the mock tutoring

Re: [libreoffice-users] Do Macros run serially or in parallel?

2014-04-05 Thread Andrew Douglas Pitonyak
On 04/05/2014 09:13 AM, Marion Noel Lodge wrote: Hi, Sorry I've been slow to respond to all your posts. It has taken me a while to sort out what I think is happening. Many of us are very busy and totally understand when it takes time to respond! Fernand, thanks for your code

Re: [libreoffice-users] Do Macros run serially or in parallel?

2014-04-04 Thread Andrew Douglas Pitonyak
...@gmail.com On 4 April 2014 03:06, Andrew Douglas Pitonyak and...@pitonyak.org wrote: So, are you saying that you have: Print #giInit, 1. + Now() Wait(2000) Print #giInit, 2. + Now() And it prints the same value for now? On 04/03/2014 09:12 AM, Marion Noel Lodge wrote: Thanks

Re: [libreoffice-users] Do Macros run serially or in parallel?

2014-04-04 Thread Andrew Douglas Pitonyak
-- Marion Noel Lodge lodg...@gmail.com On 4 April 2014 03:06, Andrew Douglas Pitonyak and...@pitonyak.org wrote: So, are you saying that you have: Print #giInit, 1. + Now() Wait(2000) Print #giInit, 2. + Now() And it prints the same value for now? On 04/03/2014 09:12 AM, Marion Noel Lodge

Re: [libreoffice-users] Intentionally crashing LibreOffice when frozen/LibreOffice will not start.

2014-04-04 Thread Andrew Douglas Pitonyak
On 04/04/2014 07:44 PM, andrewH wrote: I am working with a data set that keeps causing my LibreOffice to freeze. I am pretty sure that this is only because it is big. It is a pipe-separated text from the US Economic Census imported into Calc, about 30 columns and around a million rows. (The

Re: [libreoffice-users] Do Macros run serially or in parallel?

2014-04-03 Thread Andrew Douglas Pitonyak
\InitfTransEntry.txt for Output as giInit Print #giInit, 1. + Now() Any suggestions as to how I can format Now(), or should I use a different function to get more accurate timing? Thanks, Noel -- Noel Lodge lodg...@gmail.com On 2 April 2014 00:05, Andrew Douglas Pitonyak

Re: [libreoffice-users] Do Macros run serially or in parallel?

2014-04-01 Thread Andrew Douglas Pitonyak
Sadly, I do not have a definitive answer to your question, but I do have some thoughts... (see inline) On 04/01/2014 06:57 AM, Marion Noel Lodge wrote: Hi, In opening my database accounting system, I trigger via the Form: When loading event, a macro, (Sub Init()), containing the database

Re: [libreoffice-users] shutdown glitch

2014-03-30 Thread Andrew Douglas Pitonyak
On 03/28/2014 11:34 AM, rmg wrote: Yes, the book also says it's not case sensitive and I have to admit I've played fast and loose with case elsewhere without ill effect. And anyway the minimalist Goodbye without that still gives the problem. Case is usually not an issue. I think that with

Re: [libreoffice-users] Re: How to put Basic IDE code completion to work

2014-03-19 Thread Andrew Douglas Pitonyak
That is the behavior that I have seen :-) On 03/19/2014 04:23 PM, Fernand Vanrie wrote: hallo Miklos thanks but only and ( are auto clossing dot operator is not functioning at all (maybe a keyboard problem ?) tab do nothing sub and Function not closing do i something wrong ? using Windows 7

Re: [libreoffice-users] Need confirmation about Date type confusions

2014-02-27 Thread Andrew Douglas Pitonyak
Yep, I see this on Linux as well. Nice little bug. You will notice that it fails to compile. Here is one hack / work around dStart.year = oevent.source.context.getcontrol(test1).getdate().year dStart.day = oevent.source.context.getcontrol(test1).getdate().day dStart.month =

Re: [libreoffice-users] large .odt file

2014-02-26 Thread Andrew Douglas Pitonyak
Can you send the file directly to me off list? On 02/24/2014 01:07 PM, HValisuo wrote: I am using libreoffixe Version: 4.1.4.2 Build ID: 410m0(Build:2) in openSUSE Tumbleweed. I am editing a text file of less than 200 hundred A4 pages. The file size had grown to 7.4MB. (Maybe because I had

Re: [libreoffice-users] opening file via macro failes

2014-02-26 Thread Andrew Douglas Pitonyak
Download AndrewBase.odt Listing 41 (ShowFlatDriverArgs) will display the supported arguments. In fact, just before the listing, there is a button that you can click in the document that will run the macro and display the arguments for you. The macro may be structured such that the file must

Re: [libreoffice-users] Re: Basic IDE Right Click

2014-02-26 Thread Andrew Douglas Pitonyak
So the problem was likely related to your user profile... If the problem occurs again, try renaming your user profile while LO is not running and then restart LO. On 02/26/2014 05:10 PM, Bill Martin wrote: Thanks for the pointer Tom, but that doesn't seem to make any difference. So for no

Re: [libreoffice-users] HOW CAN I CONVERT A NUMBER IN LibreOffice CALC TO TEXT IN LibreOffice CALC?

2014-02-22 Thread Andrew Douglas Pitonyak
On 02/22/2014 04:41 PM, Tanstaafl wrote: It is called bottom or in-line posting, and is preferred by the more technically inclined. Bottom and Top posting seems to be a personal preference often pursued with religious zeal (as you mention below). While quickly browsing, top posting is

Re: [libreoffice-users] Declare Statment - Calc

2014-02-20 Thread Andrew Douglas Pitonyak
On 02/19/2014 04:08 PM, Bill Martin wrote: I've tried to implement the simple example shown in the Calc Help system for the Declare Statement. Somewhere it expects to find a file: user32.dll but I have no idea where to find it. Windows has many user32.dll files for it's own use but

Re: [libreoffice-users] LO Base: MySQL or Mariadb ?

2014-02-10 Thread Andrew Douglas Pitonyak
I have seen nothing that indicates that you cannot use Maria DB as a drop-in replacement for MySQL at this point. Last I tried it was with Drupal 7. It just worked. I expect the same for Base, if it is not so, file a bug report against Maria DB. -- Andrew Pitonyak My Macro Document:

Re: [libreoffice-users] LO Base/MySQL questions

2014-02-08 Thread Andrew Douglas Pitonyak
On 02/07/2014 09:07 AM, Ian Whitfield wrote: Sorry All I'm running PClinuxOS (latest) and LO 4.1.2.3 and MySQL 5.1.55 A MySQL 'expert' was telling me recently that HSQL is only meant to be a prototyping utility and should *NEVER* be used for any proper work - - interesting!!?? I can

Re: [libreoffice-users] LO Base/MySQL questions

2014-02-07 Thread Andrew Douglas Pitonyak
On 02/07/2014 02:38 AM, Ian Whitfield wrote: Hi All I've been using the Base/MySQL combination since mid-last year now and it is fantastic!! It is much faster, never crashes or freezes and just works the way it is supposed to. I can definitely recommend it to anyone!! (In my opinion this

Re: [libreoffice-users] Re: North America Touching Basis

2014-01-30 Thread Andrew Douglas Pitonyak
I popped on over to the Cincinnati when Jean Webber (documentation team) was there for a conference so that we could have lunch. It was nice to finally meet her in person :-) On 01/29/2014 09:58 PM, Ruth Ann wrote: Hi Joel, Well, I am in the Mid-west, so it would be kind of far to travel just

Re: [libreoffice-users] Re: North America Touching Basis

2014-01-30 Thread Andrew Douglas Pitonyak
QA is a great place to start You can jump in when you have time, you become familiar with different features, and it is a huge help... You will probably enjoy it Ruth Ann. Good of you to help her through it Joel! Do we have a FAQ or WIKI page to help people become involved in the QA

Re: [libreoffice-users] Re: North America Touching Basis

2014-01-30 Thread Andrew Douglas Pitonyak
On 01/29/2014 08:22 PM, Joel Madero wrote: On 01/29/2014 05:07 PM, anne-ology wrote: Andrew, well said. Joel, ... [see my comments below, interspersed within Andrew's] Um honestly I don't have the time. Sorry but first line made me realize how far off point this is getting.

Re: [libreoffice-users] Re: North America Touching Basis

2014-01-29 Thread Andrew Douglas Pitonyak
On 01/29/2014 04:35 PM, Joel Madero wrote: On 01/29/2014 11:38 AM, anne-ology wrote: Pacific coast then Atlantic coast then Pacific coast - yet there's a couple thousand miles in between; seems to me, if you really wanted our participation - and help, financial

Re: [libreoffice-users] Deleting Table Column Causes Whole Table To Dissapear

2014-01-27 Thread Andrew Douglas Pitonyak
On 01/27/2014 09:16 AM, Tom Robinson wrote: Hi, I'm new to Libreoffice (I'm using it in Windows 8.1). I tried to delete columns in an existing table created under OpenOffice (in Windows XP), and this causes the whole table to be dissapear. Would appreciate any advice. Thank's. I do not have

Re: [libreoffice-users] Re: Recalc cell(filename) [partially solved]

2014-01-15 Thread Andrew Douglas Pitonyak
So, are you using Apache OpenOffice (AOO) or LibreOffice (LO)? I only ask because you posted to the LO group about a bug you reported in AOO Not that I have not done similar things given that I subscribe to both mailing lists. On 01/15/2014 12:56 AM, James E Lang wrote: Related bug

Re: [libreoffice-users] State of password support.

2013-12-19 Thread Andrew Douglas Pitonyak
Thanks for the link On 12/19/2013 01:05 AM, Massimo Del Zotto wrote: 2013/12/18 Andrew Douglas Pitonyak and...@pitonyak.org mailto:and...@pitonyak.org You mean recently?As in the latest version of LO has a problem with passwords? No, I am referring to OOo. I am considering

Re: [libreoffice-users] State of password support.

2013-12-18 Thread Andrew Douglas Pitonyak
On 12/17/2013 10:12 AM, Massimo Del Zotto wrote: However, I recently had a problem with OOo password protection. Somehow it disabled password protection for a file I was working on and it took me a while to restore it. Asking for help on OOo forum, I have been informed password protection is

Re: [libreoffice-users] Anchoring frames to paragraphs vs. to characters

2013-12-01 Thread Andrew Douglas Pitonyak
On 11/30/2013 05:17 PM, Kevin O'Brien wrote: I am having trouble understanding the difference between these two options. I think I get anchoring to a page, and anchoring as a character is pretty clear. But I have not yet grokked how to paragraph and to character are different. Can anyone

Re: [libreoffice-users] How-to draw Square around math/formula??

2013-12-01 Thread Andrew Douglas Pitonyak
can you insert the formula into a frame and then give the frame a border? On 11/30/2013 05:01 PM, Gary Kline wrote: Organization: Thought Unlimited. Public service Unix since 1986. Of_Interest: With 27 years of service to the Unix community. hi guys, I've tried

Re: [libreoffice-users] Detailed information on frame positioning Writer

2013-12-01 Thread Andrew Douglas Pitonyak
On 11/30/2013 08:38 PM, Kevin O'Brien wrote: Is there a source for detailed information on frame positioning in Writer? Thanks, Let me provide some context around Mr. O'Brien. 1. He is very smart. 2. He is well versed with OpenOffice. Sufficiently well versed, that I have seen him (in

Re: [libreoffice-users] Detailed information on frame positioning Writer

2013-12-01 Thread Andrew Douglas Pitonyak
On 12/01/2013 04:41 PM, Regina Henschel wrote: you can look into the spec http://docs.oasis-open.org/office/v1.2/os/OpenDocument-v1.2-os-part1.html#__RefHeading__1418758_253892949 o, smart! I had not considered looking at the spec! :-) -- Andrew Pitonyak My Macro Document:

Re: [libreoffice-users] Question

2013-11-29 Thread Andrew Douglas Pitonyak
https://wiki.openoffice.org/wiki/Documentation/How_Tos/Calc:_FV_function On 11/27/2013 07:12 PM, Dave Liesse wrote: I've had troubles in the past finding specific financial functions, as well. Can't help from the function standpoint in this case, but you could always fall back on the

Re: [libreoffice-users] Bugs and Issue

2013-11-21 Thread Andrew Douglas Pitonyak
On 11/21/2013 12:52 AM, McDennis Cabatingan wrote: I have this document that has a textbox that I rotated to 90degrees and everytime I save it to .Docx or .xlsx to send it to my Boss the text box I rotated is not rotated. I already gone to several check and found out the it will occur

Re: [libreoffice-users] Re: Templates with pop up variables in Writer

2013-11-15 Thread Andrew Douglas Pitonyak
On 11/15/2013 03:39 AM, Stefan Gruber wrote: Hello, John Meyer schrieb: Basically, I want two things: One capture two pieces of information (Name and date) and second, insert both variable into pre-set fields. The date I want to go into a field in the format Day, Month Name, Year but I want

Re: [libreoffice-users] Customize an index

2013-11-12 Thread Andrew Douglas Pitonyak
Sadly, I believe that it is not possible to do this directly. The following link discusses this: https://forum.openoffice.org/en/forum/viewtopic.php?f=7t=1227 On 11/12/2013 05:12 PM, MENGUAL Jean-Philippe wrote: Hi, I want to have an lexical index. Mine is a somewhat particular as, in

Re: [libreoffice-users] HELP: Frame placement, wrapping, and collision

2013-11-07 Thread Andrew Douglas Pitonyak
You may have some control if you change how your anchor your frames. For example, if you anchor as a character, but then you cannot move it around at will. On 11/07/2013 06:47 AM, Adam Tauno Williams wrote: Version: 4.1.2.3:build410m0 I have a document with many examples and illustrations.

Re: [libreoffice-users] Working sheet Macro file path

2013-10-29 Thread Andrew Douglas Pitonyak
, plz let me knw... On Tue, Oct 29, 2013 at 4:51 AM, Andrew Douglas Pitonyak and...@pitonyak.org mailto:and...@pitonyak.org wrote: On 10/28/2013 03:54 AM, Heena Gupta wrote: Hi, Can anyone tell me how to get the path of current working sheet macros file

Re: [libreoffice-users] Working sheet Macro file path

2013-10-28 Thread Andrew Douglas Pitonyak
On 10/28/2013 03:54 AM, Heena Gupta wrote: Hi, Can anyone tell me how to get the path of current working sheet macros file or library through macro ? Thanks Regards, HEENA GUPTA Can you clarify your question? Specifically, are you asking: 1. What is the path to the current document (easy,

Re: [libreoffice-users] RE: Modified Flag Set / No Changes

2013-10-23 Thread Andrew Douglas Pitonyak
I have at least one file that does this. It is a DOCX file. Anything I say is a guess, but When a file is stored on disk, things such as page numbers may be stored in the file, but, in LO, the data does not determine things like the page number; the view controller portion determines

Re: [libreoffice-users] Macro issue

2013-10-22 Thread Andrew Douglas Pitonyak
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

Re: [libreoffice-users] LO Base Sub Forms

2013-10-15 Thread Andrew Douglas Pitonyak
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

2013-10-12 Thread Andrew Douglas Pitonyak
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

2013-10-05 Thread Andrew Douglas Pitonyak
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

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

2013-10-02 Thread Andrew Douglas Pitonyak
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

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

2013-09-25 Thread Andrew Douglas Pitonyak
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

  1   2   3   >