Re: [libreoffice-users] Base macros

2024-03-25 Thread Andrew Pitonyak
end application in C++ and QT for specific collectibles and it will find the image using a naming scheme based on a catelog number (at least for the standard image). Probably a better solution.  Andrew Pitonyak On Monday, March 25, 2024 01:01 EDT, Edwin Humphries wrote:  Hi all, I have

Re: [libreoffice-users] how to generate a re-scaled column

2023-10-02 Thread Andrew Pitonyak
heet 2 then my formula changes to =Sheet2.A1/max(A1:A7) If I had used $Sheet1.A1/max(A1:A7) then the first reference would still reference $Sheet1 Andrew Pitonyak   -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lis

Re: [libreoffice-users] last cursor position

2023-07-23 Thread Andrew Pitonyak
I loaded a roughly 700 page document that had been saved on page 35. I was left on page 51 (of 683), which is really page 47 with the way that I modify page numbering in the book. Shift+F5 takes me back to page 35 (real page 31) where I had left off.  I am running on the latest release of

Re: [libreoffice-users] How to get the height of the text context

2023-04-27 Thread Andrew Pitonyak
I'm pretty sure I have an example that does something about it either in OOME or in andrewmacro.odt on my website, but I'm not in a position that I can verify that right now. Try www.pitonyak.org I think the link on the page is something like macros. ⁣Get BlueMail for Android ​ On Apr 27,

Re: [libreoffice-users] Database back end?

2023-02-18 Thread Andrew Pitonyak
I believe the first issue here is that I am not aware the method to use a base document as a back end and the same manner that you might contact say a different database using JDBC. So, I think you might need to use the API to manually manipulate the document which is very different than maybe

Re: [libreoffice-users] LibreOffice parent company

2023-02-18 Thread Andrew Pitonyak
Apache is not required to LibreOffice. I don't think I would classify LibreOffice as a company. ⁣Get BlueMail for Android ​ On Feb 18, 2023, 7:37 AM, at 7:37 AM, Amn Ojee Uw wrote: >New comer here! >What is the parent company of LibreOffice? Apache? > >-- >To unsubscribe e-mail to:

Re: [libreoffice-users] Basic Macros with Base

2023-01-26 Thread Andrew Pitonyak
I think in my AndrewBase.odt document that I previously referenced, that I wrote a routine to put quotes around things so that they would appear inside the strings but I would have to go back and double check. But yes, I think you need to do that. ⁣Get BlueMail for Android ​ On Jan 26, 2023,

Re: [libreoffice-users] Basic Macros with Base

2023-01-24 Thread Andrew Pitonyak
I have a guess since I was not previously aware of this method.  There is precedence for LO adding support for Microsoft Office (MSO) compatibility. I am guessing that this method was added for MSO compatibility with MS Access (but that is just a guess). I would assume, therefore, that it

Re: [libreoffice-users] Basic Macros with Base

2023-01-24 Thread Andrew Pitonyak
I am not familiar with "DoCmd.RunSQL", I will have to look it up (unless you have a few links).  Is DoCmd a server?  I have not used Base with Macros in a long time, but, last time I did, I was creating connections to a database and then running SQL commands using a connection object.  I

Re: [libreoffice-users] Macros in spreadsheets

2023-01-02 Thread Andrew Pitonyak
January 02, 2023 20:22 EST, Stephen Morris wrote:  On 3/1/23 09:13, Michael Tiernan wrote: > On 12/23/22 11:02 AM, Andrew Pitonyak wrote: >> If you are looking to cause functions to recalculate, > > Thanks for the reply. > > Here's the thing. It's not that I want to f

Re: [libreoffice-users] Macros in spreadsheets

2022-12-23 Thread Andrew Pitonyak
No computer access Right now so everything I say is going to be a guess. If you are looking to cause functions to recalculate, I think that might be a setting not related to macros. Because you can turn off auto recalculation. Also, you can force a full update. I know it's on the menu. I don't

Re: [libreoffice-users] File conversion issue

2022-11-30 Thread Andrew Pitonyak
things were going on in there. I think you can do the same with the doc x file, but I surely have not tried that but I thought I'd heard that that was possible. ⁣Get BlueMail for Android ​ On Nov 30, 2022, 6:24 AM, at 6:24 AM, "Bathula, Shiva Prasad" wrote: >Hi Andrew pito

Re: [libreoffice-users] File conversion issue

2022-11-29 Thread Andrew Pitonyak
Do you see any problems / errors when you attempt a specific document manually?  You claim that you cannot provide the example file, but, how much can you modify the example file and still demonstate the error?  I once had a file that caused a crash and it was related to an image in a frame

Re: [libreoffice-users] Writer doc not going back to where I exited

2022-11-24 Thread Andrew Pitonyak
Are you asking where your macros are stored. I am far from a computer for a few days, but, unless you manually moved them, they should still be in the original location... Probably similar to /home/tim/.config/libre office/3.5//basic If you make if into .config you can probably search

Re: [libreoffice-users] Searching for info gives nothing related to what I need?

2022-07-24 Thread Andrew Pitonyak
I have examples of creating your own dialogues in OOME  (book) on my website. I don't remember off hand if I have examples in andrewmacro, which is also available there for download. Sorry can't easily check I won't have access to my computer for another week. I never cared for the process of

Re: [libreoffice-users] ReDim Preserve (BASIC macro programming)

2022-07-10 Thread Andrew Pitonyak
I said but you can I don't have access to any materials or any way to test this, but I suspect it's because the array is initialized using the array function. If you run a quick test and initialize your array by defining the size and then manually setting the values, how better will work. I

Re: [libreoffice-users] ROUND function consistency

2022-06-05 Thread Andrew Pitonyak
Sorry, this is NOT a bug. This is exactly the result I expect if I was using VBA in MSO. Read on to find out why.  I say this without looking at the code, but, you specifically told LO to use the VBA version of rounding, which is NOT normal rounding. VBA rounding uses bankers rounding. 

Re: [libreoffice-users] Re: Script to parse spreadsheet and send to own database as CSV or JSON

2022-04-21 Thread Andrew Pitonyak
I cannot comment on things that are online, but I believe that you can automate LibreOffice using Python; even though I have never done it. Well I guess I don't remember if I've done it or not and done a lot of things I don't remember just a long time ago. Most of the automation I have done is

Re: [libreoffice-users] LibreOffice 7.3 not working on Fedora 34??

2022-02-07 Thread Andrew Pitonyak
the file of importance. In my case it was vmmon and vmnet (I ran this twice) for oyu it is probably soffice.bin /usr/src/kernels/$(uname -r)/scripts/sign-file sha256 ./MOK.priv ./MOK.der $(modinfo -n vmmon) Will this work? Probably not. If you are using Fedora, why not just use the versi

Re: [libreoffice-users] My Question About Security

2022-01-27 Thread Andrew Pitonyak
Sorry, my email software is insisting that I top post. I can write a macro that will cause all sorts of problems But by default you will be warned that a document or template had macros. And this is not limited to LO. I am not familiar with a mechanism that can push my files of the

Re: [libreoffice-users] Calc airithmetic snafu

2021-11-26 Thread Andrew Pitonyak
Left will return a string so convert to a number using value... Something like this =Value(left()) ⁣Get BlueMail for Android ​ On Nov 26, 2021, 9:12 AM, at 9:12 AM, "Hylton Conacher (ZR1HPC)" wrote: >Hi, > >Using LO 7.2.2.2 Calc on iMac 11.6.1(Big Sur). > >I have a data column that ends

Re: [libreoffice-users] Question

2021-10-06 Thread Andrew Pitonyak
I believe the default is no... Check your settings... Cannot check now (away from computer) Also, excel macros are not 100 percent supported. ⁣Get BlueMail for Android ​ On Oct 6, 2021, 7:19 AM, at 7:19 AM, sleepy wrote: >Does LibreOffice Calc have macros turned on by default? I accidently

Re: [libreoffice-users] Counting cells

2021-03-25 Thread Andrew Pitonyak
Not near a computer to test but I think you want the countif function ⁣Get BlueMail for Android ​ On Mar 25, 2021, 5:13 AM, at 5:13 AM, Joe Conner wrote: >I am confused about how to count a number of cells that have a number. >In Calc, if cells a1:a11 each may or may not have a number in it,

Re: [libreoffice-users] Basic macro to insert a custom shape into a page ?

2021-02-11 Thread Andrew Pitonyak
So my guess that you were using the gallery was wrong. On the bright side, I did figure out how to access the gallery :-) It looks like you were provided a solution with using a custom shape, another thing I have not done before! Good Luck! Andrew Pitonyak On Thursday, February 11, 2021 15

Re: [libreoffice-users] Basic macro to insert a custom shape into a page ?

2021-02-11 Thread Andrew Pitonyak
This might seem obvious, but:  1. What document type?  2. What is a "custom" shape? Do you mean com.sun.star.drawing.CustomShape, or do you mean a Custom Shape that you have added to a Library?  Not that I have never used Cutom Shapes in any way in LibreOffice, but i have written a Macro at

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

2020-10-02 Thread Andrew Pitonyak
Although I could manage it, I could no longer find it except to manage it... Cannot check it again until Sunday when I am again near a computer ⁣Sent from BlueMail ​ On Oct 2, 2020, 3:13 AM, at 3:13 AM, Heiko Tietze wrote: >On 01.10.20 22:11, Andrew Pitonyak wrote: >> I noticed

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

2020-10-01 Thread Andrew Pitonyak
1, 2020, 11:12 AM, at 11:12 AM, Dave Howorth wrote: >On Thu, 1 Oct 2020 15:59:01 +0200 >Heiko Tietze wrote: > >> Publishing is only possible for admins. We consider to make this >> available in future. I pushed the button now... > >Page not found > >> On 0

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

2020-10-01 Thread Andrew Pitonyak
Ahh... It all makes sense now... ⁣Sent from BlueMail ​ On Oct 1, 2020, 10:00 AM, at 10:00 AM, Heiko Tietze wrote: >Publishing is only possible for admins. We consider to make this >available in >future. I pushed the button now... > >On 01.10.20 14:37, Andrew Pitonyak wrote:

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

2020-10-01 Thread Andrew Pitonyak
On 30.09.20 21:16, Andrew Douglas Pitonyak wrote: > > 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

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

2020-10-01 Thread Andrew Pitonyak
Thanks, I will push a new version today ⁣Sent from BlueMail ​ On Oct 1, 2020, 2:14 AM, at 2:14 AM, Heiko Tietze wrote: >Done, you are now the maintainer of this extension. > >Many thanks for your contribution, >Heiko > >On 30.09.20 21:16, Andrew Douglas Pitonyak wrote: >

[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 Docu

Re: [libreoffice-users] Re: [6.4.2.2] How to set same font + size for all Text Body paragraphs?

2020-07-13 Thread Andrew Pitonyak
On Monday, July 13, 2020 16:26 EDT, Gilles wrote:  steveedmonds wrote > Possibly first you need to make sure that there is no direct formatting > applied to the paragraphs as this will override the style setting. Note > that clearing direct formatting will clear any bolding/italics and >

Re: [libreoffice-users] Confused with Macro results??

2020-07-04 Thread Andrew Pitonyak
--rem get access to the documentdocument   = ThisComponent.CurrentController.Framedispatcher = createUnoService("com.sun.star.frame.DispatchHelper") rem ------dim sText sText = InputBox ("Ple

Re: [libreoffice-users] Confused with Macro results??

2020-07-04 Thread Andrew Pitonyak
I think that the correct answer is that you simply write your own function.  That way you do not need to copy the long messy function and replace some text.  Based on what you just said, however, assume that the intent is that you will modify the active cell to refernece the values in

Re: [libreoffice-users] Confused with Macro results??

2020-07-04 Thread Andrew Pitonyak
Might I ask what you want the macro to do? Your macro confuses me a bit...  That said, the actual API has a very harsh learning curve (in my opinion). If I rip apart what I see, I would guess the following:  The user enters some text, which represents a set of cells separated by a comma. 

Re: [libreoffice-users] Bug selecting text using the API

2019-10-21 Thread Andrew Pitonyak
Can you report this? If not I will do so ⁣Sent from BlueMail ​ On Oct 21, 2019, 12:00 AM, at 12:00 AM, Mauricio Baeza wrote: >On Sun, 20 Oct 2019 23:41:50 -0400, Andrew Pitonyak > wrote: > >> Thanks for testing. We now have three instances where this fails. >>

Re: [libreoffice-users] Bug selecting text using the API

2019-10-20 Thread Andrew Pitonyak
20 Oct 2019 21:07:26 -0400, Andrew Douglas Pitonyak > wrote: > >> >> 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 we

[libreoffice-users] Bug selecting text using the API

2019-10-20 Thread Andrew Douglas Pitonyak
yIndex(i).getString(i) '  Next   Thiscomponent.getCurrentController.select(oFound) End Sub -- 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? https://www.libreoffice.org/get-help/ma

Re: [libreoffice-users] Reveal code, old macros convert them to LO

2019-07-04 Thread Andrew Pitonyak
Indeed... A single style may cause multiple changes. I don't remember how that is displayed in the macro. ⁣Sent from BlueMail ​ On Jul 4, 2019, 10:33 PM, at 10:33 PM, jomali wrote: >I don't remember the details of the sxw format. Perhaps reveal codes >were >appropriate then. However, ODF

Re: [libreoffice-users] Reveal code, old macros convert them to LO

2019-07-04 Thread Andrew Pitonyak
I don't think it was that much code. I might even have a working copy from a few years back, but won't have computer access until next week. Might have deleted it. If you can't make it work, remind me next week and I can take a look. ⁣Sent from BlueMail ​ On Jul 4, 2019, 11:04 AM, at 11:04

Re: [libreoffice-users] Reveal code, old macros convert them to LO

2019-07-04 Thread Andrew Pitonyak
just so we're clear, the macro functionality was not even close to the functionality in word perfect. all the macro did, was displaying a dialogue all of the codes. There is certainly a lot of use for this, but nothing near what you do automatically in word perfect. ⁣Sent from BlueMail ​ On

Re: [libreoffice-users] automatic font selection in macro

2019-02-13 Thread Andrew Pitonyak
really did need the font name), which would look at the text cursor and pull the current font and use that. Inserting text at a text cursor (view cursor) should also not have needed a font.  On Wednesday, February 13, 2019 00:51 EST, Thomas Blasejewicz wrote:  On 2019/02/13 13:26, Andrew

Re: [libreoffice-users] automatic font selection in macro

2019-02-12 Thread Andrew Pitonyak
if I wrote a macro that inserts the letter 'X', I would not expect the insertion to specify the font unless I went out of my way to do so. I am interested in seeing the macro that you are using. I'm not able right now to try to find a macro that would do what you want, but if you can't find

Re: [libreoffice-users] Libre Calc – Excel corrected?

2018-09-04 Thread Andrew Pitonyak
In Word, you can toggle among small case – initial caps - all caps easily – but not in Excel. Er, we are not talking about Word, either! Can you toggle among case sizes in Libre Calc? Not that I know of. But you could easily copy material into a text (Writer) document, modify it there,

Re: [libreoffice-users] Error When Closing Document Using Automation

2018-08-31 Thread Andrew Pitonyak
Sorry, I do not know what is going on, but DO you see anything different if you: 1. Pause for a few seconds before you call close? In the back of my mind I am wondering if for some silly reason, control returns to you before the save command finishes running. 2. out of curiousity,

Re: [libreoffice-users] Re: Calc macro: write korean characters in atext file

2018-08-30 Thread Andrew Pitonyak
; " : OK " End If s = s & "(" & sStrings(i) & ")" s = s & "(" & sInput & ")" & CHR$(10) Next oTextStream.closeInput() MsgBox s End Sub Let me know if this works, I believe that it will. I hope that

Re: [libreoffice-users] Calc

2018-08-10 Thread Andrew
other ones like "Draw" or "Base" I downloaded the newest version (besides the one for early adopters) hoping all the modules would be there. I didn't see anything about having to download them separately. Thanks for replying! On Fri, Aug 10, 2018 at 8:37 AM, Andrew <m

Re: [libreoffice-users] Calc

2018-08-10 Thread Andrew
On 10/08/18 10:44, Peggy wrote: All options but Writer are grayed out. I just installed the latest version. Is there something I can do to activate calc? Can you give some more info to work on please: OS, and by 'latest version' do you mean 6.1? If so, then you may want to report a bug and

Re: [libreoffice-users] LibO6.1 - no Quick-starter

2018-08-10 Thread Andrew
On 10/08/18 10:22, M Henri Day wrote: Den fre 10 aug. 2018 kl 10:44 skrev Andrew <mailto:phaedr...@gmail.com>>: On 10/08/18 09:37, M Henri Day wrote: > Den fre 10 aug. 2018 kl 10:04 skrev Andrew mailto:phaedr...@gmail.com> > <mailto:phaedr...@gmail.com <ma

Re: [libreoffice-users] LibO6.1 - no Quick-starter

2018-08-10 Thread Andrew
On 10/08/18 09:37, M Henri Day wrote: Den fre 10 aug. 2018 kl 10:04 skrev Andrew <mailto:phaedr...@gmail.com>>: Hi all Have just downloaded and installed LibreOffice Version: 6.1.0.3 for Linux Mint 19 ('Tara'). First off, thanks to all of the developers and team of

[libreoffice-users] LibO6.1 - no Quick-starter

2018-08-10 Thread Andrew
around? Anyway, thanks again to all involved. Great stuff and as always, I am very pleased my donations are being put to such a good investment. Best wishes Andrew -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists

Re: [libreoffice-users] Strange Macro folder behavior

2018-07-23 Thread Andrew Pitonyak
Many features are not available without Java so it lives on every computer that I own. I am not sure what the security risk is, but, since everything has one Happy to hear that your solved the problem and figured out where it is hiding. This is probably related to "where did I store my

Re: [libreoffice-users] Predefinied constants (Macro, Basic)

2018-07-23 Thread Andrew Pitonyak
of the list. Kind regards Johnny Rosenberg 2018-07-23 19:15 GMT+02:00 Andrew Pitonyak : You can enumerate those with: theTypeDescriptionManager There is a method EnumerateTypesTest. Notice that there is a typeArray. I have note tested this, but, I could likely use the following two

Re: [libreoffice-users] Predefinied constants (Macro, Basic)

2018-07-23 Thread Andrew Pitonyak
I have not looked at the predefined constants in a while, and I do not remember how I got my list, but it was probably by reading the code. WARNING: I am about to tell you to download a document containing macros. The document looks just fine if you tell it to disable macros, but, it is a

Re: [libreoffice-users] About pseudo objects with Basic code ...

2018-07-09 Thread Andrew Pitonyak
On 2018-07-09 14:21, Mauricio Baeza Servin wrote: On Mon, 09 Jul 2018 18:01:37 + (UTC), Andrew Pitonyak wrote: On 2018-07-09 13:25, Mauricio Baeza Servin wrote: > You can make; macros, functions of Calc (full integrated in function > wizard), extensions and new UNO comp

Re: [libreoffice-users] About pseudo objects with Basic code ...

2018-07-09 Thread Andrew Pitonyak
On 2018-07-09 13:25, Mauricio Baeza Servin wrote: You can make; macros, functions of Calc (full integrated in function wizard), extensions and new UNO components. This last part is very important for more serious programs. For certain serious integration, Basic fails, but it sounds like

Re: [libreoffice-users] About pseudo objects with Basic code ...

2018-07-09 Thread Andrew Pitonyak
Disclaimer: I have only used Python once to to talk to LO. In fact, I work pretty hard to write all of my "macros" in Basic because support is very consistent across platforms. I cannot comment directly on Python, but, in Basic, I do not need to worry about which interface handles which

Re: [libreoffice-users] Problems creating a split database

2018-03-06 Thread Andrew Pitonyak
Off hand, I think that you are moving in the right direction. I have not looked at this in a very long time, but, I do have some macro information for use with Base (Written against a much earlier version of Base) available here: http://www.pitonyak.org/database/ This is a direct link to

Re: [libreoffice-users] Macros : For Each Cell in LibreOffice Basic ?

2018-01-23 Thread Andrew Pitonyak
I remember writing code to go through cells... I don't remember if it was in AndrewMacro.odt or OOME.odt... Can't look it up now... Much depends on things like sizes and what you want to compare Coming off a long shift, need to sleep, if you can't find it, let me know. ⁣Sent from BlueMail

Re: [libreoffice-users] Importing a csv (tab delimited) to existing non-empty sheet (overwrite)

2017-11-20 Thread Andrew Pitonyak
http://www.pitonyak.org/database/ Look at my random DB ramblings I don't remember if I have better coverage they're pretty in my primary macro book http://www.pitonyak.org/oo.php But I do explain them, but I cannot check the documents from my phone... ⁣Sent from BlueMail ​ On Nov 20,

Re: Fwd: [libreoffice-users] Macro Dim Dialog and Control

2017-11-19 Thread Andrew Pitonyak
Sorry, using my phone for this... And off the top of my head... Each object usually supports multiple interfaces... In basic, the actual type does not matter. Names starting with an x refer to an interface. I need to look it up, but I think that the preference was a variant rather than

Re: [libreoffice-users] convert xlsx to CSV (and utf8?)

2017-08-29 Thread Andrew
Thank you, but I don't understand. On 08/28/2017 10:48 AM, leleu wrote: http://mooedit.sourceforge.net/ allow to "save as" changing the codage. Je la 28/08/2017 19:21, A skribis : Thank you for responding. Yes it opens without issue. Yet another look at the conversion details made me

Re: [libreoffice-users] convert xlsx to CSV

2017-08-29 Thread Andrew
Read .xlsx, write/convert to .csv format with utf8 characters. From the command line. On 08/28/2017 05:51 AM, James Knott wrote: Sorry, I misread. I thought you were trying to read a CSV. LibreOffice can read and write CSV. To save, just use Save As and select CSV for the filter. On

Re: [libreoffice-users] convert xlsx to CSV

2017-08-28 Thread Andrew
It opens just fine. On 08/27/2017 06:41 PM, James Knott wrote: On 08/27/2017 08:59 PM, A wrote: I'm trying to convert a file from .xlsx to CSV. After googling until my eyes were bleeding, the below is the best I could come up with. I've tried various incarnations of the below this is just

Re: [libreoffice-users] [macros] How to create a timer ?

2017-07-21 Thread Andrew Pitonyak
On 2017-07-21 11:30, Jean-Francois Nifenecker wrote: All, I'm looking for a way to create a timer in LibO Basic as a reminder to accomplish some task. The timer would be started when the document is opened, then would send a message to the user if he has not accomplished a particular task (eg

Re: [libreoffice-users] Calc macro tutorial

2016-05-11 Thread Andrew Pitonyak
no particular need to run where MSO is not supported, not a bad move. Good luck on your project. On 11.05.2016 08:42, dave boland wrote: > Andrew, > > Thanks for the note. I actually do software development (Java right now) and enjoy reading documentation (no, not crazy - I've been tested).

Re: [libreoffice-users] Calc macro tutorial

2016-05-10 Thread Andrew Pitonyak
office.org/en They have some very competent Macro people hanging out in the macro forums. Best of luck! Dave, -- dave boland dbola...@fastmail.fm Andrew Pitonyak -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mai

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

2016-02-12 Thread Andrew Douglas Pitonyak
iquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- Andrew Pitonyak My Macro Document: http://www.pitonyak.org/AndrewMacro.odt Info: http://www.pitonyak.org/oo.php -- To unsubscribe

Re: [libreoffice-users] Macro help

2016-01-06 Thread Andrew Pitonyak
Steve, I know a little bit about macros and I am willing to take a look, but, I am trying to avoid having to create a sample document to test what you are trying to do and I have very little time. can you send a sample Calc document to "and...@pitonyak.org" If possible: 1. Add your macro

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
://nabble.documentfoundation.org/OEditModel-set-focus-pre-select-all-text-tp4150087.html Sent from the Users mailing list archive at Nabble.com. -- 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

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

2015-05-14 Thread Andrew Douglas Pitonyak
some words in Writer or Calc. (3) Select the words and chage the color of words. (4) Writer still not chage it. Anybody has the same problem under Linux? Thanks -- Andrew Pitonyak My Macro Document: http://www.pitonyak.org/AndrewMacro.odt Info: http://www.pitonyak.org/oo.php -- To unsubscribe

Re: [libreoffice-users] Numbering formulas in Writer

2015-05-05 Thread Andrew Pitonyak
I always did this using a numerical sequence field; the same field type used for numbering tables. On May 5, 2015 12:08 PM, =?ISO-8859-1?Q?Kolbj=F8rn_Stuest=F8l?= kolbjo...@stuestoel.no wrote: Many places I am told that inserting formula numbering is quite simple. Write fn in a new line and

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

2015-04-20 Thread Andrew Douglas Pitonyak
Sub -- 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://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more

[libreoffice-users] Open File dialog is too large

2015-03-07 Thread Andrew Douglas Pitonyak
, but, if you ever see that problem, now you know what file is probably causing the issue. -- 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

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

2015-03-05 Thread Andrew Douglas Pitonyak
= oSheet.createSearchDescriptor() oSearch.setSearchString(comment) oSearch.setPropertyValue(SearchType, 2) x = oSheet.findFirst(oSearch) End Sub -- 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

Re: [libreoffice-users] Syntax highlighting

2015-03-04 Thread Andrew Douglas Pitonyak
that it supports your language. What language are you using? -- 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://www.libreoffice.org/get-help/mailing

[libreoffice-users] Installing LO using yum localinstall

2015-02-27 Thread Andrew Pitonyak
I use Fedora and I generally use yum localinstall to install my RPMs. I also add an exclude=libreoffice* in yum.conf so that yum does not try to update libreoffice when a new copy is pushed to the Fedora repositories. This then causes yum to ignore the RPMs that match the wild-card, so

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

2015-02-09 Thread Andrew Douglas Pitonyak
in time and money. The end result would still not provide 100% compatibility. So, I don't really expect it. -- 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

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

2015-02-06 Thread Andrew Douglas Pitonyak
on Linux. It looks like Word 2010 has 1507 crosstie downloads, so certainly some people are using older copies of Word. https://www.codeweavers.com/compatibility/browse/name/?app_id=6132;details=1 -- Andrew Pitonyak My Macro Document: http://www.pitonyak.org/AndrewMacro.odt Info: http

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

2015-02-05 Thread Andrew Douglas Pitonyak
don't remember what that is called off hand, or even if it is still required. I don't have time now to download and check the RPMs, but, if you send a list of RPMs, I can tell you which one it is. -- Andrew Pitonyak My Macro Document: http://www.pitonyak.org/AndrewMacro.odt Info: http

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

2015-02-05 Thread Andrew Pitonyak
Side note... You probably need to modify one of your yum configuration files to tell yum to ignore LO updates. On Feb 5, 2015 9:08 AM, Andrew Douglas Pitonyak and...@pitonyak.org wrote: On 02/05/2015 07:07 AM, Tom Davies wrote: Hi :) I think you can usually just install over the top

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

2015-02-05 Thread Andrew Pitonyak
down (i.e. the bar moves up from the bottom when I scroll down), (2) all checks in checkboxes are upside down, and (3) when I resize a window the expanded area is all dark! Has this happened to anyone else?? Thanks for your replies! On 05/02/2015, Andrew Douglas Pitonyak [via Document

Re: [libreoffice-users] [Calc] how to compare not exactly equal values?

2015-02-04 Thread Andrew Pitonyak
Subtract the numbers and check the absolute value On Feb 4, 2015 8:40 AM, gordom gord...@wp.pl wrote: Hallo everyone. I do realize my post title is not very descriptive. Sorry for that. I have 2 (or sometimes more) values (numbers) and want to compare them and check if they are more-less

Re: [libreoffice-users] syntax hilighter for writer

2015-01-28 Thread Andrew Douglas Pitonyak
://nabble.documentfoundation.org/syntax-hilighter-for-writer-tp4137845.html Sent from the Users mailing list archive at Nabble.com. -- 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

[libreoffice-users] Help with writer files

2015-01-24 Thread Andrew Miller
Everything was working great until two days ago, I can no longer read any of my saved files in doc format. It opens into garbled text like this: Íòmë #3jÄe_M?7kÒcŨWQyS#Cl¹jíŸ#ó�DÚ`WŽ{Œ#ñ·ÍÁ%×v#JÙ»HdÈ#\”†‡#|#îƒK«#�Mˆkûò¿¦Òi-##’´#ðáo¹#iû8ðª˜s!ô(Vò$¨eJD€PC9¥µWIv‰3…GÚÈ#ß

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

2015-01-24 Thread Andrew Douglas Pitonyak
don't consider LO usable until I have lowered the setting one level, which requires that I say yes / no for every document that I load that runs macros. I never set it to just run any macro. -- Andrew Pitonyak My Macro Document: http://www.pitonyak.org/AndrewMacro.odt Info: http

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

2015-01-04 Thread Andrew Douglas Pitonyak
this? I am running Windows 7 -- 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://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe

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
) and an explanation. Thanks to all for the pointers and thanks to Jim Caughran for the exchange that then had me thinking about this. -- 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

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

2015-01-01 Thread Andrew Douglas Pitonyak
to test this. Any insights into this? -- 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://www.libreoffice.org/get-help/mailing-lists/how

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] Fields always marked as spelling errors

