Re: how to create and fill a table of contents ?

2019-02-09 Thread Andrew Douglas Pitonyak
Forgot to add the link: http://www.pitonyak.org/OOME_4_0.odt On 2/8/19 8:42 AM, LORENZO Vincent wrote: Hello, I’m looking for a code example to create a table of contents and fill it programmatically. I thought find something like an object called XTableOfContents  in the unoil library,

Re: how to create and fill a table of contents ?

2019-02-09 Thread Andrew Douglas Pitonyak
From OOME on my web site, well, part of that section: Finding and inserting a table of contents (TOC) is easy unless you want to change the defaults. The following macro checks ThisComponent to see if the document contains a content index. REM Find TOC if it exists. oIndexes =

Re: Macro to load and run ppt for impress

2015-07-08 Thread Andrew Douglas Pitonyak
This does work for me, but, only if I define some global variables in the defining module. Try setting OptionExplicit at the top of the module and it will flag all of those undefined variables for you. Global oGlob GLobal oListener Global boFinished Global url On 07/06/2015 04:54 PM, Jerry

Re: Q: How to get the path of all opened spreadsheet documents

2015-06-08 Thread Andrew Douglas Pitonyak
Calc documents implement the following service: com.sun.star.sheet.SpreadsheetDocument Using that with the examples below based on a write document: '** '// Count the total number of open componets. '//

Re: Who knows of a free UML tool to work with libreoffice?

2014-11-26 Thread Andrew Douglas Pitonyak
Nicholas, Can you clarify your request? Do you simply need a free UML tool, something that allows you to model UML from within LO, or something to create UML for use by the official LO project? Some years back, I found a UML to a project that directed that open source tools be used. If I

Re: Top posting vs posting styles

2014-09-24 Thread Andrew Douglas Pitonyak
It seems to be an issue where one's view point is attacked with religious zeal. The fact that people feel so strongly on both sides is an indicator to me that it is nothing more than personal preference. The posting style used affects the best way to follow the thread. If you leave

Re: Should we use boost::math::log1p/expm1 instead of rtl_math_log1p/expm1 ?

2014-09-17 Thread Andrew Douglas Pitonyak
On 09/15/2014 03:38 PM, julien2412 wrote: Hello, Following http://cgit.freedesktop.org/libreoffice/core/commit/?id=a3ad01dc1e07da21182077bd899094fd73f57714, should it worth it to replace rtl_math_log1p/rtl_math_expm1 and related by boost::math::log1p/expm1 ? Or should we let the code as it is

Re: UNO: Possible to get printing progress?

2014-04-09 Thread Andrew Douglas Pitonyak
When I see this, it is usually so that a macro knows when it can close a document (you cannot close a document that is being used because it is being actively printed). So, you noticed that the reported states are very basic

Re: General question about vectors

2014-01-28 Thread Andrew Douglas Pitonyak
On 01/26/2014 07:35 PM, Chris Sherlock wrote: Libreoffice takes advantage of STL vectors throughout the codebase. So just a general question: under what circumstances is it better to use a for loop than an STL for_each loop? Are there specific advantages to for_each over a regular loop? I

Re: Reformatting a text document via UNO

2013-11-27 Thread Andrew Douglas Pitonyak
On 11/27/2013 07:45 AM, Pavel Laštovička wrote: Hi all, is there a way to reformat parts or whole text document e.g. from a Basic macro? Without inserting / changing a text content to force formatting. I am thinking about a macro changing a compatibility option called by user during document

Re: Vendors Name via UNO API / Basic Macros

2013-11-15 Thread Andrew Douglas Pitonyak
On 11/15/2013 07:43 AM, Thomas Krumbein wrote: Every custom macro application with dialogs or forms for user interfaces is influenced if dialogs/forms using Date/time fields. And typicly most of them (in my applications about 70%) used those fields. So all applications will crash using LO

Re: [NEW FEATURE] Access2Base: StarBasic library for Base scripting

2013-10-15 Thread Andrew Douglas Pitonyak
Do we have more information on this library anywhere, or should I just poke through it to see what is there? On 10/13/2013 08:00 PM, Lionel Elie Mamane wrote: Just a notice that as per now, master-towards-4.2 contains Access2Base, a StarBasic library that offers an easier API to Base (and

Re: New bug, looking for source location for setting Calc formulas

2013-08-30 Thread Andrew Douglas Pitonyak
Thanks for looking Eike! Good to know for sure that it is a bug rather than intended behavior. I will contact a few others that are not on this list and update them. On 08/30/2013 03:27 PM, Eike Rathke wrote: Hi Andrew, On Friday, 2013-08-30 01:27:05 -0400, Andrew Douglas Pitonyak wrote

Re: New bug, looking for source location for setting Calc formulas

2013-08-30 Thread Andrew Douglas Pitonyak
On 08/30/2013 04:53 PM, Eike Rathke wrote: Hi Andrew, On Friday, 2013-08-30 15:50:09 -0400, Andrew Douglas Pitonyak wrote: Good to know for sure that it is a bug rather than intended behavior. I will contact a few others that are not on this list and update them. Cause identified, easy fix

New bug, looking for source location for setting Calc formulas

2013-08-29 Thread Andrew Douglas Pitonyak
Anyone know off hand where I can find the sourcecode to set the the Formula and FormulaLocal property. Then, how can I see how changed that code last? A bug was introduced in 4.1 and I am trying to track the developer responsible. So, what is the bug? Setting the Formula property on a

Re: New bug, looking for source location for setting Calc formulas

2013-08-29 Thread Andrew Douglas Pitonyak
On 08/29/2013 10:44 PM, Andrew Douglas Pitonyak wrote: Anyone know off hand where I can find the sourcecode to set the the Formula and FormulaLocal property. Then, how can I see how changed that code last? A bug was introduced in 4.1 and I am trying to track the developer responsible. So

Re: libre office basic BUG (I believe so)

2013-08-28 Thread Andrew Douglas Pitonyak
I had a lot of trouble with your little macro and I am not sure if it is because there are Bugs in LO or something else is happening. First, I believe that your only stated problem is that you enter B780) and it comes out as C13. This is because it is relative. In other words, what you

Re: Developer needed for a LibreOffice add-on (for managing citations)

2013-08-14 Thread Andrew Douglas Pitonyak
On 08/14/2013 11:05 AM, Joeran Beel wrote: Hello, we are planning to develop an open-source add-on for LibreOffice to manage citations based on BibTeX and the citation style language http://citationstyles.org/. If someone of you is interested in helping us with the development (for money,

Re: redlines for pyuno

2013-08-08 Thread Andrew Douglas Pitonyak
it later... ugg. mike On Thu, Aug 8, 2013 at 12:00 AM, Andrew Douglas Pitonyak and...@pitonyak.org mailto:and...@pitonyak.org wrote: I remember looking at redlines way back in the dark recesses of time, so I loaded up AndrewMacro.odt The best I saw

Re: redlines for pyuno

2013-08-07 Thread Andrew Douglas Pitonyak
I remember looking at redlines way back in the dark recesses of time, so I loaded up AndrewMacro.odt The best I saw there was the ability to enumerate text sections to find Redline text portion sections. If I had to determine if the cursor was currently in a redline section, my first guess

Re: LibreOffice Commercial Support

2013-07-18 Thread Andrew Douglas Pitonyak
The usual way of for obtaining help is outlined here: http://www.libreoffice.org/get-help/ You do not mention exactly what type of support that you require... but I don't think that in general you can obtain a support contract from a "community" of

Re: How to know the current viewed page and line in writer

2013-07-17 Thread Andrew Douglas Pitonyak
Does not really answer your question, but: MsgBox PageCount = ThisComponent.CurrentController.PageCount CHR$(10) _ LineCount = ThisComponent.CurrentController.LineCount CHR$(10) _ Current Page = ThisComponent.CurrentController.ViewCursor.Page In AndrewMacro.odt, look

Re: [tdf-discuss] macro compatibility between LO and AOO?

2013-03-05 Thread Andrew Douglas Pitonyak
On 03/04/2013 04:46 AM, Fernand Vanrie wrote: On 4/03/2013 8:27, M. Fioretti wrote: On Mon, Mar 04, 2013 08:16:25 AM +0100, Fernand Vanrie wrote: 99% percent , changes comes and will come from incompatiliteis in de API. for now this is OK, small changes from version to version, but nothing

Re: [tdf-discuss] macro compatibility between LO and AOO?

2013-03-05 Thread Andrew Douglas Pitonyak
They work independently. The best you can likely do is to check the code or dev documentation to see if it is in both places and if it is marked deprecated or not. I do not know how to check the IDL, but, if you figure that out, I expect that it would not be too difficult to check that for

Re: Implementing alternate compatibility functions (such as 0^0 = ERROR)

2013-02-22 Thread Andrew Douglas Pitonyak
On 02/22/2013 04:51 AM, Michael Meeks wrote: On Thu, 2013-02-21 at 21:50 -0600, Norbert Thiebaud wrote: The issue is purely academic, but if it _has_ to be resolved then yes a compatibility mode has a much better value that creating an 'alternate' function. True - though clearly there

Implementing alternate compatibility functions (such as 0^0 = ERROR)

2013-02-21 Thread Andrew Douglas Pitonyak
I was recently involved in a conversation related Calc and Excel compatibility. At issue is the fact that LO returns POWER(0,0) = 1 and Excel returns an error. I have seen two primary means of dealing with this suggested. The first is to create a compatibility function for POWER(x,y) to

Re: Using Symphony Code

2013-02-06 Thread Andrew Douglas Pitonyak
On 02/05/2013 10:57 AM, Michael Meeks wrote: Hi Samuel, On Tue, 2013-02-05 at 16:34 +0100, Samuel Mehrbrodt wrote: as I wanted to include the Clip Art from Symphony in LibreOffice, I stumbled about the license [1]. A public list is not a great place to discuss that. IMHO it

Re: [PATCH libreoffice-4-0] fix for fdo#60065

2013-02-06 Thread Andrew Douglas Pitonyak
Does the patch fix this regression (that fails with 4 RC2)? Sub badStruct Dim x As New com.sun.star.beans.PropertyValue Dim y As New com.sun.star.beans.PropertyValue x.Name = hello x.Value = y End Sub Unable to test with RC3 yet On 02/05/2013 10:40 AM, Noel Power (via Code Review)

Re: [PATCH libreoffice-4-0] fix for fdo#60065

2013-02-06 Thread Andrew Douglas Pitonyak
Reported here: https://bugs.freedesktop.org/show_bug.cgi?id=60371 On 02/06/2013 08:56 PM, Andrew Douglas Pitonyak wrote: Does the patch fix this regression (that fails with 4 RC2)? Sub badStruct Dim x As New com.sun.star.beans.PropertyValue Dim y As New com.sun.star.beans.PropertyValue

Re: random number generators for calc

2012-11-29 Thread Andrew Douglas Pitonyak
On 11/28/2012 05:41 PM, Kohei Yoshida wrote: Not sure I understand. My suggestion is that boost::mt19937 is the only underlying generator algorithm (generating int's) which is then transformed to get RAND() and RANDBETWEEN(i,j). Yet both are simple uniform distributions but

Re: [UX] FDO#54975 - Should Formulas Be Considered Values If there is No Cell Reference - Advice

2012-11-24 Thread Andrew Douglas Pitonyak
On 11/24/2012 10:39 PM, Joel Madero wrote: Hi All, We need UX input on this bug: https://bugs.freedesktop.org/show_bug.cgi?id=54975 Seems like we already have two different opinions. Basically we need to know if a cell should be considered a value if there is no cell reference in the

Re: TextSections, DocInfo etc in LO Base Forms

2012-10-16 Thread Andrew Douglas Pitonyak
On 10/15/2012 10:59 PM, Arno Teigseth wrote: I had the impression that LO Base Forms are actually writer documents. They behave mostly like that. You mean they are not? If you look at the services supported by the form, what type is it? I don't have time to check now (late for a meeting),

Re: [REVIEW 3-6, 3-6-0] fdo#50345 accept empty string as scalar numeric 0 argument

2012-07-19 Thread Andrew Douglas Pitonyak
On 07/19/2012 11:58 AM, Markus Mohrhard wrote: Hey Eike, Kohei, 2012/7/19 Kohei Yoshida kohei.yosh...@gmail.com: On 07/19/2012 10:29 AM, Eike Rathke wrote: Hi, Please review and cherry-pick to 3-6 and 3-6-0

Re: RFC: where to put sorted vector template/class?

2012-07-11 Thread Andrew Douglas Pitonyak
On 07/10/2012 10:07 AM, Noel Grandin wrote: On 2012-07-10 15:35, Caolán McNamara wrote: On Tue, 2012-07-10 at 14:53 +0200, Noel Grandin wrote: Rather than re-implement such a class/template repeatedly, is there a common place I could stash such a template, and then include it in the places it

Re: RFC: where to put sorted vector template/class?

2012-07-11 Thread Andrew Douglas Pitonyak
On 07/11/2012 09:20 AM, Noel Grandin wrote: On 2012-07-11 15:16, Andrew Douglas Pitonyak wrote: How large do you expect the sorted vector to be? I ask because a linear search is used, which on average will take time n/2 to find the item and n to not find the item (assuming vector of size n

Re: New way to modify nested uno structs in LibreOffice BASIC

2012-07-05 Thread Andrew Douglas Pitonyak
On 07/05/2012 04:22 AM, Noel Power wrote: On 05/07/12 02:47, Andrew Douglas Pitonyak wrote: On 07/04/2012 03:23 PM, Noel Power wrote: with http://cgit.freedesktop.org/libreoffice/core/commit/?id=1720641bf36306fc296635925e571556ced8a302 a long standing wrinkle with modifying nested structs

Re: [GSOC] how to fetch document/templates properties

2012-06-20 Thread Andrew Douglas Pitonyak
It is possible to load document properties from a file on disk. You may find this of interest: http://www.oooforum.org/forum/viewtopic.phtml?t=94527 On 06/20/2012 12:54 AM, Rafael Dominguez wrote: Im trying to fetch document properties like author, creation date, application that created

Re: Most elegant way to disable all BASIC functionality?

2012-02-27 Thread Andrew Douglas Pitonyak
On 02/27/2012 11:46 AM, Noel Power wrote: On 27/02/12 16:02, Andras Timar wrote: Hi, 2012/2/27 Eike Rathkeer...@redhat.com: If this is only about no BASIC should be executed, there's the configuration setting behind Tools-Options-Security, Macro Security. If Security Level is set to Very High

Re: Most elegant way to disable all BASIC functionality?

2012-02-26 Thread Andrew Douglas Pitonyak
On 02/26/2012 09:27 AM, Tor Lillqvist wrote: For the iOS port, no BASIC-related functionality can be present if we want apps using the code to be allowed in the App Store. What would be the most elegant way (least ifdefs to clutter the code, etc) to achieve this? Is it more accurate to say

Re: Most elegant way to disable all BASIC functionality?

2012-02-26 Thread Andrew Douglas Pitonyak
It just occurred to me, if you disable Basic... How about add-ons and extensions? For example, I frequently use an add-on / extension to format certain types of text. Sadly, I am not in a position to enumerate the extent of the limitations if Basic is disabled. If simply disabling the IDE is

Re: Disappearing graphics in Write: where to look (bug 33393)

2012-02-22 Thread Andrew Douglas Pitonyak
On 02/21/2012 06:49 AM, Michael Meeks wrote: On Tue, 2012-02-21 at 10:36 +0100, Jan Holesovsky wrote: So - I have already spent some 4 hours, or more, trying to fix this one. I spent a little time too ;-) cf. my comments in the bug. IMHO the lifecycle of images is highly

Re: Disappearing graphics in Write: where to look (bug 33393)

2012-02-18 Thread Andrew Douglas Pitonyak
On 02/17/2012 08:31 PM, Andrew Douglas Pitonyak wrote: While updating LO documentation using the latest release of LO, most of the embedded graphics just disappeared so I have been looking at this: https://www.libreoffice.org/bugzilla/show_bug.cgi?id=33393 I spent a few hours poking around

Re: Disappearing graphics in Write: where to look (bug 33393)

2012-02-18 Thread Andrew Douglas Pitonyak
On 02/18/2012 04:43 PM, julien2412 wrote: You may find some guidelines to debug LO here : http://wiki.documentfoundation.org/Development/How_to_debug Julien. Thanks Julien, very helpful. I am able to cause the problem every time in LO but unable to cause it at all in OOo. Have been poking

Re: [Libreoffice] [REVIEW][3-4] date change regression fdo#44385

2012-01-20 Thread Andrew Douglas Pitonyak
On 01/20/2012 06:32 AM, Noel Power wrote: Hi Andrew, My primary concerns 1. Change in behavior that may break existing code. the intent of the patch is to restore the previous behaviour ( by previous behaviour I mean before integration of the feature that erroneously removed the 'special'

Re: [Libreoffice] [REVIEW][3-4] date change regression fdo#44385

2012-01-20 Thread Andrew Douglas Pitonyak
On 01/20/2012 10:30 AM, Noel Power wrote: On 20/01/12 13:40, Andrew Douglas Pitonyak wrote: On 01/20/2012 06:32 AM, Noel Power wrote: note there is a mistake in the table below [*] table of behaviour in vba, pre the bug being introduced and post patch mso

Re: [Libreoffice] [REVIEW][3-4] date change regression fdo#44385

2012-01-19 Thread Andrew Douglas Pitonyak
On 01/16/2012 08:01 AM, Eike Rathke wrote: Hi Noel, On Friday, 2012-01-13 09:51:33 +, Noel Power wrote: this change ( the variant ) is what is on master, here the intention is as Andrew pointed out ( in a previous mail discussing the regression ) to allow operations on date types return

Re: [Libreoffice] [REVIEW][3-4] date change regression fdo#44385

2012-01-19 Thread Andrew Douglas Pitonyak
On 01/19/2012 09:03 PM, Andrew Douglas Pitonyak wrote: On 01/16/2012 08:01 AM, Eike Rathke wrote: Hi Noel, On Friday, 2012-01-13 09:51:33 +, Noel Power wrote: this change ( the variant ) is what is on master, here the intention is as Andrew pointed out ( in a previous mail discussing

Re: [Libreoffice] [REVIEW][3-4] date change regression fdo#44385

2012-01-19 Thread Andrew Douglas Pitonyak
On 01/17/2012 04:46 AM, Noel Power wrote: On 16/01/12 16:59, Eike Rathke wrote: b) not so risky ( I think ), and... would change the present behaviour in consistent way for treatment of minus operator -if( GetType() == SbxDATE || rOp.GetType() == SbxDATE ) +

Re: [Libreoffice] Change in addition for date handling (intentional change??)

2012-01-10 Thread Andrew Douglas Pitonyak
On 01/09/2012 08:16 AM, Noel Power wrote: On 06/01/12 21:39, Andrew Douglas Pitonyak wrote: Off hand, I might be inclined to simply move the code back to its original location, which would set the behavior back to letting math with dates return dates, rather than just specific operations

Re: [Libreoffice] Change in addition for date handling (intentional change??)

2012-01-06 Thread Andrew Douglas Pitonyak
On 01/06/2012 11:48 AM, Noel Power wrote: Andrew, Apologies for the late reply, just back from vacation and now trying to chip away at the mountain of mail backlog On 01/01/12 16:01, Andrew Douglas Pitonyak wrote: Thanks for checking Will wait and see what Noel has to say... I say I

Re: [Libreoffice] Doxygen for C/C++ URE Documentation

2012-01-04 Thread Andrew Douglas Pitonyak
For what it is worth, I would provide an argument so that you could enable or disable the generation. I don't really care what the default is, as long as I can enable or disable doxygen. What can become easy hacks, though, is to clean up the warnings doxygen still produces ... That seems

Re: [Libreoffice] Change in addition for date handling (intentional change??)

2012-01-02 Thread Andrew Douglas Pitonyak
I created a bug for this. https://www.libreoffice.org/bugzilla/show_bug.cgi?id=44385 I will poke around and see if I am able to build the source and test a solution... Running git now. On 01/01/2012 11:01 AM, Andrew Douglas Pitonyak wrote: Thanks for checking Will wait and see what

Re: [Libreoffice] Change in addition for date handling (intentional change??)

2012-01-01 Thread Andrew Douglas Pitonyak
; moved from after the switch inside the switch with commit 1421b098ae19a10acb4836fa3752188cf7c52eb2 by Noel Power 06-Dec-2010 and the #if 0 is a WaE fix by Tor Lillqvist 06-Oct-2011 8529da08517b41bd9317714e3216bb6d487b24ee So I think, Noel should know. Kind regards Regina Andrew Douglas Pitonyak

[Libreoffice] Change in addition for date handling (intentional change??)

2011-12-31 Thread Andrew Douglas Pitonyak
I thought I found a bug, I decided to take a crack at fixing the bug, and then I became confused because the bug appears to be intentional. Let me explain: Consider some comments related to Basic. In the last release of OOo, the statement Now + 2 returns a date / time that is two days later

Re: [Libreoffice] Adding a Predictive Typing feature.

2011-12-10 Thread Andrew Douglas Pitonyak
On 12/09/2011 01:04 AM, Jean-Baptiste Faure wrote: Hi, Le 09/12/2011 06:26, Shoubhik Bose a écrit : Hello, what is the difference with auto-completion : Tools AutoCorrectoptions ... Word completion Tab ? The suggestions are based only on what has been typed in the document before. I am

Re: [Libreoffice] [PUSHED, partial] Remove NULL checks from delete

2011-11-16 Thread Andrew Douglas Pitonyak
On 11/10/2011 05:14 AM, Caolán McNamara wrote: On Wed, 2011-11-09 at 18:05 -0500, Andrew Douglas Pitonyak wrote: I assume that this would check for an array as well. I would feel safer if pointers were set to NULL (or nullptr if we support C++11) since it is not safe to delete a pointer twice

Re: [Libreoffice] [MHST][Easy Hack] Get current page number for printing

2011-07-17 Thread Andrew Douglas Pitonyak
On 07/16/2011 05:02 AM, Ta Duc Tung wrote: Hi, 1. How to get current page number for printing? We've found a variable mnCurPage from printdlg.cxx but it seems not to be the right one. I think it is current page number for preview in print dialog. If I were writing a macro and I