No computer access, but my guess its that the problem its that the format is
set to an integer constant.
The correct method is to lookup the format index and create the format if it
does not exist.
I would explain more, but my phone is slow to use for this. Will have better
access in a few
Hopefully this will make it back top the list, Good call responding to the
list
I believe that you cannot have a view cursor unless you have a display. Some
work was done to improve things like maybe it will work if you load the
document and then hide it But that is a long shot. Off
. Do you want the
contained formula, a numeric value, or a string representation?
Oh, and David, I copied you with a BCC because I do not know if my post to
the list will go through based on the credentials used to send this email.
Andrew Pitonyak
On Sun, 30 Oct 2011 11:13:40 + (GMT), Tom
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
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
the
RPM meant for UI integration for gnome. I 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
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://www.pitonyak.org/oo.php
--
To unsubscribe e
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
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
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
el/Access. Not what I wan to do, and not what
LO community should like, but it seems like the best course of action
for this project.
>
> Dave,
>
> On Tue, May 10, 2016, at 02:19 PM,
Andrew Pitonyak wrote:
>
>> Dave, I am copying you directly since I do
not know if the email clie
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
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
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,
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
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
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
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
; " : 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
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,
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,
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
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
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
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
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
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
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
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
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
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
Thanks for testing. We now have three instances where this fails.
If you still want the document I can send it, but, I think that the list strips
attachments I would need to send it to you directly
Sent from BlueMail
On Oct 20, 2019, 11:00 PM, at 11:00 PM, Mauricio Baeza wrote:
>On Sun, 20
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.
>>
I think that I am missing something obvious. How do I change the latest version
from DRAFT to published so that people can download it?
On Thursday, October 01, 2020 02:12 EDT, Heiko Tietze
wrote:
Done, you are now the maintainer of this extension.
Many thanks for your contribution,
Heiko
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:
>>
>> Is anyone able to
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:
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
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
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
>
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.
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
--rem get
access to the documentdocument =
ThisComponent.CurrentController.Framedispatcher =
createUnoService("com.sun.star.frame.DispatchHelper") rem
------dim sText
sText = InputBox ("Ple
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,
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
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
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
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
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
On Monday, February 07, 2022 20:20 EST, "Michael D. Setzer II"
wrote:
=On 7 Feb 2022 at 17:17, Dave Barton wrote:
Subject: Re: [libreoffice-users] LibreOffice 7.3 not
working on Fedora 34??
To: users@global.libreoffice.org
From:0; Dave Barton
Date sent:
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
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
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
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.
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
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
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
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
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
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
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
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
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,
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
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:
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,
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
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
67 matches
Mail list logo
