Re: off-list Re: [libreoffice-users] Date changes to a 5 digit number

[Andrew Pitonyak]

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 days if needed.

There is an example in andrewmacro.odt I believe.

Hth

Sent from my Samsung Epic™ 4G

Tom Davies tomdavie...@yahoo.co.uk wrote:

Hi :)
Looks like the code didn't get to the list so here it is 



REM  *  BASIC  *

Sub Main

End Sub






sub Insert_Line_and_Date
rem
    
--
rem define variables
dim document  as object
dim dispatcher as object
rem
    
--
rem get access to the document
document  = ThisComponent.CurrentController.Frame
dispatcher =
    createUnoService(com.sun.star.frame.DispatchHelper)

rem
    
--
dim args1(1) as new com.sun.star.beans.PropertyValue
args1(0).Name = GraphicName
args1(0).Value = 
args1(1).Name = IsSimpleLine
args1(1).Value = true

dispatcher.executeDispatch(document,
    .uno:InsertGraphicRuler, , 0,
args1())

rem
    
--
dim args2(5) as new com.sun.star.beans.PropertyValue
args2(0).Name = Type
args2(0).Value = 0
args2(1).Name = SubType
args2(1).Value = 0
args2(2).Name = Name
args2(2).Value = 
args2(3).Name = Content
args2(3).Value = 0
args2(4).Name = Format
args2(4).Value = 5122
args2(5).Name = Separator
args2(5).Value =  

dispatcher.executeDispatch(document, .uno:InsertField,
    , 0, args2())

rem
    
--
dim args3(0) as new com.sun.star.beans.PropertyValue
args3(0).Name = Text
args3(0).Value = , 

dispatcher.executeDispatch(document, .uno:InsertText,
    , 0, args3())

rem
    
--
dim args4(1) as new com.sun.star.beans.PropertyValue
args4(0).Name = Template
args4(0).Value = Heading 1
args4(1).Name = Family
args4(1).Value = 2

dispatcher.executeDispatch(document, .uno:StyleApply,
    , 0, args4())


end sub



Regards from
Tom :)






 From: . l...@ebookring.net
To: Tom Davies tomdavie...@yahoo.co.uk 
Sent: Saturday, 27 October 2012, 18:37
Subject: Re: off-list  Re: [libreoffice-users] Date changes to a 5 digit number
 

Tom,

Did my code message get to the list?  I know you replied with it
  but it seems there's no option for me to reply to the list.

Thanks,

Carl



On 10/27/2012 01:33 PM, Tom Davies wrote:

snip /





 From: . l...@ebookring.net
To: Tom Davies tomdavie...@yahoo.co.uk 
Sent: Saturday, 27 October 2012, 18:29
Subject: Re: [libreoffice-users] Date changes to a 5 digit number
 
On 10/27/2012 01:06 PM, Tom Davies wrote:
 Hi :)
 Can you copypaste the macro's code into a
    reply as text?  If we could see the code then some
    people here might be able to spot the error.
 Good luck and regards from
 Tom :)

Here's the code-

REM  *  BASIC  *

Sub Main

End Sub






sub Insert_Line_and_Date
rem
    
--
rem define variables
dim document  as object
dim dispatcher as object
rem
    
--
rem get access to the document
document  = ThisComponent.CurrentController.Frame
dispatcher =
    createUnoService(com.sun.star.frame.DispatchHelper)

rem
    
--
dim args1(1) as new com.sun.star.beans.PropertyValue
args1(0).Name = GraphicName
args1(0).Value = 
args1(1).Name = IsSimpleLine
args1(1).Value = true

dispatcher.executeDispatch(document,
    .uno:InsertGraphicRuler, , 0,
args1())

rem
    
--
dim args2(5) as new com.sun.star.beans.PropertyValue
args2(0).Name = Type
args2(0).Value = 0
args2(1).Name = SubType
args2(1).Value = 0
args2(2).Name = Name
args2(2).Value = 
args2(3).Name = Content
args2(3).Value = 0
args2(4).Name = Format
args2(4).Value = 5122
args2(5).Name = Separator
args2(5).Value =  

dispatcher.executeDispatch(document, .uno:InsertField,
    , 0, args2())

rem
    
--
dim args3(0) as new com.sun.star.beans.PropertyValue
args3(0).Name = Text
args3(0).Value = , 

dispatcher.executeDispatch(document, .uno:InsertText,
    , 0, args3())

rem
    

Re: [libreoffice-users] Re: Macro from command line: ThisComponent.CurrentController not found

[Andrew Pitonyak]

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 hand I don't think 
that you can understand much related to position such add page number without a 
view. All of the other cursors so not provide this information.

After saying that... I expect that PDF export needs a way to understand page 
numbers and it sounds like you can do that without a view... So perhaps I am 
mistaken. My best guess is that it only matters of page numbers are displayed 
in the document and that uses field which should have a display value stored 
but not updated without the view.

Not sure is this helps...


greyspammer greyspam...@postino.ch wrote:

A user who could not post directly to the list because he was using his phone
with a non-matching e-mail address asked me why I was using
CurrentController. I think I better write the answer to the list so everyone
can participate.

The macro is rather complex. The documents are invoices containing text
table with a list of items and their prices. They are created by a
third-party program. I supply a template and the program fills in the data
from its database.

Now, it can happen that the table with the items is longer than one page
(even longer than two or three) pages. The macro will detect this and split
the table at those places, adding a subtotal to the foot of each page and a
carry over on the start of the next page. I plan to add this macro to the
template so that it automatically executes when a PDF is generated.

Example: The document I get looks like this (I hope the layout survives ;)):

- snip -

- snap -

After the macro is done, the document looks like this:

- snip -

- snap -

As you can see, it's pretty complex and due to the lack of documentation,
the only way to achieve this result was to replicate the steps I would
otherwise do manually. That means getting a view cursor (which is a part of
the current controller). Then I use my view cursor to do the stuff. I put it
in the last column of the first row. Then I go down cell by cell, summing up
values on way. Until the page changes. Then I go back up, insert subtotal
and carry over and finally split the table between them.

If there is another way to do it without CurrentController, I have not found
it.

If it helps, I can post the macro but it's a bit lengthy...



--
View this message in context: 
http://nabble.documentfoundation.org/Macro-from-command-line-ThisComponent-CurrentController-not-found-tp4074374p4074502.html
Sent from the Users mailing list archive at Nabble.com.

-- 
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: 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

-- 
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: 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

Re: [libreoffice-users] Macros

[Andrew Pitonyak]

Spotty access to email and short on time 

The included help does not include API level documentation since most
people have no need for it.

Sadly, I have no ability at the moment to generate an example, but, you
can find numerous examples in AndrewMacro.odt for this. I believe that
there will be a better explanation in OOME as available on my web site. If
you download that and it does not yet contain Calc examples, shoot me a
private email and I will push a copy that (although incomplete) will
contain an example of how this is done. 

In brief, the idea is that you:

1. Obtain a reference to the document. If it is the current document, then
you can use the variable ThisComponent.

2. Get a reference to the sheet containing the cell. In most cases, you
can do something like the following:

ThisComponent.sheets.getByIndex(0)  ' Get the first sheet
ThisComponent.sheets.getByName(Investments) ' Get a sheet by name

Sometimes you simply want to get the currently active sheet, which is a
bit more difficult. It probably looks something like the follow (from
memory so I am probably wrong).

ThisComponent.CurrentController.ActiveSheet

After you have the sheet, then you can get the cell. Again, this is all
from memory, so I am likely totally wrong, but it probably looks something
like:

oSheet.getCellByPosition(1,2) 'Cell B3
oSheet.getCellRangeByName(B3)

A cell range with a single cell returns that cell I believe.

Next, you must decide how to get the contents of the cell. 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 Davies
tomdavie...@yahoo.co.uk wrote:
 Hi :)
 There are various books and guides about Macros.  I've been told by
 various people that Andrew Pitonyak's is excellent.  Hopefully the link
is
 on this page
 http://wiki.documentfoundation.org/Documentation/Publications
 
 I'm not sure if that will help with the specific problem as we might
need
 to collect links to more external resources onto that page.  
 Regards from
 Tom :)
 
 
 --- On Sat, 29/10/11, David S. Crampton david_cramp...@ie2b.com wrote:
 
 From: David S. Crampton david_cramp...@ie2b.com
 Subject: [libreoffice-users] How may I read the value of a cell into a
 macro variable?
 To: users@global.libreoffice.org
 Date: Saturday, 29 October, 2011, 0:44
 This question has two parts: simple
 and more complex:
 
 simple: I wish to read the value of the currently selected
 cell (in Calc, of course) into a variable in the macro
 language (Libre Basic).  Script example please. and
 thank you!
 
 more complex: AFAIK the LibreHelp does not document the
 stuff like:
 
 dispatcher.executeDispatch(document, .uno:GoToCell, ,
 0, args2())
 
 I used to be pretty skilled at recording macros and then
 modifying them. Where do I go to find things related to
 uno:GoToCell?  Universal Network Objects?  Can't
 find the starting point.
 
 Thank you for an orientation,
 --David S. Crampton
 
 --For unsubscribe instructions e-mail to:
 users+h...@global.libreoffice.org
 Problems?
 http://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
 


-- 
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://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

Re: [libreoffice-users] Fields always marked as spelling errors

[Andrew Pitonyak]

This time I will reply using a computer so that I can more easily 
respond to the list rather than directly...


On 30.12.2014 09:59, CVAlkan wrote:
This is a trivial issue, but every field in my Writer documents is 
displayed
with a blue squiggly line beneath it just as if it were a spelling 
error.
I've looked around in vain for a way to disable spell checking of 
fields (if

that is indeed what is causing the annoyance).


Grammar checker

By field I mean things like page numbers, cross-references and 
such.
Cross-references to reference rather than page number seem to be 
a
special case, though, as sometimes they only have the squiggly line 
in
footnotes, but sometimes it appears in both body text as well as 
footnotes.


I did a quick check on a computer using the latest version of LO and 
the grammar checker did not seem to complain about things that I created 
as a test and did not flag numbers



The Tools|Options sections of Writer only seem to permit changing (or
eliminating) the normal background color used to mark the fields, and 
I was

unable to locate anything in the spell check stuff to ignore fields.

This is obviously a pretty trivial thing, but if anyone knows why 
this
happens or if there is anything I can do to clean up the display I 
would

appreciate it.


I am clueless about this (sadly). try making some changes at Tools | 
Options | Language Settings and from there you can look at Writing 
Aids and English sentence checking.


The version I just 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-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

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

[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 equal. Let say the condition is 
 fulfilled if the numbers are exactly equal or the difference is not 
 higher than (+/-) 1. 
 Here is the example: 

 3,1 3 TRUE 
 5,9 6 TRUE 
 7 -5 FALSE 
 10 9 TRUE 
 -6 -6 TRUE 

 Any clues how I can do this? 
 Regards, 
 gordom 

 -- 
 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: 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 

-- 
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: 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

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

[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 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 when you do so you can keep the User 
  Profile so that all your settings, configs, galleries, 
  Extensions/add-ons/plugins, templates and all the rest remain intact. 
  It's quite a good idea to create a copy of your User Profile every so 
  often so that it's easier to get back to a configuration you liked if 
  anything crazy ever happens. 
  
  It's the price of getting a much newer and more updated version. 
  Windows users always have to install any programs this way so it's a 
  bit like going back to Windows for a little moment. 
  
  Regards from 
  Tom :) 
  
  
  
  On 5 February 2015 at 11:58, avamk avkapl...@gmail.com wrote: 
  I see. If I install LibreOffice 4.4 manually (via the RPM I'm 
  guessing?) can I just install a newer version over it once it's 
  released, or do I have to remove the whole thing before installing an 
  update? Thanks! 
  
  On 05/02/2015, timllloyd [via Document Foundation Mail Archive] 
  ml-node+s969070n4138820...@n3.nabble.com wrote: 
  
  Hi, the best suggestion is to grab the latest from the LO site (you will 
  have to monitor the site for updates): 
  
  http://www.libreoffice.org/ 
  
  As well as monitoring for updates you also have to install  remove 
  manually. As you are using Fedora I assume you are familiar with that 
  process but any problems pls sing out. 
  
  Cheers 
  
  On 05/02/15 11:59, avamk wrote: 
  Hello, 
  
  LibreOffice in the Fedora 21 repositories are currently in the 4.3 
  series. 
  Is there an updated LibreOffice repository for Fedora 21 (and also 
  future 
  versions) that have LibreOffice 4.4? I like to use the newest version of 
  LibreOffice on Fedora if possible. Thanks! 
  
 with Fedora 21 I have been using the standard Fedora release, but, if 
 you do not, I think that you can remove the existing using yum... 

 Is it installed? 

 yum list installed | grep libreoffice 

 I expect that you can remove it using 

 yum remove libreoffice* 

 I have always used yum localinstall *.rpm to install the RPMs after I 
 extract the code. 

 Last time I did this, there was a GUI integration driectory under the 
 standard RPM directory. I changed to that directory  and installed 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://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: 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 

-- 
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: 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

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

[Andrew Pitonyak]

As root, edit /etc/yum.conf

In the [main] section append a line like

  exclude=libreoffice*

On Feb 5, 2015 9:37 AM, avamk avkapl...@gmail.com wrote:

 OK, I followed everyone's tips and was able to replace the Fedora 
 repository-installed LibreOffice 4.3 with 4.4 installed from the RPMs 
 downloaded from the LibreOffice site!! 

 Sorry I've never tinkered with YUM configuration before, how to I 
 modify it to ignore LibreOffice updates? 

 Another strange thing is that when (and only when) I enable Use 
 OpenGL for all rendering in options, (1) all vertical scroll bars 
 become upside 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 Foundation Mail 
 Archive] ml-node+s969070n413...@n3.nabble.com wrote: 
  
  
  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 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 when you do so you can keep the User 
   Profile so that all your settings, configs, galleries, 
   Extensions/add-ons/plugins, templates and all the rest remain intact. 
   It's quite a good idea to create a copy of your User Profile every so 
   often so that it's easier to get back to a configuration you liked if 
   anything crazy ever happens. 
   
   It's the price of getting a much newer and more updated version. 
   Windows users always have to install any programs this way so it's a 
   bit like going back to Windows for a little moment. 
   
   Regards from 
   Tom :) 
   
   
   
   On 5 February 2015 at 11:58, avamk avkapl...@gmail.com wrote: 
   I see. If I install LibreOffice 4.4 manually (via the RPM I'm 
   guessing?) can I just install a newer version over it once it's 
   released, or do I have to remove the whole thing before installing an 
   update? Thanks! 
   
   On 05/02/2015, timllloyd [via Document Foundation Mail Archive] 
   ml-node+s969070n4138820...@n3.nabble.com wrote: 
   
   Hi, the best suggestion is to grab the latest from the LO site (you 
   will 
   have to monitor the site for updates): 
   
   http://www.libreoffice.org/ 
   
   As well as monitoring for updates you also have to install  remove 
   manually. As you are using Fedora I assume you are familiar with that 
   
   process but any problems pls sing out. 
   
   Cheers 
   
   On 05/02/15 11:59, avamk wrote: 
   Hello, 
   
   LibreOffice in the Fedora 21 repositories are currently in the 4.3 
   series. 
   Is there an updated LibreOffice repository for Fedora 21 (and also 
   future 
   versions) that have LibreOffice 4.4? I like to use the newest version 
   of 
   LibreOffice on Fedora if possible. Thanks! 
   
  with Fedora 21 I have been using the standard Fedora release, but, if 
  you do not, I think that you can remove the existing using yum... 
  
  Is it installed? 
  
  yum list installed | grep libreoffice 
  
  I expect that you can remove it using 
  
  yum remove libreoffice* 
  
  I have always used yum localinstall *.rpm to install the RPMs after I 
  extract the code. 
  
  Last time I did this, there was a GUI integration driectory under the 
  standard RPM directory. I changed to that directory  and installed 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://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: 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 
  
  -- 
  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: 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