2014-12-30 Thread Andrew Pitonyak
installed on a Windows box included Lightproof grammar checker. Thanks, and have a great New Year. Happy new year to you as well. Andrew Pitonyak -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how

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

2014-12-18 Thread Andrew Douglas Pitonyak
/viewtopic.php?f=83t=40493 -- 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://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe

Re: [libreoffice-users] Adequate API

2014-12-14 Thread Andrew Douglas Pitonyak
cursor object supports this call directly. Now i think that I am rambling. Oh, and I see a real need for a simplified API but I do not have the time to lead such an effort; sadly. -- Andrew Pitonyak My Macro Document: http://www.pitonyak.org/AndrewMacro.odt Info: http://www.pitonyak.org/oo.php

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

2014-12-10 Thread Andrew Douglas Pitonyak
, aLocale) Hope this helps. AndrewMacro.odt is a good place to find specific focused examples. OOME_3_0.odt contains numerous examples, but is more focused towards learning. -- Andrew Pitonyak My Macro Document: http://www.pitonyak.org/AndrewMacro.odt Info: http://www.pitonyak.org/oo.php

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
://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- Andrew Pitonyak My Macro

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

2014-12-01 Thread Andrew Douglas Pitonyak
? If not, my apologies. I was curious if any Linux users have used the Sphinx application and how well it's worked? Thanks so much. Charles. -- Andrew Pitonyak My Macro Document: http://www.pitonyak.org/AndrewMacro.odt Info: http://www.pitonyak.org/oo.php -- To unsubscribe e-mail to: users

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

2014-11-21 Thread Andrew Douglas Pitonyak
it into a bigger PNG?). Paddy -- View this message in context: http://nabble.documentfoundation.org/How-does-4-4-compress-PDFs-so-well-Is-there-a-quality-problem-tp4129492p4129794.html Sent from the Users mailing list archive at Nabble.com. -- Andrew Pitonyak My Macro Document: http://www.pitonyak.org

  1   2   3   4   5   6   >