[libreoffice-users] Installing LO using yum localinstall

[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 dependencies fail, and it refuses to install until I 
remove the exclude from yum.conf.



So,

is setting the exclude no longer needed in yum.conf as long as I keep 
up with the latest releases?


should I just use rpm to install this?

did I do something wrong?

Just looking for thoughts.

--
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: 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

Re: [libreoffice-users] Numbering formulas in Writer

[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 press the F3 key. 
 In my copy of LibreOffice 4.4.2.2 (Windows) I am not able to do this. 
 Instead I get a message that LibreOffice did not find autotext for the 
 short cut fn or something like that. (It works in my copy of 
 OpenOffice 3.2). 
   I think it has to do with some settings somewhere but am not able to 
 find out where. 
 Some suggestions? 

 Kolbjoern 

 -- 
 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: 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 

-- 
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: 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

Re: [libreoffice-users] Macro help

[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 to the document.
2. make sure the document contains the named range with appropriate 
data.
3. Indicate exactly what parameters should be used to call the function 
and what you expected the result to be.


I know, it is a lot to ask, but otherwise I need to set all that up 
myself and I think it would be much faster for you (since you probably 
already have this).


On 06.01.2016 15:19, Steve Edmonds wrote:

Hi.
I am hoping someone on this list is a lot better with accessing Calc
functions in a macro than I am, I have have struggled with this for a
day and resorted to a cheat in frustration.
I had an equation 300 characters long in a group of cells and decided
to replace it with a function as it is something I use on a regular
basis.

The macro (below) looks up the first column of named range RngName to
find the position of value and interpolates between the tabulated 
data

before and after value to determine an interpolated number cdgv at
value. I have yet to add any validity checking.
The cheat I added was to pass the first column of RngName as its own
named range for use in the MATCH function.
In a sheet I can use =MATCH(472,INDEX(CdG1data,,1)) where 472 would
be value, CdG1data would be RngName but I just can't get this to work
in my macro.


Function VLinterp(value, RngName, offset, firstcol)
REM firstcol is named range first column of RngName
   fc=createUnoService("com.sun.star.sheet.FunctionAccess")
   rowBefore = fc.callFunction("Match", Array(value,
ThisComponent.NamedRanges.getByName(firstcol).ReferredCells))
   v1 = fc.callFunction("Index",

Array(ThisComponent.NamedRanges.getByName(RngName).ReferredCells,rowBefore,1)
   v2 = fc.callFunction("Index",

Array(ThisComponent.NamedRanges.getByName(RngName).ReferredCells,rowBefore+1,1)
   cdg1 = fc.callFunction("Index",

Array(ThisComponent.NamedRanges.getByName(RngName).ReferredCells,rowBefore,offset)
   cdg2 = fc.callFunction("Index",

Array(ThisComponent.NamedRanges.getByName(RngName).ReferredCells,rowBefore+1,offset)

   cdgv = cdg1+(cdg2-cdg1)*(value-v1)/(v2-v1)
   VLinterp = cdgv
End Function

Any help appreciated,
Steve


--
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: 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

Re: [libreoffice-users] Calc macro tutorial

[Andrew Pitonyak]

 

For most users, the recorder is a decent solution. 

As for support,
do not expect that from MS unless you have a credit card. I found some
bugs in their C++ compiler about 15 years ago. 5 to 10 years later I
thought for sure they would have fixed them. Nope, I had to work around
them yet again. It had to do with their streaming classes. There was a
failure when the  boundary was split by a buffer read for some
built-in text reading routines. Not like I could just call MS and get
support. 

For sure they have a better object layer for manipulating
documents. Not even close. I have never looked at their Macro
programming resources, but, if possible, be certain to use the .NET
classes since VBA is still littered with bugs. Last time I wrote a VBA
application, half my code was related to working around bugs in their
language implementation. These bugs initially existed in OpenOffice.org,
but were fixed years ago; for example, bugs related to determining an
arrays size in certain circumstances. I had to write special routines to
deal with these issues. Moving to the .NET versions made things really
nice, however, with full access to the .NET container classes. 

If you
have 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). But when I read a document called "Getting
Started With Macros", I reasonably expect it to cover the basics of how
to create a macro from scratch - like I would with a VB program (did
that for 6 years). I was disappointed to see that it was about using the
macro recorder, which will not work for me. 
> 
> I get that the authors
are volunteers, and that generally the do a fantastic job. However, in
this area, not so much. 
> 
> I've decided that in the short term Calc
(and Base) will not fit my needs (documentation, support concerns) and
will move the data to Excel/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 client I am currently using will copy to the list;
sorry about that, but I thought you might like my response faster than
several hours from now when I am using my standard email client. 
>> 
>>
On 10.05.2016 13:52, dave boland wrote: 
>> 
>>> I want to automate a
Calc spreadsheet to do some data analysis. I need some help finding a
complete tutorial on Calc macros. Looking for something like the books
published for Excell.
>> 
>> Not familiar with them 
>> 
>>> I read the
documentation, but it says user created macros are beyond the scope of
the documentation. REALLY! What the heck is the documentation for
then?
>> 
>> Done by volunteers and the documentation at which you
looked was beyond their scope. 
>> 
>>
http://www.odfauthors.org/libreoffice/english/calc-guide/published-lo-4.1
[1] 
>> 
>> Chapter 12 specifically says "Macros"
http://www.odfauthors.org/libreoffice/english/calc-guide/published-lo-4.1/cg4-1-ch12-calc-macros/view
[2] 
>> 
>> Chapter 13 contains numerous macro tutorials and examples
(well, it did when I wrote the first draft some years back)
http://www.odfauthors.org/libreoffice/english/calc-guide/published-lo-4.1/cg4-1-ch13-calc-as-simple-database/view
[3] 
>> 
>> Or, try here: http://www.pitonyak.org/oo.php [4] This site
contains numerous documents. You might want to look at these two
documents. The first is a book and the second is more of a list of
macros that accomplish certain tasks. It is kind of a roughly sorted
brain dump. 
>> 
>> http://www.pitonyak.org/OOME_3_0.odt [5]
http://www.pitonyak.org/AndrewMacro.odt [6] 
>> 
>> Tri
>> 
>>> ote
type="cite" style="padding-left:5px; border-left:#1010ff 2px solid;
margi
>> idth:100%"> 
>> 
>> Tried the web version of this mail group,
but it would not accept the catcha code. 
>> 
>> Hate those!
> 
> -- 
>
dave boland 
> dbola...@fastmail.fm 
> 
> -- 
> http://www.fastmail.com
- Access all of your messages and folders
> wherever you are




Links:
--
[1]
http://www.odfauthors.org/libreoffice/english/calc-guide/published-lo-4.1
[2]
http://www.odfauthors.org/libreoffice/english/calc-guide/published-lo-4.1/cg4-1-ch12-calc-macros/view
[3]
http://www.odfauthors.org/libreoffice/english/calc-guide/published-lo-4.1/cg4-1-ch13-calc-as-simple-database/view
[4]
http://www.pitonyak.org/oo.php
[5]
http://www.pitonyak.org/OOME_3_0.odt
[6]
http://www.pitonyak.org/Andre

Re: [libreoffice-users] Calc macro tutorial

[Andrew Pitonyak]

Dave, I am copying you directly since I do not know if the email client 
I am currently using will copy to the list; sorry about that, but I 
thought you might like my response faster than several hours from now 
when I am using my standard email client.


On 10.05.2016 13:52, dave boland wrote:
I want to automate a Calc spreadsheet to do some data analysis.  I 
need

some help finding a complete tutorial on Calc macros.  Looking for
something like the books published for Excell.


Not familiar with them


I read the documentation, but it says user created macros are beyond 
the
scope of the documentation. REALLY!  What the heck is the 
documentation

for then?


Done by volunteers and the documentation at which you looked was beyond 
their scope.


http://www.odfauthors.org/libreoffice/english/calc-guide/published-lo-4.1

Chapter 12 specifically says "Macros"
http://www.odfauthors.org/libreoffice/english/calc-guide/published-lo-4.1/cg4-1-ch12-calc-macros/view

Chapter 13 contains numerous macro tutorials and examples (well, it did 
when I wrote the first draft some years back)

http://www.odfauthors.org/libreoffice/english/calc-guide/published-lo-4.1/cg4-1-ch13-calc-as-simple-database/view

Or, try here:
http://www.pitonyak.org/oo.php
This site contains numerous documents. You might want to look at these 
two documents. The first is a book and the second is more of a list of 
macros that accomplish certain tasks. It is kind of a roughly sorted 
brain dump.


http://www.pitonyak.org/OOME_3_0.odt
http://www.pitonyak.org/AndrewMacro.odt


Tried the chat, wants to know what channel.  What the heck is that?


No idea.


Tried the web version of this mail group, but it would not accept the
catcha code.


Hate those!


I'm growing frustrated and very angry.


Wait until you try to write macros. I mean, ummm, sorry you are 
frustrated and angry.


LO Macros are very powerful in that they directly use the internal 
object structure and it is easy to add support for other languages. The 
disadvantage is that it has a steep learning curve, especially if you do 
not already understand software development. I usually recommend that 
people begin with an example that is close to what they need. The 
general language structure is essentially identical, but, for the most 
part, document manipulation methods is very different.



This is supposed to be user support?


It is community support. You did not pay for the product and the people 
who will now try to help you are all volunteers; they do it because they 
like to help people as part of a community.


If you do not care for email type support, be sure to check out this 
forum


https://forum.openoffice.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/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

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

[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 validating a particular dialog) when a delay expires (eg 2
hrs).

In fact I'm in need of several timers for the same document to handle
as many different delays/tasks.


Can anyone point me to some direction as I'm currently in the dark?


Thanks in advance.
Best regards,
--
Jean-Francois Nifenecker, Bordeaux



My gut reaction is that this is not directly supported in Basic.

That said, read these posts:

https://forum.openoffice.org/en/forum/viewtopic.php?f=44=59369

https://forum.openoffice.org/en/forum/viewtopic.php?f=9=33935

Sadly, this post references something implemented in BeanShell that 
would have helped, but it references a now defunct forum with the 
solution (so when they say that MS777 developed a solution and provides 
a link, that link is no longer valid).


http://ooo-forums.apache.org/en/forum/viewtopic.php?t=65864=292463




--
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: 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

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

[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, 2017, 4:47 PM, at 4:47 PM, Johnny Rosenberg  
wrote:
>Hi!
>
>I have some problems to find information about this. All I found after
>hours of searching are few examples that probably work in some
>situations
>but certainly not what I'm looking for,
>
>The problem is that those examples contains a lot of anonymous numbers
>and
>stuff but no explanation what so ever what those numbers mean or where
>I
>can find the details.
>
>Here's the closest thing I came up with so far:
>Sub Main
>Dim HOME As String
>Dim DirName As String
>Dim FileName As String
>Dim Args(1) As new com.sun.star.beans.PropertyValue
>
>HOME="/home/"
>DirName = HOME & "/Some/Path/"
>FileName = ConvertToURL(DirName & "/MyFile.csv")
>' Get the latest results.
>Shell(HOME & "/bin/ScriptThatCreatesMyFile.sh", True)
>Args(0).Name = "FilterName"
>Args(0).Value = "Text - txt - csv (StarCalc)"
>Args(1).Name = "FilterOptions"
>Args(1).Value = "44,34,76,1,,0,False,True,True,False"
>StarDesktop.loadComponentFromURL(FileName, "_default", 2, Args())
>End Sub
>
>Questions:
>Exactly what does ”44,34,76,1,,0,False,True,True,False” mean? Where can
>I
>find information about this? What is True? What is False? Why is
>something
>missing between two commas? Many questions come to my mind…
>
>Problems at the moment:
>
>1. The code above seems to treat my file as comma separated. I need TAB
>   only as separator.
>   2. The CSV file is imported to a new window. I want it to overwrite
>existing (old and outdated) information in columns A:D (without messing
>   with my conditional and unconditional formatting) on Sheet 0.
>
>After som further experimenting I seem to have solved problem 1. It
>seems
>lik means Chr(44), which is a comma, and Chr(34) os a double quote. The
>following line gave me separate columns for every TAB:
>Args(1).Value = "9,,76,1,,0,False,True,True,False"
>But what does the rest mean? Chr(76)="L", which seems weird, so I guess
>the
>”76” means something else.
>
>I wonder why this kind of information is so hard to find. For easy
>stuff,
>when no manual is needed, you can find tons of information, but when
>things
>are a bit more cryptic, when a manual is really, really needed, you can
>search for hours and find nothing, as it seems. Maybe I'm wrong, I
>actually
>hope I am, even if I would look stupid… :P
>
>
>
>Kind regards
>
>Johnny Rosenberg
>
>--
>To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
>Problems?
>https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
>Posting guidelines + more:
>https://wiki.documentfoundation.org/Netiquette
>List archive: https://listarchives.libreoffice.org/global/users/
>All messages sent to this list will be publicly archived and cannot be
>deleted

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

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

[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 
object, but...

It may no longer matter

The developer who told me this could not remember why it when it mattered

And

I only had a problem because of it once, and that was years ago.

Other languages, like Java, it matters. I'd we had a smarter IDE it might be 
useful to declare the actual type.



⁣Sent from BlueMail ​

On Nov 19, 2017, 5:31 PM, at 5:31 PM, Johnny Rosenberg  
wrote:
>Oops, sorry. I did it again, I accidentally replied privately rather
>than
>to the list. I'm sorry for that, Robert.
>
>-- Forwarded message --
>From: Johnny Rosenberg 
>Date: 2017-11-19 23:19 GMT+01:00
>Subject: Re: [libreoffice-users] Macro Dim Dialog and Control
>To: Robert Großkopf 
>
>
>2017-11-19 20:00 GMT+01:00 Robert Großkopf
>:
>
>> Hi Jonny,
>> >
>> > This works, but what about oDlg and oCtl? Are there special data
>types
>> for
>> > them too? The documentation I've found so far doesn't give any
>hints at
>> > all. I tried this:
>> > Dim Dlg As com.sun.star.awt.XDialog ' No error here,
>> > ' but next line throws an error:
>> > oDlg = CreateUnoDialog(DialogLibraries.Standard.MyDialogue)
>> > ' Error: No access to object.
>> > 'Invalid usage of the object.
>> > ' Well, something like that, it's actually in Swedish.
>>
>> What is the name of the dialog? Is ist called "MyDialogue"?.
>
>
>No, I actually faked it for this mailing list. The real name is in
>Swedish,
>so I figured it would be easier for you guys if I picked an English
>name
>instead, just for this example. But the name isn't the problem anyway.
>My
>question is if there is an ”extended data type” for dialogs and
>controls,
>just like there is for sheets (com.sun.star.sheet.XSpreadsheet) and
>cells (
>com.sun.star.table.XCell). I searched for and while and thought that
>com.sun.star.awt.XDialog could be it for dialogs, but as I said, I got
>that
>error message. When I used Object, like you do below, everything worked
>for
>me too, but my question wasn't about getting it working, it was if
>there is
>such a data type. I'm not doing anything particular, I'm just trying to
>learn this new stuff about those ”new data types”, that I enable by
>selecting Tools → Options… → LibreOffice → Advanced → Activate
>experimental
>features, then restart LibreOffice, then Tools → Options… → LibreOffice
>→
>Basic IDE options → ☒ Use extended data types (give or take some words
>or
>phrases, since this is a translation from Swedish).
>
>When trying to get information I found this page:
>https://help.libreoffice.org/Common/Basic_IDE_Options#Use_extended_types
>
>However, they only provided two examples of those new data types (the
>two I
>mention above), and there's no link or anything that points to the rest
>of
>them, so it's pretty useless, unfortunately.
>
>
>> It should
>> appear at the left (catalog of objects - don't konwo if this is the
>> right name ..) and at the bottom (like the standard "Module1")
>>
>> Declare the dialog first, out of a sub:
>> DIM oDialog0 AS OBJECT
>>
>> Start the dialog:
>>
>> SUB Dialog0Start
>> DialogLibraries.LoadLibrary("Standard")
>> oDialog0 = createUnoDialog(DialogLibraries.Standard.Dialog0)
>> oDialog0.Execute()
>> END SUB
>>
>> Name of the dialog is "Dialog0"
>>
>> End the dialog:
>>
>> SUB Dialog0Ende
>> oDialog0.EndExecute()
>> END SUB
>>
>>
>Yes, that's how I used to do it, and it usually work for me too, but
>this
>wasn't what I asked about. My question is about those new data types,
>mentioned on the page I referred to above.
>
>I'm sorry for my confusing English, which obviously isn't my native
>language.
>Thanks for replying, though! :)
>
>
>Kind regards
>
>Johnny Rosenberg
>
>
>
>> Regards
>>
>> Robert
>> --
>> Homepage: http://robert.familiegrosskopf.de
>> LibreOffice Community: http://robert.familiegrosskopf.de/map_3
>>
>>
>> --
>> To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
>> Problems?
>https://www.libreoffice.org/get-help/mailing-lists/how-to-un
>> subscribe/
>> Posting guidelines + more:
>https://wiki.documentfoundation.org/Netiquette
>> List archive: https://listarchives.libreoffice.org/global/users/
>> All messages sent to this list will be publicly archived and cannot
>be
>> deleted
>>
>
>--
>To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
>Problems?
>https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
>Posting guidelines + more:
>https://wiki.documentfoundation.org/Netiquette
>List archive: https://listarchives.libreoffice.org/global/users/
>All messages sent to this list will be publicly archived and cannot be
>deleted

-- 
To unsubscribe 

Re: [libreoffice-users] Strange Macro folder behavior

[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 macro".

If you remember...

1. Notice what Macro Library container you use. You might store a macro 
inside a document (and that would be a macro library container). Your 
choices here are really (a) some document, or (b) LibreOffice 
application.


2. Notice Library you used. Every Macro Library Container may contain 
numerous libraries. If you use the library named "Standard", then that 
macro will always be available, but, you cannot easily move macros 
stored in the standard library.


3. Notice what module you stored your macro. Each library can contain 
multiple modules.


I hope that I have not confused you too terribly much.


On 2018-07-23 17:30, Peggy wrote:
Yes, I always use the record macro feature since I don't know enough 
to do

it any other way.
Thank you for the old post, I will try it.
I did fiind my macros, can't even remember how I got there. I first 
tried
an option that said I needed Java, which I don't want because I read 
it's a

security risk.
But when I declinded to enable it, Something opened and showed me the
Macros. The ones I tried are working today.
Thank you for the reply!

On Sun, Jul 22, 2018 at 5:59 PM, Drew Jensen 


wrote:


Howdy,

So, I see that on ask libreoffice this has come up twice and both 
times

closed out (without an answer) or left unanswered.

There is an old forum post on this that might help in your case. You 
can

find it here:
https://forum.openoffice.org/en/forum/viewtopic.php?f=5=42324 but 
that

is
back form 2012.

By any chance had you been using the Record Macro feature also?

Best wishes,

Drew

On Sun, Jul 22, 2018 at 5:49 PM Peggy <33mar...@gmail.com> wrote:

> I selected some all capitalized text in a title, wanting to make a 
macro

to
> change it to initial caps. Ran the macro, stopped it and it 
worked. Went

to
> the macros under "My macros" in the library to assign a shortcut 
key.

>
> I couldn't find the macro but found a whole new Folder named with 
the

Title
> I'd selected. Worse yet was a folder with the title of another 
document

I'd
> started. I couldn't find any way to delete either of them.
>
> And even worse, when I looked at "My Macros" they were all gone.
>
> Searched online and there were a couple of questions from people 
who had
> lost all their macros, but they weren't answered. One was closed 
by a
> moderator because (something like) it was untimely. Don't quote me 
on

that.
> Whatever it didn't seem the reason for closing it was valid.
>
> I will uninstall and reinstall Libre Office, just losing one 
template I
> made since my macros are gone. But can anyone tell me what I did 
to cause
> those new folders? My macors were simple but convenient, and I can 
create

> them again.
>
> Peggy
>
> --
> To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
> Problems?
> 
https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/

> Posting guidelines + more: https://wiki.documentfoundation.org/
Netiquette
> List archive: https://listarchives.libreoffice.org/global/users/
> Privacy Policy: https://www.documentfoundation.org/privacy
>

--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-
unsubscribe/
Posting guidelines + more: 
https://wiki.documentfoundation.org/Netiquette

List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy



--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy

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

[Andrew Pitonyak]

Been there, done that.

I noticed just as I was hitting send, or I would have redirected back 
to the list so that others could see the conversation.


On 2018-07-23 16:52, Johnny Rosenberg wrote:

Thank you, I'll have a look at it.
Also sorry for accidentally mailing you directly, instead 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 
types




com.sun.star.uno.TypeClass.CONSTANT, _

com.sun.star.uno.TypeClass.CONSTANTS



And enumerate the constant types and print them. If I were 
industrious, I
would dump them into a Calc document. I can think of lots of things 
that I

could do.



I have a method in the UNO module called EnumerateEnumeratsions, 
which,

given a name, will print the names and associated values.



On 2018-07-23 11:14, Johnny Rosenberg wrote:

Thanks.

I downloaded your OOME_4_0 document and I found it there. I was kind 
of
hoping LibreOffice/Apache OpenOffice had its own constants so 
compatibility

mode hasn't to be used, but not much to do about that, I guess.
I already use a couple of constants when working with spreadsheets, 
for
instance com.sun.star.sheet.CellFlags.VALUE and the others, but I 
haven't

seen a list of all of those.

Thanks for replying.


Kind regards

Johnny Rosenberg


2018-07-23 16:17 GMT+02:00 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
document about macro programming and almost every one of those 
macros is
contained in libraries in the document. So, feel free to not enable 
them,
but you will not be able to click on the buttons in the document to 
test

run the contained macros.

Navigate here:
http://www.pitonyak.org/oo.php

Download OpenOffice.org Macros Explained V4 (or just click on this 
link)


http://www.pitonyak.org/OOME_4_0.odt


Open the document and search for the text "vbNewLine". This should 
land
you in table 10 Visual Basic-compatible string constants. This 
table lists
9 of this type of constant, but, they are only available if you 
enable
"compatibility mode" using "Option Compatible" in the module, or, 
by
calling CompatibilityMode(True) in your code before you use these 
specific

constants.

And no, I do not have an exhaustive list of defined constants. The
constants defined by the UNO object model, you can obtain using a 
macro,
but I do not think that it is directly related to your question so 
I will
not spend time finding the code that does that; but it is in the 
document

linked above.

And yes, Pi is a defined constant in LO Basic.

Hope this helped at least a little.


On 2018-07-22 16:26, Johnny Rosenberg wrote:


Hi!

I have done some searching and finally I found this at

https://wiki.openoffice.org/wiki/Documentation/BASIC_Guide/Constants:

”OpenOffice.org Basic predefines several constants. Among the 
most useful

are:

   - True and False, for Boolean assignment statements
   - PI as a type Double numeric value”

I assume this is true for LibreOffice as well, but I can't find 
the rest

of
the ”several constants”.

At work a use Excel (I don't really want to and it's full of bugs, 
but at
least I get paid…) and I wrote some macros in VBA. VBA has a lot 
of
predefined constants, for instance vbNewLine and a lot more, and 
I'm now
trying to find out what constants are available in LibreOffice 
Basic,

since
LibreOffice is what I use exclusively at home, so I don't have to
reinvent
the wheel.

So a link to a list of ALL predefined Basic constants would be 
very

appreciated.

Kind regards

Johnny Rosenberg



--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? 
https://www.libreoffice.org/get-help/mailing-lists/how-to-

unsubscribe/
Posting guidelines + more: 
https://wiki.documentfoundation.org/Netiquette

List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy







--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy

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

[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 document about macro programming and almost every one of 
those macros is contained in libraries in the document. So, feel free to 
not enable them, but you will not be able to click on the buttons in the 
document to test run the contained macros.


Navigate here:
http://www.pitonyak.org/oo.php

Download OpenOffice.org Macros Explained V4 (or just click on this 
link)


http://www.pitonyak.org/OOME_4_0.odt


Open the document and search for the text "vbNewLine". This should land 
you in table 10 Visual Basic-compatible string constants. This table 
lists 9 of this type of constant, but, they are only available if you 
enable "compatibility mode" using "Option Compatible" in the module, or, 
by calling CompatibilityMode(True) in your code before you use these 
specific constants.


And no, I do not have an exhaustive list of defined constants. The 
constants defined by the UNO object model, you can obtain using a macro, 
but I do not think that it is directly related to your question so I 
will not spend time finding the code that does that; but it is in the 
document linked above.


And yes, Pi is a defined constant in LO Basic.

Hope this helped at least a little.


On 2018-07-22 16:26, Johnny Rosenberg wrote:

Hi!

I have done some searching and finally I found this at
https://wiki.openoffice.org/wiki/Documentation/BASIC_Guide/Constants:

”OpenOffice.org Basic predefines several constants. Among the most 
useful

are:

   - True and False, for Boolean assignment statements
   - PI as a type Double numeric value”

I assume this is true for LibreOffice as well, but I can't find the 
rest of

the ”several constants”.

At work a use Excel (I don't really want to and it's full of bugs, 
but at

least I get paid…) and I wrote some macros in VBA. VBA has a lot of
predefined constants, for instance vbNewLine and a lot more, and I'm 
now
trying to find out what constants are available in LibreOffice Basic, 
since
LibreOffice is what I use exclusively at home, so I don't have to 
reinvent

the wheel.

So a link to a list of ALL predefined Basic constants would be very
appreciated.

Kind regards

Johnny Rosenberg


--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy

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

[Andrew Pitonyak]

I just checked OOME 4, and I think that I have a glaring omission in 
that I do not test or document the behavior of using write or print with 
special characters. Sadly, I do not know the answer off hand, but, I 
expect that you are seeing that they are not properly supported.


Can you try using Simple File Access instead and let me know if that 
works?


There is an example her:

http://www.pitonyak.org/oo.php

http://www.pitonyak.org/OOME_4_0.odt

I include the example here, but, you should be able to see what you 
need to do. Also note that the ODT documents contains the macros and you 
can run the test program while reading the document if you eneable 
macros when you load the document.


This is the example macro:


Sub ExampleSimpleFileAccess
  Dim oSFA' SimpleFileAccess service.
  Dim sFileName$  ' Name of file to open.
  Dim oStream ' Stream returned from SimpleFileAccess.
  Dim oTextStream ' TextStream service.
  Dim sStrings' Strings to test write / read.
  Dim sInput$ ' The string that is read.
  Dim s$  ' Accumulate result to print.
  Dim i%  ' Index variable.

  sStrings = Array("One", "UTF:Āā", "1@3")

  ' File to use.
  sFileName = CurDir() & "/delme.out"


  ' Create the SimpleFileAccess service.
  oSFA = CreateUnoService("com.sun.star.ucb.SimpleFileAccess")

  'Create the Specialized stream.
  oTextStream = CreateUnoService("com.sun.star.io.TextOutputStream")

  'If the file already exists, delete it.
  If oSFA.exists(sFileName) Then
oSFA.kill(sFileName)
  End If

  ' Open the file for writing.
  oStream = oSFA.openFileWrite(sFileName)

  ' Attach the simple stream to the text stream.
  ' The text stream will use the simple stream.
  oTextStream.setOutputStream(oStream)

  ' Write the strings.
  For i = LBound(sStrings) To UBound(sStrings)
oTextStream.writeString(sStrings(i) & CHR$(10))
  Next

  ' Close the stream.
  oTextStream.closeOutput()

  oTextStream = CreateUnoService("com.sun.star.io.TextInputStream")
  oStream = oSFA.openFileRead(sFileName)
  oTextStream.setInputStream(oStream)
  For i = LBound(sStrings) To UBound(sStrings)
sInput = oTextStream.readLine()
s = s & CStr(i)

' If the EOF is reached then the new line delimiters are
' not removed. I consider this a bug.
If oTextStream.isEOF() Then
  If Right(sInput, 1) = CHR$(10) Then
sInput = Left(sInput, Len(sInput) - 1)
  End If
End If

' Verify that the read string is the same as the written string.
If sInput <> sStrings(i) Then
  s = s & " : BAD "
Else
  s = s & " : 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 it will.


On 2018-08-30 6:06, Cédric Giraud wrote:

With the macro, *open *and *print *commands.

Le jeu. 30 août 2018 à 05:22, Andrew Pitonyak  
a

écrit :


How do you open the file and write the text?

Sent from BlueMail <http://www.bluemail.me/r?b=13569>
On Aug 29, 2018, at 5:35 PM, Cegir  
wrote:


Hi, thanks for your help

I'm on Windows 10, and my keyboard is AZERTY. As French, the system 
is

probably not UTF-8 by default.
I just copy/paste hangul from another .ods file.
I tried with 2 text editors and the .json reader from Firefox.

It seems the problem is the macro creates an ANSI file by default, 
and not a

UTF-8 version. I have no idea how to change it.

If I create an UTF-8 file before running the macro, the macro 
recreates it

in ANSI.



--
Sent from: 
http://document-foundation-mail-archive.969070.n3.nabble.com/Users-f1639498.html





--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy

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

[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, what value is in the isModified property?
3. I assume that you are calling terminate on the desktop object, is 
this correct?
4. Assuming you sleep a few seconds first, what happens if you call 
dispose on the document rather than close? I do not even know if the 
dispose method still exists, but, if it does. Note that you should not 
in general use dispose, but, that is what existed before close() was 
added to the API.



On 2018-08-31 13:00, dCipher wrote:

Hi

I have been automating Calc for years from Visual FoxPro.  It has 
worked
flawlessly until this week. Now the document close method often 
produces an
ole error 80010105.  I was using verison 5.1 so I updated everything 
to the
latest 6.1 version but the problem persists.  If I remove the Close() 
method
and just use Terminate() I get the same result that 30%-50% of the 
time it
crashes.  The spreadsheet is created correctly but Libre Office 
crashes on
the Close() method.  Does anyone have any ideas what might be the 
cause?  I
am running on Windows Server 2012 64bit.  I am using the 32bit 
version of

Libre Office.

If I try opening the document in Calc and makes some changes then use
"Close" from the File menu. I am prompted to save the document and
everything closes as expected.  It only seems to occur when 
automating the

process.

laArgs(1).Name="FilterName"
laArgs(1).Value="MS Excel 97"
laArgs(2).Name="Overwrite"
laArgs(2).Value=.T.
ComArray(toBizObj.oMergeDoc,10)


toBizObj.oMergeDoc.storeAsURL(ConvertToURL(toParam.Destination),@laArgs)

toBizObj.oMergeDoc.close(1)  <== Produces and error 30% - 50% of the 
time

toBizObj.oMerge.Terminate()

Thanks,
Simon




--
Sent from:

http://document-foundation-mail-archive.969070.n3.nabble.com/Users-f1639498.html


--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy

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

[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, and copy it back. If you use 
Paste

Special... and paste it into the text document as HTML you should see
a table. That way, you can handle arbitrary ranges in one go, not 
just

individual cells.




I created a Calc document.

Step 1: Select all cells of interest:

Step 2: Use

(1) Format > UPPERCASE

(2) Format > lowercase

(3) Format > Capitalize Every Word

(4) Format > Sentence Case

(5) Format > Toggle case

This directly changes the text of interest, but, I think that it will 
NOT affect text shown that is produced by an equation. For example, 
=UPPER(A1) will always show as upper case.


In Write, special case is handled using the Character Style. I do not 
believe that you can use a character style in Calc. A character style 
dictates how characters are displayed. They have a property


CharCaseMap

Specify how characters should be displayed using the  
com.sun.star.style.CaseMap constant group. This does not change the 
actual text—only the way it is displayed.


• NONE = 0 – No case mapping is performed; this is the most 
commonly used value.

• UPPERCASE = 1 – All characters are displayed in uppercase.
• LOWERCASE = 2 – All characters are displayed in lowercase.
• TITLE = 3 – The first character of each word is displayed in 
uppercase.
• SMALLCAPS = 4 – All characters are displayed in uppercase, 
but with a smaller font.



If you edit a character style, click on the Font Effects tab and the 
"Effects" drop-down allows you to set this.


In calc, if you Format a Cell, there is also a Font Effects tab, but, 
there is no "Effects" drop-down or any other way to change how the text 
is displayed with respect to case. Although a Calc cell contains a text 
object, I do not see the CharCaseMap property in the text object. Seems 
that CharCsaeMap is an optional property so it need not be supported


https://api.libreoffice.org/docs/idl/ref/servicecom_1_1sun_1_1star_1_1style_1_1CharacterProperties.html#ab8138e9a5d1a97f5fbbc2b431ca0cffa





I trust this helps.

Brian Barker


--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy

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

[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 components.

This last part is very important for more serious programs. For 
certain

serious integration, Basic fails, but it sounds like Python would be
suitable. Of course, if you are asking what language to learn, you 
are
not likely to write something so difficult, but, the fact that you 
can

do it makes it easier.




ok, I will write the firs very simple new UNO component, and I will
documented it...

Please, be merciful to my English



Awesome!


Also, your English is very understandable. the most important 
thing!





--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy

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

[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 calls, that level of detail is handled for free.


If I decided to not use Basic, I would evaluate which other language 
has the best integration, and, I cannot comment on that since I rarely 
leave Basic. I looked at Python because there was an issue with the 
Python version for a macro that someone wrote and they were having 
trouble with integration.


My Primary complaint about Python is that the block structure is 
directly related to the spacing and I have had that messed with as I 
moved between machines and operating system. I do not expect that to be 
a problem if you do not move between machines and if you have full 
control over the editor that use in terms of how it is configured... 
And if you are not pasting code that others have written or from web 
sites. All of those issues have caused me issues all related to how 
Python interprets blocks. When I write code in my Python specific editor 
and I stay on one machine, and I do not integrate code from other 
places, I have no problems with it. I should note that I work with some 
people who feel that they must solve every problem with Python.



As for your first language, I do not see a problem with using Python, 
but I also do not see a problem using Basic. Much depends on your end 
goal. Especially if you limit external dependencies, Python should run 
unchanged on most machines with a few caveats.


Why do you want to program? More specifically, what do you want to 
produce?


What type of programs do you want to write? (GUI, command line, control 
LO, etc...)


How portable must your code be?

If you want to write a GUI and it will only run on Windows, I think 
that Visual Studio has a decent environment for development. I spend way 
more time writing Java and C++ these days, which means that I have not 
been using Visual Studio lately.




On 2018-07-09 6:20, Tom Davies wrote:

Hi :)
@ Mauricio:  Wow!!!  That was very eloquent! :))  Thanks :)

@ Gordon:  Sorry!  I had a go with Pascal but got distracted and 
didn't get
very far.  It looked a LOT more elegant but i was entrenched in using 
Basic
at the time and couldn't handle the back to basics at that point in 
time.


@ all: Do you think Python is easy as a 1st language?  - or is it 
better to

start with something else first to ease into it all?

I'm kinda playing around with Scratch a bit and kinda learning Python 
but

at a very relaxed pace.  Both seem quite good fun now :)

Regards from a Tom :)




On 9 July 2018 at 06:19, gordon cooper  
wrote:



GoTo. One of the curses of Basic, the GoTo.

When used by newcomers (and a few some old hands too) a
Basic program would  soon become an unstructured mess of
GoTo's and a hassle to debug.  One of our Pascal lecturers was
very  anti-Basic and forbade us to use it,  or to even talk about it
in his presence.

Thank you Tom and Jonathon for the memory,
Gordon.



On 09/07/18 15:55, toki wrote:


On 08/07/18 09:04 PM, Tom Davies wrote:

I remember learning one form of basic in the 80s and that was 
pretty easy


There is a book from the early/mid eighties, that is simply lists 
the
vocabulary of the various dialects of BASIC in use then. IIRC, it 
was
called _The BASIC Book_. It was written specifically for 
programmers to

port software between the various systems that were available.

Back then, all variants of basic used line numbers, and allowed 
GoTo.

Today, several variants of BASIC don't use line number, and some
variants don't have GoTo.

jonathon




--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? 
https://www.libreoffice.org/get-help/mailing-lists/how-to-un

subscribe/
Posting guidelines + more: 
https://wiki.documentfoundation.org/Netiquette

List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy



--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy

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

[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 Python would be 
suitable. Of course, if you are asking what language to learn, you are 
not likely to write something so difficult, but, the fact that you can 
do it makes it easier.


--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy

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

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

On Jan 23, 2018, 6:45 AM, at 6:45 AM, stgmdn  wrote:
>Hello,
>
>I have to create a macro that read through a defined cell range, and
>for
>each cell, will assign it to a variable (to compare it to another
>cell),
>then it goes on the next cell.
>
>In my researches, I found that we can do this with a For Each Cell in
>VBA
>for Excel, but i can't seem to find the code that would do the same
>thing in
>LibreOffice Basic.
>
>Hope I've been clear enough, and thanks for your help.
>
>
>
>--
>Sent from: http://nabble.documentfoundation.org/Users-f1639498.html
>
>--
>To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
>Problems?
>https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
>Posting guidelines + more:
>https://wiki.documentfoundation.org/Netiquette
>List archive: https://listarchives.libreoffice.org/global/users/
>All messages sent to this list will be publicly archived and cannot be
>deleted

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

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

[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 the document

http://www.pitonyak.org/database/AndrewBase.odt

Note that my Macro documents contain the maros in the document, which 
makes it possible to copy any macros that you want to use simply by 
importing the libraries. On the other hand, the documents contain 
macros, which means that you will be warned that they do contain macros. 
I try to create my documents such that you can run the macros directly 
by clicking on buttons embedded in the documents to test them.


I am a bit overwhelmed with overdue tasks, but, if you notice something 
that is obviously no longer correct, please let me know.



On 2018-03-06 8:48, Anne Wilson wrote:

On 06/03/2018 13:35, zahra a wrote:

hello.
i downloaded getting started from libreoffice.org
for free in odt format.
which version of libreoffice do you need to work on?
whats the different between free version and paid version of getting 
started?
i downloaded getting started for libreoffice 5.2 in odt format from 
its website.

i realized that it explanes macro and if you need to use macro in
libreoffice, the book can help you!
hope that help, God bless!


Thanks for the quick reply.  My books are somewhat out of date, with
Getting Started being 4.2 and Base Handbook being 4.0.  I had, 
though,
noticed that both have some help with macros.  Oce I'm sure that's 
the

way to go, I'll consult them - although perhaps I should download the
updated versions first :-)

AnneW






On 3/6/18, Anne Wilson  wrote:
Hello.  Since this is my first post, I'll write some background 
first.


I am deeply interested in machine embroidery, as well as general 
sewing.
 I therefore have accumulated a library of magazines with some 
excellent

articles.  The problem is finding the right article when I want to
re-read it.

I bought the Getting Started Guide and Base Handbook, and by 
constantly
referring back to them, managed to get an embedded database, in 
which

details of the article were accompanied by an image.  You know what
comes next.  All was well until I had just over 200 entries - at 
which
time it crashed and I lost all entries.  Fortunately I had a backup 
up
to the previous day's work, as well as an almost complete 
spreadsheet

which had been the basis for my efforts, but there was no point in
trying to do more, as all reading pointed to the problem of images
causing the size to over-expand.

I have now tried to create a split database, following the 
instructions
I found online.  However, I'm finding it difficult to source 
information
on using it.  Picked from the bits and pieces I've accumulated, 
instead
of adding the image directly, I have created a text field 
containing a

URL relative to the data folder, e.g. ../Images/OnionsAndRust.jpg.

What I would like to achieve is that URL to be read in, the image
displayed, then dropped when the record changes.  Is this a 
reasonable

approach?

Can you point me to documentation that will help?  I suspect that I 
need
to learn to write macros for this to work, but again, providing I 
can

find help to get started I am ready to learn.

AnneW



--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

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

[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 one let me know, and I will see if I can provide one for you 
after I look at the macro you are using now.

Understand, however, the next two days for me will be hit or miss on 
availability.



⁣Sent from BlueMail ​

On Feb 12, 2019, 9:55 PM, at 9:55 PM, Thomas Blasejewicz  
wrote:
>Good morning
>I have another strange question.
>Work related I have to insert not infrequently symbols into texts.
>To make work easier, I have already created a number of macros to
>insert 
>for example the symbol "micro" into a text using a keyboard shortcut.
>
>Problem:
>Let's say, I created the macro in a document that happened to use 
>"Arial" as font and later want to use it in a document that uses "Times
>
>Roman". The macro I created then inserts an "Arial font micro" into the
>
>Times Roman text, which then looks out of place.
>
>Is there a trick to create macros, so that the inserted symbol matches 
>the surrounding font?
>I have tried all sorts of things, but could not yet find a solution.
>It is not really a "problem", but such an automatic font adjustment 
>would be nice/helpful.
>
>Thank you.
>Thomas
>
>-- 
>To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
>Problems?
>https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
>Posting guidelines + more:
>https://wiki.documentfoundation.org/Netiquette
>List archive: https://listarchives.libreoffice.org/global/users/
>Privacy Policy: https://www.documentfoundation.org/privacy

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy

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

[Andrew Pitonyak]

I would have used a text cursor, but, the recorded Macro is trivially modified 
to remove the font name, you just need to know that you can do that :-)

sub insertAlphaNoFont
rem --
rem define variables
dim document   as object
dim dispatcher as object
rem --
rem get access to the document
document   = ThisComponent.CurrentController.Frame
dispatcher = createUnoService("com.sun.star.frame.DispatchHelper")

rem --
dim args1(0) as new com.sun.star.beans.PropertyValue
args1(0).Name = "Symbols"
args1(0).Value = "α"

dispatcher.executeDispatch(document, ".uno:InsertSymbol", "", 0, args1())

end Sub

Lot easier than another solution (if you 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 Pitonyak wrote:
> 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.

Well, I am not actually "writing" the macro - I have no idea how to do
that.
I use "Tools -> Macros -> Record macro" and open the "insert special
characters dialog box".
THIS is where the problem is.
As far as I can tell, there is no way NOT to select a font in that dialog.
On top you have the "Search / Font / Subset" fields.
"Font" gives you a list of fonts, but not the choice of "none /
automatic" etc. - or allows you to delete the currently selected font.
I had been hoping to find that kind of choice.

Mr. Pitonyak. Please don't worry. I am not in a hurry. I have been
pondering this for years already ...

Thank you.
Thomas Blasejewicz







>
>
>
> Sent from BlueMail <http://www.bluemail.me/r?b=14470>
> On Feb 12, 2019, at 9:55 PM, Thomas Blasejewicz  <mailto:ny...@hb.tp1.jp>> wrote:
>
> Good morning
> I have another strange question.
> Work related I have to insert not infrequently symbols into texts.
> To make work easier, I have already created a number of macros to insert
> for example the symbol "micro" into a text using a keyboard shortcut.
>
> Problem:
> Let's say, I created the macro in a document that happened to use
> "Arial" as font and later want to use it in a document that uses "Times
> Roman". The macro I created then inserts an "Arial font micro" into the
> Times Roman text, which then looks out of place.
>
> Is there a trick to create macros, so that the inserted symbol matches
> the surrounding font?
> I have tried all sorts of things, but could not yet find a solution.
> It is not really a "problem", but such an automatic font adjustment
> would be nice/helpful.
>
> Thank you.
> Thomas
>


--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy


 

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy

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

[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 Jul 4, 2019, 12:15 PM, at 12:15 PM, John  wrote:
>On Thu, 2019-07-04 at 07:45 +0200, Uwe Brauer wrote:
>> Hi 
>> 
>> > From time to time the question pops up whether LO could support
>> Wordperfects reveal code. The developer are not too keen, and
>sometimes
>> it is stated that this feature could be implemented by a
>> macro/extension.
>> 
>> Now I remember that long time ago such macros existed and using the
>> wayback machine I found them. They were written around 2005 for OO
>1.2,
>> using the sxw format.
>> 
>> I tried them out in LO 6.2 and they don't work.
>> 
>> Is there somebody with enough knownledge in macros to translate those
>> macros to LO 6.2?
>> 
>> Thanks and regards
>> 
>> Uwe Brauer 
>> 
>Just in case any further support for this change is desired, one of the
>all-time 
>BEST features of Word Perfect was "reveal codes".  You could actually
>use it to
>figure out why the page format was not as expected! 
>
>I would love to see this feature added to Libre Office!
>
>John
>> 
>
>
>-- 
>To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
>Problems?
>https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
>Posting guidelines + more:
>https://wiki.documentfoundation.org/Netiquette
>List archive: https://listarchives.libreoffice.org/global/users/
>Privacy Policy: https://www.documentfoundation.org/privacy

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy

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

[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 AM, Johnny Rosenberg 
 wrote:
>Den tors 4 juli 2019 kl 08:03 skrev Uwe Brauer :
>
>> Hi
>>
>> >From time to time the question pops up whether LO could support
>> Wordperfects reveal code. The developer are not too keen, and
>sometimes
>> it is stated that this feature could be implemented by a
>> macro/extension.
>>
>> Now I remember that long time ago such macros existed and using the
>> wayback machine I found them. They were written around 2005 for OO
>1.2,
>> using the sxw format.
>>
>> I tried them out in LO 6.2 and they don't work.
>>
>> Is there somebody with enough knownledge in macros to translate those
>> macros to LO 6.2?
>>
>
>How much code are we talking about?
>
>Kind regards
>
>Johnny Rosenberg
>
>>
>> Thanks and regards
>>
>> Uwe Brauer
>>
>>
>> --
>> To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
>> Problems?
>>
>https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
>> Posting guidelines + more:
>https://wiki.documentfoundation.org/Netiquette
>> List archive: https://listarchives.libreoffice.org/global/users/
>> Privacy Policy: https://www.documentfoundation.org/privacy
>>
>>
>
>-- 
>To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
>Problems?
>https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
>Posting guidelines + more:
>https://wiki.documentfoundation.org/Netiquette
>List archive: https://listarchives.libreoffice.org/global/users/
>Privacy Policy: https://www.documentfoundation.org/privacy

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy

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

[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 files have a complex SGML or HTML or XML
>type format, along with a form of CSS, unlike WordPerfect and similar
>programs, which used embedded code to delineate format changes. That
>is,
>there are no format codes to reveal in ODF documents. Any program that
>pretended  to show some kind of "format code" would be hopelessly
>misleading.
>
>On Thu, Jul 4, 2019 at 2:01 AM Uwe Brauer  wrote:
>
>> Hi
>>
>> >From time to time the question pops up whether LO could support
>> Wordperfects reveal code. The developer are not too keen, and
>sometimes
>> it is stated that this feature could be implemented by a
>> macro/extension.
>>
>> Now I remember that long time ago such macros existed and using the
>> wayback machine I found them. They were written around 2005 for OO
>1.2,
>> using the sxw format.
>>
>> I tried them out in LO 6.2 and they don't work.
>>
>> Is there somebody with enough knownledge in macros to translate those
>> macros to LO 6.2?
>>
>> Thanks and regards
>>
>> Uwe Brauer
>>
>>
>> --
>> To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
>> Problems?
>>
>https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
>> Posting guidelines + more:
>https://wiki.documentfoundation.org/Netiquette
>> List archive: https://listarchives.libreoffice.org/global/users/
>> Privacy Policy: https://www.documentfoundation.org/privacy
>>
>>
>
>-- 
>To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
>Problems?
>https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
>Posting guidelines + more:
>https://wiki.documentfoundation.org/Netiquette
>List archive: https://listarchives.libreoffice.org/global/users/
>Privacy Policy: https://www.documentfoundation.org/privacy

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy

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

[Andrew Pitonyak]

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 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 were
>Italic. 
>> I used the following macro and, although FindAll does return all
>italic 
>> text, it only selects the last three instances and not the first one.
>> 
>> 
>> My example had two instances in normal text and two instances in a
>text 
>> table.
>> 
>> If I have more than once instance, it ignores the first. If I have
>ONLY 
>> one instance of Italic text, it will select the text.
>> 
>> 
>> Sub FindItalic_all
>>    Dim oDescriptor  'The search descriptor
>>    Dim oFound   'The found range
>>    Dim SrchAttributes(0) as new com.sun.star.beans.PropertyValue
>> 
>>    SrchAttributes(0).Name = "CharPosture"
>>    SrchAttributes(0).Value =  com.sun.star.awt.FontSlant.ITALIC
>> '  SrchAttributes(0).Name = "CharFontName"
>> '  SrchAttributes(0).Value =  "Comic Sans MS"
>> 
>>    oDescriptor = ThisComponent.createSearchDescriptor()
>>    oDescriptor.SetSearchAttributes(SrchAttributes)
>> 
>>    oFound = ThisComponent.findAll(oDescriptor)
>> 
>> '  Dim i As Integer
>> '  for i = 0 To oFound.Count - 1
>> '    Print oFound.getByIndex(i).getString(i)
>> '  Next
>>    Thiscomponent.getCurrentController.select(oFound)
>> End Sub
>> 
>
>
>I confirm the same bug, with Python:
>
>from com.sun.star.beans import PropertyValue
>from com.sun.star.awt.FontSlant import ITALIC
>
>doc = XSCRIPTCONTEXT.getDocument()
>
>opt = (PropertyValue(Name='CharPosture', Value=ITALIC),)
>descriptor = doc.createSearchDescriptor()
>descriptor.setSearchAttributes(opt)
>
>found = doc.findAll(descriptor)
>doc.CurrentController.select(found)
>
>Always select len(found) - 1
>
>I search if bug is reported, but not found any.
>
>
>Best regards
>-- 
>To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
>Problems?
>https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
>Posting guidelines + more:
>https://wiki.documentfoundation.org/Netiquette
>List archive: https://listarchives.libreoffice.org/global/users/
>Privacy Policy: https://www.documentfoundation.org/privacy

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy

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

[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.
>> 
>> 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
>> 
>
>
>It's ok... You or I report this?
>
>Best regards
>-- 
>To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
>Problems?
>https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
>Posting guidelines + more:
>https://wiki.documentfoundation.org/Netiquette
>List archive: https://listarchives.libreoffice.org/global/users/
>Privacy Policy: https://www.documentfoundation.org/privacy

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy

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

[Andrew Pitonyak]

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

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 I email 
> the
> latest version for upload.
>
>
>

--
Dr. Heiko Tietze, UX-Designer and UX-Mentor
Tel: +49 30 5557992-63 | Mail: heiko.tie...@documentfoundation.org
The Document Foundation, Kurfürstendamm 188, 10707 Berlin, DE
Gemeinnützige rechtsfähige Stiftung des bürgerlichen Rechts
Legal details: https://www.documentfoundation.org/imprint


--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy


 

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy

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

[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:
>> 
>> 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.
>> 
>> 
>> 
>
>-- 
>Dr. Heiko Tietze, UX-Designer and UX-Mentor
>Tel: +49 30 5557992-63 | Mail: heiko.tie...@documentfoundation.org
>The Document Foundation, Kurfürstendamm 188, 10707 Berlin, DE
>Gemeinnützige rechtsfähige Stiftung des bürgerlichen Rechts
>Legal details: https://www.documentfoundation.org/imprint
>
>
>-- 
>To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
>Problems?
>https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
>Posting guidelines + more:
>https://wiki.documentfoundation.org/Netiquette
>List archive: https://listarchives.libreoffice.org/global/users/
>Privacy Policy: https://www.documentfoundation.org/privacy

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy

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

[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:
>> 
>> 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
>> 
>> 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
>I email the
>>> latest version for upload.
>>>
>>>
>>>
>> 
>> --
>> Dr. Heiko Tietze, UX-Designer and UX-Mentor
>> Tel: +49 30 5557992-63 | Mail: heiko.tie...@documentfoundation.org
>> The Document Foundation, Kurfürstendamm 188, 10707 Berlin, DE
>> Gemeinnützige rechtsfähige Stiftung des bürgerlichen Rechts
>> Legal details: https://www.documentfoundation.org/imprint
>> 
>> 
>> --
>> To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
>> Problems?
>https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
>> Posting guidelines + more:
>https://wiki.documentfoundation.org/Netiquette
>> List archive: https://listarchives.libreoffice.org/global/users/
>> Privacy Policy: https://www.documentfoundation.org/privacy
>> 
>> 
>>  
>> 
>
>-- 
>Dr. Heiko Tietze, UX-Designer and UX-Mentor
>Tel: +49 30 5557992-63 | Mail: heiko.tie...@documentfoundation.org
>The Document Foundation, Kurfürstendamm 188, 10707 Berlin, DE
>Gemeinnützige rechtsfähige Stiftung des bürgerlichen Rechts
>Legal details: https://www.documentfoundation.org/imprint
>
>
>-- 
>To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
>Problems?
>https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
>Posting guidelines + more:
>https://wiki.documentfoundation.org/Netiquette
>List archive: https://listarchives.libreoffice.org/global/users/
>Privacy Policy: https://www.documentfoundation.org/privacy

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy

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

[Andrew Pitonyak]

I noticed it seemed to have just disappeared but I can see if to maintain it 
but not navigate to it. my best guess is that it is because I inadvertently 
changed the title but I don't really know. I tried to put entitled back, but 
did not cause it to reappear.





⁣Sent from BlueMail ​

On Oct 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 01.10.20 14:37, Andrew Pitonyak wrote:
>> > 
>> > 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
>> > 
>> > 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 I email the latest version for upload.
>> >>
>> >>
>> >>  
>> > 
>> > --
>> > Dr. Heiko Tietze, UX-Designer and UX-Mentor
>> > Tel: +49 30 5557992-63 | Mail: heiko.tie...@documentfoundation.org
>> > The Document Foundation, Kurfürstendamm 188, 10707 Berlin, DE
>> > Gemeinnützige rechtsfähige Stiftung des bürgerlichen Rechts
>> > Legal details: https://www.documentfoundation.org/imprint
>> > 
>> > 
>> > --
>> > To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
>> > Problems?
>> >
>https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
>> > Posting guidelines + more:
>> > https://wiki.documentfoundation.org/Netiquette List archive:
>> > https://listarchives.libreoffice.org/global/users/ Privacy Policy:
>> > https://www.documentfoundation.org/privacy
>> > 
>> > 
>> >  
>> >   
>> 
>
>
>-- 
>To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
>Problems?
>https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
>Posting guidelines + more:
>https://wiki.documentfoundation.org/Netiquette
>List archive: https://listarchives.libreoffice.org/global/users/
>Privacy Policy: https://www.documentfoundation.org/privacy

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy

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

[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 it seemed to have just disappeared but I can see if to
>maintain it but not navigate to it. my best guess is that it is because
>I inadvertently changed the title but I don't really know. I tried to
>put entitled back, but did not cause it to reappear.
>
>Your extension has the status MODIFIED (whatever than means); maybe
>this causes
>it not being shown on the page? Or do you talk about the "Manage your
>extensions" section, which is empty for me for some reason. In any case
>you are
>welcome to file a ticket on
>https://redmine.documentfoundation.org/projects/extensions/issues
>
>Cheers,
>Heiko
>
>
>-- 
>To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
>Problems?
>https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
>Posting guidelines + more:
>https://wiki.documentfoundation.org/Netiquette
>List archive: https://listarchives.libreoffice.org/global/users/
>Privacy Policy: https://www.documentfoundation.org/privacy

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy

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

[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
> super/sub scripts.

Good to know, thanks for the tip (that's Format > Clear Direct Formating,
CTRL+M).

Is there a way to turn all paragraphs from Default Style to Text Body in one
go? Having to do this for all paragraphs over 200 pages doesn't sound like
fun.
 You can do this with search and replace. 

 

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy

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

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

Next, you do things with these cells based on a very complicated formula. I am 
not familiar with the EnterString dispatch off hand, but I assume that it 
places whatever this string is into a cell. 

Next you call the dispatcher to Copy to the clipboard followed by Cutting to 
the clipboard. That seems redundant. 


Next you have InsertContents, again, a dispatch command with which I have no 
familiarity, but, off hand it looks like it is probably doing something similar 
to "Paste", but I am just guessing. 

So, what do you really want to accomplish? 



On Saturday, July 04, 2020 18:30 EDT, "Michael D. Setzer II" 
 wrote:
 Been doing a lot of googling, but finding lots of stuff, but nothing that 
works?
Have done a lot of versions and this is the latest one.
The record process does not allow for the use of the F2 key, so as is, it
results in the original args1(0).Value being in the cell?
After the macro ends, I've found that if I manually press F2 then a space and
enter it puts the formula as I originally wanted? F2 and enter does nothing??
I've also found that if I manually do F2 F9 Enter Enter, it will place just the
final text result in cell.

Seems there use to be a Keypress option, that would allow for simulating
keys, but that has been deprecated?
Also, found pages that talk about API stuff to modify cells, but the two I tried
did nothing?

Am I missing something??

Note: In string I replaced the original "s with _ because it kept giving me
messages about unbalanced ()?? That got rid of the errors, and then just
converted them back?

Not and important macro, but was just hoping to find a way to make it work
the way I originally planned. Just playing around with stuff.

Thanks. Perhaps I am overlooking something very simple..


sub Z1
rem --
rem define variables
dim document as object
dim dispatcher as object
rem --
rem get access to the document
document = ThisComponent.CurrentController.Frame
dispatcher = createUnoService("com.sun.star.frame.DispatchHelper")

rem --
dim sText
sText = InputBox ("Please enter Date Cells Example D2,D1:")

rem --
dim args1(0) as new com.sun.star.beans.PropertyValue
args1(0).Name = "StringName"
args1(0).Value =
"=SUBSTITUTE(SUBSTITUTE(""=IF(DATEDIF(A2,A1,_y_),IF(DATEDIF(A2,
A1,_y_)=1,_1 Year _,DATEDIF(A2,A1,_y_)&_ Years
_),__)(MOD(DATEDIF(A2,A1,_m_),12),IF(MOD(DATEDIF(A2,A1,_m_),1
2)=1,_1 Month _,MOD(DATEDIF(A2,A1,_m_),12)&_ Months
_),__)(DATEDIF(A2,A1,_md_),IF(DATEDIF(A2,A1,_md_)=1,_1 Day
_,DATEDIF(A2,A1,_md_)&_ Days_),__)"",""A2,A1""," & chr$(34) & sText &
chr$(34) & "),""_"",CHAR(34))"

dispatcher.executeDispatch(document, ".uno:EnterString", "", 0, args1())

rem --
dispatcher.executeDispatch(document, ".uno:Copy", "", 0, Array())

rem --
REM Cut contents of cell to avoid the overwrite message
dispatcher.executeDispatch(document, ".uno:Cut", "", 0, Array())

rem --
dim args2(5) as new com.sun.star.beans.PropertyValue
args2(0).Name = "Flags"
args2(0).Value = "SVD"
args2(1).Name = "FormulaCommand"
args2(1).Value = 0
args2(2).Name = "SkipEmptyCells"
args2(2).Value = false
args2(3).Name = "Transpose"
args2(3).Value = false
args2(4).Name = "AsLink"
args2(4).Value = false
args2(5).Name = "MoveMode"
args2(5).Value = 4

dispatcher.executeDispatch(document, ".uno:InsertContents", "", 0, args2())
msgbox ("To complete process,"+chr$(13)+" Formula Press F2 then Space
then Enter" + chr$(13)+"For Text Result Press F2 then F9 then Enter then
Enter")

end sub

++
Michael D. Setzer II - Computer Science Instructor (Retired)
mailto:mi...@guam.net
mailto:msetze...@gmail.com
Guam - Where America's Day Begins
G4L Disk Imaging Project maintainer
http://sourceforge.net/projects/g4l/
++




--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy
 


 

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org

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

[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 question. That would look 
something like this: (now I go see if i can make it work). 

And much hinges on how fancy / smart you want to make the portion that figures 
out what cell is selected. Remember, it is possible that you select a range 
when you run the macro, but. I know this is wrong because on my machine it 
complains about the "md" parameter, but I will not try to figure that out, it 
is 11:00 PM and I have not had my dinner yet. 

I hope that this helps at least a little bit. But this places the formula where 
you need it, you just need to (1) figure out how to call it and (2) what that 
formula needs to be.


Let me know what you figure out. 

  Dim s As String
  Dim sNew As String
  Dim sNewDates As String
  
  sNewDates = "D1, D2"
  sNewDates = InputBox ("Please enter Date Cells Example D2,D1:")
  
  ' Assume for a moment that you do want to do a simple string substitution. 
  ' This will ONLY work if you are consistent on how "A2, A1" is represented in 
the string. 
  ' The code you sent, it was not consistent. It was "A2, A2", A2 ,A2", and 
others. 
  ' This example is consistent. 
  ' Two double quotes works as an embedded double quote, so: 
  s = "=IF(DATEDIF( A2, A1,""y""),IF(DATEDIF( A2, A1,""y"")=1,""1 Year 
"",DATEDIF( A2, A1,""y"")&"" Years ""),)(MOD(DATEDIF(A2, A1 
,""m""),12),IF(MOD(DATEDIF( A2, A1,""m""),12)=1,""1 Month "",MOD(DATEDIF(A2, A1 
,""m""),12)&"" Months ""),)(DATEDIF(A2, A1 ,""md""),IF(DATEDIF( A2, 
A1,""md"")=1,""1 Day "",DATEDIF(A2, A1,""md"")&"" Days""),)"

  ' You want to make a substitution. 
  ' This gives you the string of interest. 
  sNew = Replace(s, "A2, A1", sNewDates)
  Print sNew

  ' That said, what if you just do the entire calculation without using fancy 
dispatches. 
  ' Even easier, you could write a function that is called from Calc and pass 
in two dates. 
   Dim sDateCells()
   sDateCells = Split(sNewDates, ",")
   If UBound(sDateCells) <> 1 Then
     Print "Expected two dates"
     Exit Sub
   End If

  ' Get the current active sheet
   Dim oSheet
   oSheet = ThisComponent.CurrentController.getActiveSheet()
   
   
  Dim oRanges       'A blank range created by the document
  Dim oActiveCell   'The current active cell

  REM Force a single cell selection and discard the existing multi-selection if 
there is one. 
  REM Create an empty SheetCellRanges service and then select it.
  REM This leaves ONLY the active cell selected.
  oRanges = ThisComponent.createInstance("com.sun.star.sheet.SheetCellRanges")
  ThisComponent.CurrentController.Select(oRanges)

  REM Get the active cell!
  oActiveCell = ThisComponent.CurrentSelection
  oActiveCell.setFormula(sNew)

On Saturday, July 04, 2020 20:27 EDT, "Michael D. Setzer II" 
 wrote:
 Basically, I want the macro to be able to work completely on its own.
Agree that having to do the steps with the F2 and other keys is a problem.
Not sure why the recorder refuses to record those steps??


The original formula is
=IF(DATEDIF(A2,A1,y),IF(DATEDIF(A2,A1,y)=1,1 
Year,DATEDIF(A2,A1,y)Years),)IF(MOD(DATEDIF(A2,A1,m),12),IF(MOD(DATEDIF(A2,A1,m),12)=1,1
Month,MOD(DATEDIF(A2,A1,m),12)Months),)IF(DATEDIF(A2,A1,md),IF(DATEDIF(A2,A1,md)=1,1
 Day,DATEDIF(A2,A1,md)Days),)


But to use the formula in a different location or with dates in different 
relative
locations would require one to manually edit the formula and change all the
A2,A1 settings to the new settings. Doing it 9 times.


Thus the macro prompts for the new addresses, and changes them all.
Problem is it leaves the formula contents displayed rather than the result??
Requiring the use of the F2 key and other keys.


Have found the copy paste isn't required, but it changes the manual key options
require to get the results.


sub Z2
rem --
rem define variables
dim documentas object
dim dispatcher as object
rem --
rem get access to the document
document= ThisComponent.CurrentController.Frame
dispatcher = createUnoService(com.sun.star.frame.DispatchHelper)


rem --
dim sText
sText = InputBox (Please enter Date Cells Example D2,D1:)


rem --
dim args1(0) as new com.sun.star.beans.PropertyValue
args1(0).Name =StringName
args1(0).Value 
==SUBSTITUTE(SUBSTITUTE(=IF(DATEDIF(A2,A1,_y_),IF(DATEDIF(A2,A1,_y_)=1,_1 Year 
_,DATEDIF(A2,A1,_y_)_ Years
_),__)IF(MOD(DATEDIF(A2,A1,_m_),12),IF(MOD(DATEDIF(A2,A1,_m_),12)=1,_1
Month _,MOD(DATEDIF(A2,A1,_m_),12)_ Months

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

[Andrew Pitonyak]

 just 
copy the formula, and change the A2,A1 to the new values. Recording it worked 
just fine, and did everything correctly in the recording process, but the play 
back didn't include the last steps using the F2 key. I've just now done a new 
version that does seem to work, but it made the process a lot longer... Was a 
mess getting all the "s correct, but it seems to work the way I want, just 
required manually replacing each value versus using the search and replace 
substitute command?? sub Z3rem 
--rem 
define variablesdim document   as objectdim dispatcher as objectrem 
--rem get 
access to the documentdocument   = 
ThisComponent.CurrentController.Framedispatcher = 
createUnoService("com.sun.star.frame.DispatchHelper") rem 
------dim sText 
sText = InputBox ("Please enter Date Cells Example D2,D1:") rem 
--dim 
args1(0) as new com.sun.star.beans.PropertyValueargs1(0).Name = 
"StringName"args1(0).Value = "=IF(DATEDIF(" & sText & ",""y""),IF(DATEDIF(" & 
sText & ",""y"")=1,""1 Year "",DATEDIF(" & sText & " ,""y"")&"" Years 
""),"""")(MOD(DATEDIF(" & sText & ",""m""),12),IF(MOD(DATEDIF(" & sText & 
",""m""),12)=1,""1 Month "",MOD(DATEDIF(" & sText & ",""m""),12)&"" Months 
""),"""")(DATEDIF(" & sText & ",""md""),IF(DATEDIF(" & sText & 
",""md"")=1,""1 Day "",DATEDIF(" & sText & " ,""md"")&"" Days""),"""")"  
dispatcher.executeDispatch(document, ".uno:EnterString", "", 0, args1()) end 
sub On 4 Jul 2020 at 20:54, Andrew Pitonyak wrote: From: 
"Andrew Pitonyak" Date sent:  Sat, 04 Jul 2020 
20:54:34 -0400Copies to:  users@global.libreoffice.orgTo:   
  Michael D. Setzer II Subject: Re: 
[libreoffice-users] Confused with Macro    results?? > 
> > 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.> > Next, you do 
things with these cells based on a very complicated formula. I am not familiar 
with > the EnterString dispatch off hand, but I assume that it places whatever 
this string is into a cell.> > Next you call the dispatcher to Copy to the 
clipboard followed by Cutting to the clipboard. That > seems redundant.> > > 
Next you have InsertContents, again, a dispatch command with which I have no 
familiarity, but, > off hand it looks like it is probably doing something 
similar to "Paste", but I am just guessing.> > So, what do you really want to 
accomplish?> > > > On Saturday, July 04, 2020 18:30 EDT, "Michael D. Setzer II" 
 wrote:> > Been doing a lot of googling, but finding 
lots of stuff, but nothing > that works?> Have done a lot of versions 
and this is the latest one.> The record process does not allow for the use 
of the F2 key, so as > is, it> results in the original args1(0).Value 
being in the cell?> After the macro ends, I've found that if I manually 
press F2 then a > space and> enter it puts the formula as I originally 
wanted? F2 and enter does > nothing??> I've also found that if I 
manually do F2 F9 Enter Enter, it will place > just the> final text 
result in cell.> > Seems there use to be a Keypress option, that would 
allow for > simulating> keys, but that has been deprecated?> Also, 
found pages that talk about API stuff to modify cells, but the > two I 
tried> did nothing?> > Am I missing something??> > Note: In 
string I replaced the original "s with _ because it kept > giving me > 
messages about unbalanced ()?? That got rid of the errors, and > then just> 
    converted them back?> > Not and important macro, but was just 
hoping to find a way to > make it work> the way

Re: [libreoffice-users] Counting cells

[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, what 
>formula may I use to count how many cells have a number? I do not want 
>the sum of the numbers, just how many cells contain a number.
>
>Thank you.
>
>
>-- 
>To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
>Problems?
>https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
>Posting guidelines + more:
>https://wiki.documentfoundation.org/Netiquette
>List archive: https://listarchives.libreoffice.org/global/users/
>Privacy Policy: https://www.documentfoundation.org/privacy

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy

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

[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 least once. :-)

I have written code that adds things such as lines (and other shapes) into 
documents. 

I might have looked at something in LO that allows me to have a bunch of 
shapes. On my computer, I use 

View > Gallery

Too open it. From there it looks like I can drag objects out of the "gallery" 
and onto a document. 

I had forgotten you can do that in LO. Is this the type of graphic that you 
want to insert? Not that I know how, but I am trying to clarify in case it is 
something that I do know how to do. 


On Thursday, February 11, 2021 13:08 EST, Regina Henschel 
 wrote:
 Hi all,

does someone has a basic macro snippet for to insert a custom shape
(e.g. a smiley) into a page?

Background: For a unit test I need to insert a custom shape via code
similar to as it is done via mouse. But I have no idea how to code it. A
macro might give me an initial stage for a solution.

Kind regards
Regina

--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy


 

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy

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

[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:53 EST, Regina Henschel 
 wrote:
 Andrew Pitonyak schrieb am 11.02.2021 um 20:06:
>
> This might seem obvious, but:
>
> 1. What document type?

Calc

>
> 2. What is a "custom" shape? Do you mean com.sun.star.drawing.CustomShape

Yes

>
> Not that I have never used Cutom Shapes in any way in LibreOffice, but i have 
> written a Macro at least once. :-)
>
> I have written code that adds things such as lines (and other shapes) into 
> documents.
>
> I might have looked at something in LO that allows me to have a bunch of 
> shapes. On my computer, I use
>
> View > Gallery
>
> Too open it. From there it looks like I can drag objects out of the "gallery" 
> and onto a document.

That makes a kind of copy I need an object newly created with the
mouse.

When you click on a shape icon in the toolbar and then click and drag
with the mouse to create the shape, then the created custom shape is on
a wrong layer. You notice in the "Drawing object properties"-toolbar,
that both "To Foreground" and "To Background" are enabled. "To
Foreground" should not be enabled, because when you create a custom
shape with the mouse, you are working already in the "Foreground". I
have a patch for it, but struggle with the unit test.

Kind regards
Regina

--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy


 

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy

Re: [libreoffice-users] Question

[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
>opened
>a xlsx file using Calc and I'm a really paranoid and think the file is
>infected I meant to download it but I accidently opened it
>
>-- 
>To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
>Problems?
>https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
>Posting guidelines + more:
>https://wiki.documentfoundation.org/Netiquette
>List archive: https://listarchives.libreoffice.org/global/users/
>Privacy Policy: https://www.documentfoundation.org/privacy

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy

Re: [libreoffice-users] Calc airithmetic snafu

[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 in alphabetic letters i.e.
>
>   C      |  D
>2| 2.4 km|    2.4
>3| 4.8 km|    4.8
>
>As the ' km' can't be added in column C, I used the LEFT formula to
>only 
>extract the first 3 digits, namely =LEFT(C2,3). This works wonderfully 
>in column D, BUT whilst not shown on the spreadsheet, the numbers are 
>shown in-between double quotes if one looks at the formula, in column
>D, 
>with the Function Wizard, which again does not enable the number to be 
>added, averaged etc.
>
>Both C, D columns are formatted as Number with a single decimal point 
>and there will be no -ve number.
>
>What am I missing, and where to rectify it?
>
>Regards
>Hylton
>
>-- 
>To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
>Problems?
>https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
>Posting guidelines + more:
>https://wiki.documentfoundation.org/Netiquette
>List archive: https://listarchives.libreoffice.org/global/users/
>Privacy Policy: https://www.documentfoundation.org/privacy

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy

Re: [libreoffice-users] My Question About Security

[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 computer 
without running a macro. Would love to know what that is. Please share.


On Jan 27, 2022, 6:37 PM, at 6:37 PM, toki  wrote:
>
>On 27/01/2022 11:59, Gabriele Ponzo wrote:
>> Your file is safe as long as it stays on your computer, but if you
>use some
>> Cloud storage such as OneDrive, DropBox or any other, we cannot grant
>it's
>> security.
>> And anyway, LibreOffice (usually) does not encrypt files. But yes, it
>does
>> not send them anywhere either, unless you ask it to do that.
>
>I'm being picky here, but templates can be created, and extensions can 
>be written, to send documents somewhere without the knowledge, consent,
>
>or authorization of the document creator.
>
>AFAIK, none of the currently available extensions _or_ templates 
>available on the LibO website have that security flaw.
>
>If one wants to dig deep into LibO configuration files, you can adjust 
>settings so that even if a malicious extension, or template is used, it
>
>won't send anything to the outside world.
>(Considering the current political climate, it probably would be a good
>
>idea to document that procedure, and put it on the LibO Documentation
>page.)
>
>tldr: Don't install any extensions, create your own templates, and 
>you'll be secure.
>
>jonathon
>
>-- 
>To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
>Problems?
>https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
>Posting guidelines + more:
>https://wiki.documentfoundation.org/Netiquette
>List archive: https://listarchives.libreoffice.org/global/users/
>Privacy Policy: https://www.documentfoundation.org/privacy

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy

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

[Andrew Pitonyak]

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:  Mon, 7 Feb 2022 17:17:07 +


> On 06/02/2022 22:28, Jean-Baptiste Faure wrote:
> > Hi,
> >
> > Le 03/02/2022 à 10:56, Michael D. Setzer II a écrit :
> >> Yesterday, Downloaded and installed and it reports a
> >> crash, but just gives option to submit it, but no details.
> >> Come up in safe mode, but opening calc just drops to
> >> command prompt.
> >> Tried running with strace, and don't see anything that
> >> looks like error.
> >> Have the Fedora 34 regular latest version running fine,
> >> and have the had 7.2.x versions up to 7.2.5 and both work
> >> fine.
> >> Thought perhaps having 7.2.5 and 7.3 caused issue, so
> >> uninstalled both, and then reinstalled 7.3, but same
> >> results.> >> Have uninstalled 7.3, and put the 7.2.5 back, and it is
> >> working.> >> Only tested with Calc, so not sure if 7.3 had other items
> >> working?> >> Don't know what it actual submitted with the error it
> >> found, or if includes any way to contact me of issue?
> >> Thanks.> >>
> >
> > Seems like this bugreport:
> > https://bugs.documentfoundation.org/show_bug.cgi?id=146990
> >
> > Best regards.> > JBF
>
> Now https://bugs.documentfoundation.org/show_bug.cgi?id=147135
>
> This bug has been reported in the forums of a number Linux distros. The
> issue is very random and appears to only arise in some hardware
> environments.
>
> For example, I run PCLinuxOS with either Intel or AMD based hardware on
> a number of machines and I cannot reproduce the crash. For others with
> near equivalent hardware and software environments to mine, the crash is
> 100% reproducible.>
> This is going to be a difficult one for the devs to track down.
>


Did notice something in message log file.
If run libreoffice7.3 but don't try calc there is nothing,
but if try calc and it crashes the log has these lines??


Feb  8 11:04:04 setzconote audit[513755]: ANOM_ABEND auid=1000 uid=0 gid=0 
ses=2 subj=unconfined_u:unconfined_r:unconfined_t:s0-s0:c0.c1023 pid=513755 
comm="soffice.bin" exe="/opt/libreoffice7.3/program/soffice.bin"
sig=4 res=1
Feb  8 11:04:05 setzconote abrt-server[513792]: Package 'libreoffice7.3' isn't 
signed with proper key

Unfortuantely, the lines on abrt at time don't seem to show anything to me.
Feb  8 11:04:05 setzconote abrt-dump-journal-oops[2039]: 
abrt-dump-journal-oops: Found oopses: 1
Feb  8 11:04:05 setzconote abrt-dump-journal-oops[2039]: 
abrt-dump-journal-oops: Creating problem directories
Feb  8 11:04:05 setzconote abrt-server[513792]: Package 'libreoffice7.3' isn't 
signed with proper keyFeb  8 11:04:05 setzconote abrt-server[513792]: 
'post-create' on '/var/spool/abrt/ccpp-2022-02-08-11:04:05.227869-513755' 
exited with 1
Feb  8 11:04:05 setzconote abrt-server[513792]: Deleting problem directory 
'/var/spool/abrt/ccpp-2022-02-08-11:04:05.227869-513755'
Feb  8 11:04:06 setzconote abrt-server[513791]: Can't find a meaningful 
backtrace for hashing in '.'
Feb  8 11:04:06 setzconote abrt-server[513791]: Preserving oops '.' because 
DropNotReportableOopses is 'no'
Feb  8 11:04:06 setzconote abrt-notification[513811]: System encountered a 
non-fatal error in ??()
Feb  8 11:04:06 setzconote abrt-dump-journal-oops[2039]: Reported 1 kernel 
oopses to Abrt


> Regards
> Dave
>

 What I am about to say has no bearing on anything related to reality, but, 
this is what I had to do to make VMWare work on Fedora after I built my own  
binaries. The likliehood that this will work for you is very small indeed. 

I think you will need to create a password for signing. I do not remember when, 
but, just think of a password and write it down or something. 

(1) Generate a key, but do NOT use CN=VMware, use something like CN=LibreOffice
openssl req -new -x509 -newkey rsa:2048 -keyout MOK.priv -outform DER -out 
MOK.der -nodes -days 36500 -subj "/CN=VMware/"

(2) Import said key
mokutil --import MOK.der

(3) Sign 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 
version in the repo? 

I only mention all this because if it were me I would try it, but I am on 
Fedora 35 now and I am using the version from the fedora repo. 

Andrew

 

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy

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

[Andrew Pitonyak]

On Monday, October 02, 2023 09:02 EDT, Uwe Brauer  wrote:
 So I thought

| Marks | Scaled |
|---+|
| 1 | =A1/max(A1:A7) |
| 2 | |
| 3 | |
| 4 | |
| 5 | |
| 6 | |
| 7 | |

That gives the correct entry for B1, however if now, drag with the mouse
down that formula I obtain

| Marks | Scaled |
|---+|
| 7 | =A1/max(A1:A7) |
| 2 | =B1/max(A2:A7) |
| 3 | |
| 4 | |
| 5 | |
| 6 | |
| 1 | |



Which is not what I want.

That is a very elementary question, but google does not help me.
regards


Uwe Brauer
Your question is a good one. 

Either I misunderstand your question or you are doing something I do not know 
(so you can teach me something) and I will provide what I think can be a 
solution to your problem. Let me start with what I do not understand.

Where you have B1/max(A2:A7), I actually expected it to be A2:A8, but I have 
never actually "dragged a formula" so some of what I am about to say could be 
wrong. Also, perhaps you can tell me how to "drag with the mouse". My best 
guess is that either (1) there is a feature I do not know or (2) you are doing 
some kind of selection while entering a formula (which I know can be done but 
again, somthing I do not usually do). I usually drag with a mouse when I am 
simply selecting cells, but I am unser how to drag a formula. Then again, I 
also do not remember how to do array formulas (I think that is what they call 
them) even if I did play with them once some years back.

All that said, how I normally solve this problem would be as follows: 

1. Enter the formula =A1/max(A1:A7) in cell B1
2. Select cell B1 and copy it to the clipboard.
3. Select cells B2:B7, and choose paste. 

The problem is that every cell reference is considered relative to the cell 
containing the formula. If I copy cell B1 and paste into cell B2, the column 
has not changed so column references stay the same but the row is now one 
greater so every row reference will increase by one. So in cell B2 I expect to 
see

=A2/max(A2:A8)

Paste into cell C2, so the row is one greater and the colun is one greater so 
the formula is

=B2/max(B2/B8)

All referenced cells are assumed to be relative to the cell where the formula 
is entered. If you place a dollar sign $ before a row or column in an address 
then it is taken to be an absolute address. So if I change the formula in cell 
B1 to be

=A1/max(A$1:A$7)

If I copy that formula from Cell B1 and paste that into cell D3, I have gone 
right two columns and down two rows so it will try to add two to every row and 
every column and I end up with the formula

=C3/max(C$1:C$7)

In your case this would have been sufficient because you were copying into 
cells B2:B7 and did not change the column. You could enter this as

=$A1/max($A$1:$A$7)

then the formula will always refence column A and only the very first row will 
increment because it is not preceded by a $.

Note that if I insert a row into the middle, cell A7 becomes A8 and all 
references to A7, or even $A$7 will become $A$8. 


Finally, a cell address can include the sheet name, and the same applies to 
sheet names. My default sheet name is "Sheet1", so, I can set my formula to be

=Sheet1.A1/max(A1:A7)

If I copy this and paste it into cell B2 on Sheet 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-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy

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

[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 been in basic.

⁣Get BlueMail for Android ​

On Apr 20, 2022, 12:58 PM, at 12:58 PM, Albin  wrote:
>Hello,
>
>Just wondering if you've received this question?
>
>Respectfully,
>
>-albin
>___
>Digital Wizard | NeuroLeap Corp | San Jose, CA, USA
>*Special Power for Special Children!*
>The content of this email is confidential and intended for the
>recipient
>specified in message only. It is strictly forbidden to share any part
>of
>this message with any third party, without a written consent of the
>sender.
>If you received this message by mistake, please reply to this message
>and
>follow with its deletion, so that we can ensure such a mistake does not
>occur in the future.
>
>
>On Fri, Apr 15, 2022 at 10:51 PM Albin  wrote:
>
>> Hello,
>>
>> We have spreadsheets filled out by our psychologists and other
>> specialists, which are periodically (in the background) parsed and
>sent to
>> a database on our servers.
>> Currently, we are using Google Sheets and Google Cloud, however, we
>need
>> to migrate to another solution. Since we have no profits and no
>budget to
>> buy anything, I was wondering if we could accomplish the parsing via
>> scripts (preferably using Python) using LibreOffice Calc Online?
>>
>> Thank you.
>>
>> Respectfully,
>>
>> -albin
>> ___
>> Digital Wizard | NeuroLeap Corp | San Jose, CA, USA
>> *Special Power for Special Children!*
>> The content of this email is confidential and intended for the
>recipient
>> specified in message only. It is strictly forbidden to share any part
>of
>> this message with any third party, without a written consent of the
>sender.
>> If you received this message by mistake, please reply to this message
>and
>> follow with its deletion, so that we can ensure such a mistake does
>not
>> occur in the future.
>>
>
>-- 
>To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
>Problems?
>https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
>Posting guidelines + more:
>https://wiki.documentfoundation.org/Netiquette
>List archive: https://listarchives.libreoffice.org/global/users/
>Privacy Policy: https://www.documentfoundation.org/privacy

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy

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

[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 am not saying it's not an error, but I suspect it has to do with how the 
array statement creates an array. I remember correctly I found a couple odd 
things about it.

⁣Get BlueMail for Android ​

On Jul 10, 2022, 2:02 PM, at 2:02 PM, Johnny Rosenberg  
wrote:
>Hi.
>
>Is this a bug or is my brain just not working?
>
>
>
>
>
>*Sub ResizeArrayTest Dim MyArray(5) As Long MyArray=Array(1, 2,
>3,
>4, 5, 6) ReDim Preserve MyArray(4)End Sub*
>
>Running this creates the array MyArray, but it's *empty*, so it seems
>like ”
>*Preserve*” doesn't work here. Or what am I doing wrong? I'm sure I
>have
>got Preserve to work many times before, but maybe my brain crashed this
>time.
>
>Using LibreOffice 7.2.7.2 on Ubuntu Studio 20.04.
>
>Kind regards
>
>Johnny Rosenberg
>
>-- 
>To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
>Problems?
>https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
>Posting guidelines + more:
>https://wiki.documentfoundation.org/Netiquette
>List archive: https://listarchives.libreoffice.org/global/users/
>Privacy Policy: https://www.documentfoundation.org/privacy

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy

Re: [libreoffice-users] ROUND function consistency

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

https://docs.microsoft.com/en-us/office/vba/language/reference/user-interface-help/round-function

With "Bankers Rounding", when numbers are equidistant from the two nearest 
integers, they are rounded to the nearest even integer; therefore, 0.5 rounds 
down to 0; 1.5 rounds up to 2.

So, it looks like you are getting the correct answer because you turned on VBA 
support so the round function should act like the VBA round function. If you 
really were writing a macro using Microsoft Office (MSO), you would probably 
have used Math.Round() (I think that is what it is called) to use the rounding 
that you were expecting. 


On Saturday, June 04, 2022 22:44 EDT, Steve Edmonds 
 wrote:
 I have just put a basic macro together so it will calculate income tax
due from our local tax rates.
I needed to round the tax to the nearest cent so taking the easy route I
added Option VBASupport 1 to use the available VB round function.

I then noticed that the VB round function with say round(12.125,2)
rounds down to 12.12 and the LO inbuilt spread sheet function ROUND with
ROUND(12.125,2) rounds up to 12.13.

Is rounding in this situation arbitrary or is there some some convention
for consistency.

Steve


--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy

 

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy

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

[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 creating your own dialogues, but with that, 
you can pretty much do whatever you want in terms of input. 

⁣Get BlueMail for Android ​

On Jul 24, 2022, 3:22 AM, at 3:22 AM, "Michael D. Setzer II" 
 wrote:
>Have gotten this macro to do what I want, but the process requires two 
>inputbox commands. Was trying to find a way to have a single dialog
>rather 
>than two. All the searches come up with thing not even closely related
>to what I 
>am looking for. Many are linked to Calc or Base or have super complex
>step.
>Want a single form or whatever to enter the to: info and subject: info.
>Have tried dozens of search terms but not finding an example. 
>
>Sub Mailto
>Dim oDoc As Object
>Dim Path$, sendto$,subject$,cmd$
>oDoc = ThisComponent
>Path$ = oDoc.getURL()
>sendto$ = InputBox ("To:")
>subject$ = InputBox("Subject:")
>If oDoc.HasLocation() Then
>  subject$=replace(subject$," ","%20")
>  cmd$="/home/msetzerii/.wine/drive_c/PMAIL/Programs/WSENDTO.EXE " 
>(Path$,8,100) &" "&" 
>mailto:"$$(63)&"subject="$&"=SENDING%20"&
>mid(Path$,8,100)
>  shell(cmd$)
>Else
>  Print "The document has not yet been stored"
>End If
>End Sub
>++
> Michael D. Setzer II - Computer Science Instructor (Retired) 
> mailto:mi...@guam.net
> mailto:msetze...@gmail.com
> Guam - Where America's Day Begins
> G4L Disk Imaging Project maintainer 
> http://sourceforge.net/projects/g4l/
>++
>
>
>
>
>-- 
>To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
>Problems?
>https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
>Posting guidelines + more:
>https://wiki.documentfoundation.org/Netiquette
>List archive: https://listarchives.libreoffice.org/global/users/
>Privacy Policy: https://www.documentfoundation.org/privacy

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy

Re: [libreoffice-users] Macros in spreadsheets

[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 remember 
the key strokes but I know it's there something like tools recalculator 
something or maybe it's update all I guess

That said, you can associate events to macros. I do believe. I don't do it 
often, but I believe you can. So you can set a macro to run when a document 
opens and maybe that's what you want.

I don't remember offhand how to get to events. You can associate a macro to run 
when an event occurs, but I have done it. I designed some macros for a company 
that wanted things to auto calculate when they opened a template.

For me, learning macros was easier by simply looking at examples and then 
modifying them for my own uses. But you're asking how to cause macros to run 
based on certain conditions, not how do you accomplish a specific task.

Best of luck.

⁣Get BlueMail for Android ​

On Dec 23, 2022, 10:51 AM, at 10:51 AM, Michael Tiernan 
 wrote:
>I have a couple of BASIC macros in a spreadsheet.
>
>I keep thinking that there must be a "init" function that isn't being 
>called because each time I open the spreadsheet, the macros don't run.
>I 
>have to mess about a bit and then force each cell to recalculate 
>manually. (I'm sure that there's a global 'recalculate' button/tool 
>somewhere but that's secondary to the problem.)
>
>I know there's a lot of documentation out there on macros (almost too 
>much) but I'm not sure where to start reading, does anyone have a 
>pointer that would address, not how to create a macro but how to 
>incorporate it to become automatic?
>
>Thanks.
>
>-- 
>   << MCT >> Michael C Tiernan. http://www.linkedin.com/in/mtiernan
>   Non Impediti Ratione Cogatationis
>   Women and cats will do as they please, and men and dogs
>should relax and get used to the idea. -Robert A. Heinlein
>
>
>-- 
>To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
>Problems?
>https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
>Posting guidelines + more:
>https://wiki.documentfoundation.org/Netiquette
>List archive: https://listarchives.libreoffice.org/global/users/
>Privacy Policy: https://www.documentfoundation.org/privacy

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy

Re: [libreoffice-users] Macros in spreadsheets

[Andrew Pitonyak]

I am having trouble following what is happening (and I guess I missed the first 
reply.

First, it looks like the cell D2 is calling a macro. 

If I understand, the cells are NOT recalculating so you are causing each one to 
run manually. What happens if you use 

Data > Calculate > Recalculate (or F9) to cause every cell to recalculate?

If that works, you can also write a macro to cause it to recalculate. I do not 
remember off hand how to do that (and I don't want to take the time to look it 
up), but, I did record this macro that uses the dispatcher to do it. I feel 
like it is cheating but it should work just fine.

sub recalculate
  document   = ThisComponent.CurrentController.Frame
  dispatcher = createUnoService("com.sun.star.frame.DispatchHelper")
  dispatcher.executeDispatch(document, ".uno:Calculate", "", 0, Array())
end sub


On Monday, 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 force a recalculate, it's
> that I have to in order to get the macros to respond.
>
> Here's an example: (What I expect when the spreadsheet finishes opening.)
>
> /*Cell*//*
> */ /*Contents*//*
> */ /*Display*//*
> */
> D1
> 192.168.17.231/24
> 192.168.17.231/24
> D2
> =ipwithoutmask(D1)
> 192.168.17.231
> D3
> =ipmask(D1)
> 255.255.255.0
> D4
> =ipmasklken(D3)
> 24
>
> Now, when I actually do open the spreadsheet, it says:
>
> /*Cell*//*
> */ /*Contents*//*
> */ /*Display*//*
> */
> D1
> 192.168.17.231/24
> 192.168.17.231/24
> D2
> =ipwithoutmask(D1)
> #NAME?
> D3
> =ipmask(D1)
> #NAME?
> D4
> =ipmasklken(D3)
> #NAME?
>
> So, if I say it differently, it *seems* like the Macros aren't run
> when the spreadsheet is opened.
>
> The macro library has a "Main" entry that is empty. If I choose
> "Tools" -> "Macros" -> "Run macro" and then select "Main" and execute
> it, there's no visible change.
>
> BUT, if I go into the contents of "D2" and add a space at the end of
> the formula "=ipwithoutmask(D1)" to read "=ipwithoutmask(D1) " and hit
> return and the macro executes and displays the proper value.
>
> HOWEVER, none of the other cells change so I have to go into each one
> and do the same sort of thing, add a space at the end of the line or
> between the macro and the parenthesis, each time, hit return and it
> works properly.
>
> This is obviously not the correct way it should work.
>
> Hence my query about "starting" macros when the document is opened.
>
> So, that leads to, am *I* doing something wrong?
>
> Thanks for everyone's time.
>
Not being familiar with Calc's macro functionality, what you are showing
as your macro references looks like a formula, so I would check two
things, which you may have already checked as I also haven't been
following this thread, check your macro security options as they may be
preventing your macros from running as the default option is to prevent
unsigned macros from running. Also check your formula "recalculate of
load" options as they may be set to not recalculate.

With your main entry being empty I would expect running that to actually
do nothing.
Looking at the existing macro definitions and the way they are shown
when placing the cursor in them, I would assume your macros are within a
module, so when you reference the macro in your formula, do you need to
reference is as, for example, .ipwithoutmask(D1)?

regards,
Steve

 

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy

Re: [libreoffice-users] File conversion issue

[Andrew Pitonyak]

Is this only text? I assume there is embedded content of some sort or some kind 
of fancy break going on. Is there a frame?

When I had a problem it was specifically with an ODT file, so I copied it to a 
zip file, unzipped it and then I was able to look at the content to what sort 
of funny 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 pitonyak,
>Thanks for replying to my email. I tried to break the file and verified
>. Here I have observed that two paragraphs are causing problems(1 page)
>and removed that page from the file and it worked fine. Again, by
>keeping the problematic page only passed separately and it also worked
>fine. But including both is not working. Any idea like why we are
>facing this behaviours with file?
>
>Thanks
>Shivaprasad
>
>From: Andrew Pitonyak 
>Date: Tuesday, 29 November 2022 at 7:10 PM
>To: lo.harald.ber...@t-online.de 
>Cc: Bathula, Shiva Prasad ,
>users@global.libreoffice.org 
>Subject: Re: [libreoffice-users] File conversion issue
>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 with a specific anchor type.
>
>Are you able to remove parts of the document and still reproduce the
>crash?
>
>Is the document long and perhaps there might be a timeout?
>
>Are you able to modify the text (like change every letter to an X)?
>
>Just a few thoughts.
>
>On Tuesday, November 29, 2022 07:02 EST, lo.harald.ber...@t-online.de
>wrote:
>
>Please try an error description on Bugzilla. Thank you.
>https://bugs.documentfoundation.org/
>
>Am 29.11.2022 um 11:57 schrieb Bathula, Shiva Prasad:
>> We have been using libreoffice software for the last one and half
>years to convert files like .doc, .docx, .jpg, .PNG, .tiff … files to
>.pdf. Recently, some .docx files are failing to convert to .pdf. Here
>we are using Libreoffice in Java code and in AWS lambda (Node.js). We
>are not getting any clue because only some files are failing to convert
>with Java code and with Node.js code((Lambda is getting timeout and
>throwing “Command failed”) also. We can’t share the failed file here
>because it is a client file. So could you please provide possible
>causes for failures.
>
>
>
>--
>To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
>Problems?
>https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
>Posting guidelines + more:
>https://wiki.documentfoundation.org/Netiquette
>List archive: https://listarchives.libreoffice.org/global/users/
>Privacy Policy: https://www.documentfoundation.org/privacy
>
>
>
>This e-mail, including attachments, may include confidential and/or
>proprietary information, and may be used only by the person or entity
>to which it is addressed. If the reader of this e-mail is not the
>intended
>recipient or intended recipient’s authorized agent, the reader is
>hereby
>notified that any dissemination, distribution or copying of this e-mail
>is
>prohibited. If you have received this e-mail in error, please notify
>the
>sender by replying to this message and delete this e-mail immediately.

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy

Re: [libreoffice-users] File conversion issue

[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 
with a specific anchor type. 

Are you able to remove parts of the document and still reproduce the crash? 

Is the document long and perhaps there might be a timeout?

Are you able to modify the text (like change every letter to an X)?

Just a few thoughts. 

On Tuesday, November 29, 2022 07:02 EST, lo.harald.ber...@t-online.de wrote:
 Please try an error description on Bugzilla. Thank you.
https://bugs.documentfoundation.org/

Am 29.11.2022 um 11:57 schrieb Bathula, Shiva Prasad:
> We have been using libreoffice software for the last one and half years to 
> convert files like .doc, .docx, .jpg, .PNG, .tiff … files to .pdf. Recently, 
> some .docx files are failing to convert to .pdf. Here we are using 
> Libreoffice in Java code and in AWS lambda (Node.js). We are not getting any 
> clue because only some files are failing to convert with Java code and with 
> Node.js code((Lambda is getting timeout and throwing “Command failed”) also. 
> We can’t share the failed file here because it is a client file. So could you 
> please provide possible causes for failures.



--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy

 

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy

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

[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 for basic using find.




⁣Get BlueMail for Android ​

On Nov 24, 2022, 4:55 PM, at 4:55 PM, Tim Lloyd  wrote:
>Hi,
>
>Running Fedora 36
>
>Currently LO version 7.3.7.2
>
>Earlier this week I had huge problems due to power spikes. I had 
>problems accessing my LO documents and I thought it best to uninstall 
>and reinstall. This I did from the fedora repos.
>
>This is an old problem where I exit and save a writer doc on "this"
>page 
>but it goes to "that" page when I reopen the document. From memory 
>setting up personal data is the key to getting this to work and I have 
>done that.
>
>Any ideas why I can't open up again where I left off?
>
>My config/libreoffice/ files are intact from before the uninstall. I 
>would delete these but I am not sure how to store my macros.
>
>Regards
>
>
>-- 
>To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
>Problems?
>https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
>Posting guidelines + more:
>https://wiki.documentfoundation.org/Netiquette
>List archive: https://listarchives.libreoffice.org/global/users/
>Privacy Policy: https://www.documentfoundation.org/privacy

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy

Re: [libreoffice-users] Basic Macros with Base

[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 have examples in AndrewBase.odt if that is of any help to you. 

https://www.pitonyak.org/database/
https://www.pitonyak.org/database/AndrewBase.odt (called Random DB Ramblins, 
and yes that is spelled incorrectly).


On Tuesday, January 24, 2023 14:32 EST, Harvey Nimmo  wrote:
 Where can I find the syntax of the DoCmd.RunSQL command to be used with
a LOBase Macro in Basic?

My assumption was 
X = "SQL string"
DoCmD.RunSQL X

The SQL string runs correctly is correct when executed as SQL Command
in the Base Tools/SQL window.

The Basic Macro with the above statemsnt compiles without error when
the SQL command text is enclosed in "" quotes. But at runtime it halts
with the message that the variable X is not set. However, a Basic Print
statement shows the correct value for X.

(By the way, the Watch function displays no values for any variable.
Not sure if it should)

My conclusion is that I ma using the wrong syntax for DoCmd.RunSQL

Any ideas?
 
 

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy

Re: [libreoffice-users] Basic Macros with Base

[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 
should act similarly to how the method work in MS Access (again a guess). 

When I really want to know, I pull the code and then I go looking for the 
method in the code to see what it does. 

Also, if it immediately registers as an error, then you might need to turn on 
compatibility mode. 

Well, that is what I thought until I googled a bit

This implies that the command is based on an extension rather than directly 
supported by LO.

https://extensions.libreoffice.org/en/extensions/show/access2base
https://extensions.openoffice.org/en/project/access2base-api-base-users
https://ask.libreoffice.org/t/syntax-form-controls-base/45282

but then this seems to imply otherwise

https://books.libreoffice.org/en/BG72/BG7209-Macros.html

Sorry, not much help :-(


On Tuesday, January 24, 2023 15:50 EST, Harvey Nimmo  wrote:
 Thanks. Not sure I can understand how that should work...hmmm

I based my syntax on the example here

https://learn.microsoft.com/en-us/office/vba/api/access.docmd.runsql



On Tue, 2023-01-24 at 20:39 +, Dave Howorth wrote:
> On Tue, 24 Jan 2023 20:32:18 +0100
> Harvey Nimmo  wrote:
>
> > Where can I find the syntax of the DoCmd.RunSQL command to be used
> > with a LOBase Macro in Basic?
>
> I've never heard of the command, but google suggests
>
> https://docs.libreoffice.org/wizards/html/classaccess2base_1_1DoCmd.html#a3c1b223e5e4024f2a8b955b2df3b6f92
>
> I've no idea whether it is correct/relevant.
>
> > My assumption was 
> > X = "SQL string"
> > DoCmD.RunSQL X

 

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy

Re: [libreoffice-users] Basic Macros with Base

[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, 3:21 AM, at 3:21 AM, Harvey Nimmo  wrote:
>Hi Robert,
>
>the thought occurs to me that the existing quotes within the SQL
>statements may need their own treatment. The statements that work under
>the LOBase Tools>SQL... function have different type of single
>quotemarks for the column names (e.g. containing two separate words) or
>the text to be set in the columns. I have assumed that the macro (SQL)
>string variables just need to be enclosed in double quotemarks. Is this
>right?
>
>Cheers
>Harvey
>
>
>On Wed, 2023-01-25 at 21:51 +0100, Robert Großkopf wrote:
>> Hi Harvey,
>> > 
>> > how would this work for me, where I only want to create a SQL
>> > statement
>> > as a string and execute it. 
>> 
>> Mcro works with SQL-code, which has been saved in a field of a table.
>> Field in the table is called "SQL-Code". Table is datasource of a
>> form. 
>> A button in this form will start the code.
>> 
>> First needed object is executing a button in the form to start the 
>> procedure.
>> 
>> If you will save all code directly in a macro you will need
>> → a connection to the database
>> → SQL code, which has been maskes with double doublequotes for 
>> fieldnames and tablenames
>> → var for creating a statement
>> → execute the sql-code in this created statement
>> 
>> At which line of the macro the code stops for you?
>> > > 
>> > > Here a code from German Base Handbuch:
>> > > 
>> > > SUB ChangeData(oEvent AS OBJECT)
>> > >    DIM oConnection AS OBJECT
>> > >    DIM oForm AS OBJECT
>> > >    DIM stSql AS STRING
>> > >    DIM oSql_Statement AS OBJECT
>> > >    DIM inValue AS INTEGER
>> > >    oForm = oEvent.Source.Model.Parent
>> > >    oConnection = oForm.activeConnection()
>> > >    stSQL = oForm.getString(oForm.findColumn("SQL-Code"))
>> > >    inValue = MsgBox("Should SQL-Code" & CHR(13) & stSQL & CHR(13)
>> > > &
>> > > "be executed?", 20, "Execute SQL-Code")
>> > >    IF inValue = 6 THEN
>> > >    oSQL_Statement = oConnection.createStatement()
>> > >    oSQL_Statement.execute(stSql)
>> > >    END IF
>> > > END SUB
>> > > 
>> > > SQL-Code is part of a table. Field in the table is "SQL-Code".
>> > > Table
>> > > is
>> > > datasource of a form. A button in this form will be enough to
>> > > execute
>> > > the macro. You coud update, insert or delete rows by command
>> > > "execute".
>> 
>> Regards
>> 
>> Robert
>> -- 
>> Homepage: https://www.familiegrosskopf.de/robert
>> 
>> 
>
>
>-- 
>To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
>Problems?
>https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
>Posting guidelines + more:
>https://wiki.documentfoundation.org/Netiquette
>List archive: https://listarchives.libreoffice.org/global/users/
>Privacy Policy: https://www.documentfoundation.org/privacy

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy

Re: [libreoffice-users] Database back end?

[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 writing 
macros inside the base document to connect to the actual database portion.

I think I said that very poorly, but I don't think you could use something like 
JDBC to access. Base is the big issue here.

And my opinion, if you are writing a web app and you intend to use Java, you 
might be better off with another database as your back end.

But now some others more experienced than I can weigh in.

I have however used base to access other backend databases then what is used 
internally to base. The back end database for internal based documents is HSQL 
I believe.

⁣Get BlueMail for Android ​

On Feb 18, 2023, 7:11 PM, at 7:11 PM, Amn Ojee Uw  wrote:
>I was wondering if it would be possible to hookup a Java Web
>Application 
>I am working on to LibreOffice's Base back-end.
>If it is possible, where can I find the API and a stand alone LO-Base?
>
>Thanks!
>
>
>-- 
>To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
>Problems?
>https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
>Posting guidelines + more:
>https://wiki.documentfoundation.org/Netiquette
>List archive: https://listarchives.libreoffice.org/global/users/
>Privacy Policy: https://www.documentfoundation.org/privacy

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy

Re: [libreoffice-users] LibreOffice parent company

[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: users+unsubscr...@global.libreoffice.org
>Problems?
>https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
>Posting guidelines + more:
>https://wiki.documentfoundation.org/Netiquette
>List archive: https://listarchives.libreoffice.org/global/users/
>Privacy Policy: https://www.documentfoundation.org/privacy

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy

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

[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, 2023, 4:09 PM, at 4:09 PM, Johnny Rosenberg  
wrote:
>Den tors 27 apr. 2023 kl 10:55 skrev Rose Gale
>:
>
>> Hello:
>>I don't know if anyone has encountered this problem, but I
>haven't
>> been able to find the right solution. I hope I can get some helpful
>> suggestions here.
>>I'd like to start by stating that I can only do this in c# for
>a
>> variety of reasons
>>I need to get the height of the content on the last page of
>the
>> document. I have drawn a sketch below for your understanding.
>>
>
>Only text is accepted in this mailing list, so everything else is
>stripped
>away. Upload it somewhere and give us the link instead.
>
>
>>
>>I have found some classes on the official website, but I do
>not know
>> whether they are useful or how to use them.
>> [image: image.png]
>>
>>  Actually, to achieve functions similar to Word : var height =
>>
>objrage.get_Information(WdInformation.wdVerticalPositionRelativeToPage);
>>
>>
>> Best Regards
>>
>> --
>> To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
>> Problems?
>>
>https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
>> Posting guidelines + more:
>https://wiki.documentfoundation.org/Netiquette
>> List archive: https://listarchives.libreoffice.org/global/users/
>> Privacy Policy: https://www.documentfoundation.org/privacy
>>
>
>-- 
>To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
>Problems?
>https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
>Posting guidelines + more:
>https://wiki.documentfoundation.org/Netiquette
>List archive: https://listarchives.libreoffice.org/global/users/
>Privacy Policy: https://www.documentfoundation.org/privacy

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy

Re: [libreoffice-users] last cursor position

[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 Fedora and I have version 7.5.3.2 of LO. 
Pretty sure that LO was installed from the repos rather than a direct download, 
but I simply do not remember. 

On Sunday, July 23, 2023 17:30 EDT, Chuck Stuettgen  
wrote:
 This bug appeared beginning in version 7.1.0.1. Since then there have been
82 releases of LibreOffice. There have been 13 releases of 7.5 which was
when it was supposed to have been fixed. Now 7.6 has been released.

Apparently, we are in the minority of the more than 200 million users of
LibreOffice for whom this is a problem. I can only surmise the rest of 200
million users are only editing short 1 or 2 page documents so never
encounter the problem.

I wasn't aware of the SHIFT F5 workaround and wound up removing the distro
supplied version and installed 7.0.6.2 from the Document Foundation's
download site. 7.0.6.2 is the last version without the bug.

Would I prefer to use a more up to date version? Absolutely! But I
routinely edit documents of 100 pages or more and having to hunt down the
last edited location is a major problem.

Some day, when I don't have anything else to do, I'll set up another
computer and install the latest version to see if I can live with the
SHIFT-F5 work around.

Until then I'll stick with 7.0.6.2.
Chuck




On Sun, Jul 23, 2023 at 2:15 AM Thomas Blasejewicz  wrote:

> Good afternoon
> I am sure, this question has been asked a million times.
> When I open a document, the cursor is NOT in the position of the last edit.
> In fact, it appears at random locations, different each time I open the
> document.
>
> I have modified the user data section under tools, but that does not
> change anything.
> Deliberately editing the document at different locations, closing and
> reopening it (same computer),
> the cursor still pops up at totally unpredictable locations.
> This happens apparently also with other (not created by me) documents.
>
> Is there a smart trick, anything short of resetting the user profile?
>
> Thomas
>
> --
> To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
> Problems?
> https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
> Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
> List archive: https://listarchives.libreoffice.org/global/users/
> Privacy Policy: https://www.documentfoundation.org/privacy
>

--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy

 

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy

Re: [libreoffice-users] Base macros

[Andrew Pitonyak]

I have not dealt with Base for years now (say 15), but, I did create a database 
to track stuff that I own. The DB contained full scale images of the receipts. 
I did not do as our indicated, but, it does display properly scaled images in 
the image control. I took a look at the macros I wrote and I did nothing 
special in the macros (it seems)  to properly scale. 

My biggest error was to embed the entire full size image into the DB. 

I do have buttons that Add an Image (so select, load and store in DB), Delete 
an image (delete from DB), replace an image (so select from file system, then 
replace existing), and extract from the DB

I can directly email you a copy of an empy DB if it interests you, but I am not 
sure if it is useful or not. 

It sounds like you did it write, show a thumbnail stored in your DB and 
reference the actual file on disk. 

I am writing a database front 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 a database consisting of several flat-file tables with associated
forms. They contain information about plants, including several photos
(up to 6) per form. They are currently 150*150 "thumbnails", but the
photos themselves are larger, sometimes much larger.

I would like to add a feature that allows a viewer to open the photo up
in a separate window to screen maximum. I have seen several macros
online that purport to do that, but with limited documentation, and
apparently suited only for one photo per form. Moreover, I have little
experience with scripted macros, in Base (or any other program, for that
matter).

Can anyone help with this?

--

Regards,
Edwin Humphries
Mobile: 0435 672 457

I acknowledge the traditional Wodi Wodi custodians, their elders and
customs, of the Dharawal lands on which I live.

"At every moment he beholdeth a wondrous world, a new creation, and
goeth from astonishment to astonishment, and is lost in awe at the works
of the Lord of Oneness." Bahá'u'lláh
"... humans are interesting. With all the wonders there are in the
Universe, they invented boredom." Terry Pratchett, Hogfather
"The most beautiful thing we can experience is the mysterious. It is the
source of all true art and all science. He to whom this emotion is a
stranger, who can no longer pause to wonder and stand rapt in awe, is as
good as dead: his eyes are closed." Albert Einstein
"Stuff your eyes with wonder ... live as if you'd drop dead in ten
seconds. See the world. It's more fantastic than any dream made or paid
for in factories." Ray Bradbury
--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy

 

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy