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

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

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

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

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

[Andrew Douglas Pitonyak]

Is anyone able to associate this extension to me:

https://extensions.libreoffice.org/en/extensions/show/code-colorizer-formatter


If you cannot associate the extension to "and...@pitonyak.org", can I 
email the latest version for upload.




--
Andrew Pitonyak
My Macro Document: http://www.pitonyak.org/AndrewMacro.odt
Info:  http://www.pitonyak.org/oo.php


--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/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]

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

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

[libreoffice-users] Bug selecting text using the API

[Andrew Douglas Pitonyak]

Tested using LO 6.2.0.3 on Fedora Linux.

I wanted to find all instances of Italic text using the API and select 
that text. I created a simple document with four areas that were Italic. 
I used the following macro and, although FindAll does return all italic 
text, it only selects the last 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





--
Andrew Pitonyak
My Macro Document: http://www.pitonyak.org/AndrewMacro.odt
Info:  http://www.pitonyak.org/oo.php


--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/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] 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]

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] 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] 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] 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] 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] 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] Calc

[Andrew]

Not being a Windows user I can't comment on how LibreOffice works in 
that world. However, I would assume that the packages should all install 
so that you can switch between different applications (calc, writer, 
base, etc.).


I'd suggest that you wait for others on the list who can be more helpful 
than me.


Good luck

On 10/08/18 14:18, Peggy wrote:
Sorry. I meant 6.0.6. With Win 7 Pro, although I have a new computer 
on the way with Win 10 (probaby Home verson). This was the first time 
I wanted to use anything but LibreWriter, so when I couldn't find "Calc"
or any of the other ones like "Draw" or "Base" I downloaded the newest 
version (besides the one for early adopters) hoping all the modules 
would be there.

I didn't see anything about having to download them separately.

Thanks for replying!

On Fri, Aug 10, 2018 at 8:37 AM, Andrew <mailto:phaedr...@gmail.com>> wrote:


On 10/08/18 10:44, Peggy wrote:

All options but Writer are grayed out. I just installed the
latest version.
Is there something I can do to activate calc?

Can you give some more info to work on please: OS, and by 'latest
version' do you mean 6.1?

If so, then you may want to report a bug and roll your version back.


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

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

[Andrew]

On 10/08/18 10:44, Peggy wrote:

All options but Writer are grayed out. I just installed the latest version.
Is there something I can do to activate calc?

Can you give some more info to work on please: OS, and by 'latest 
version' do you mean 6.1?


If so, then you may want to report a bug and roll your version back.


--
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] LibO6.1 - no Quick-starter

[Andrew]

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


On 10/08/18 09:37, M Henri Day wrote:
> Den fre 10 aug. 2018 kl 10:04 skrev Andrew mailto:phaedr...@gmail.com>
> <mailto:phaedr...@gmail.com <mailto:phaedr...@gmail.com>>>:
>
>     Hi all
>
>     Have just downloaded and installed LibreOffice Version:
6.1.0.3 for
>     Linux Mint 19 ('Tara').
>
>     First off, thanks to all of the developers and team of
geniuses  who put
>     this great piece of software together and keep pushing its
quality to
>     ever greater heights. As always, the new install works smoothly,
>     and the  new interface is looking great.
>
>     I did notice that there is no longer an option to enable the
>     Quick-starter (in fact, there's now no longer any 'memory' menu
>     option
>     under 'options' within which to enable the Quick-starter). I
don't
>     know
>     if this is a feature or a bug from a development
perspective, but
>     from a
>     user perspective, it is a bug: I used to use it all of the
time and
>     found myself missing it immediately.
>
>     Is there any likelihood in the future to bring this option back?
>     Or, is
>     there something in one of the config files I might be able
to hack
>     as a
>     work around?
>
>     Anyway, thanks again to all involved. Great stuff and as
always, I am
>     very pleased my donations are being put to such a good
investment.
>
>     Best wishes
>
>     Andrew
>
>
> Andrew, wouldn't it suffice for your purposes to pin the
LibreOffice > icon(s) to the panel on LM (right click the icon
desired in the meny
> and choose the option «Pin to the panel») ? I'm using the same
version > of LMyou do (but LO 6.0.6.2 rather than 6.1.0.3 - still
waiting for
> the pre-release PPA to kick in) and it works very well for me
>
> Henri

Hi Henri

Thanks for the reply.

I have a series of 'drawers' in a side panel, into which I have
pinned
the LibO app launcher, so that enables me to launch the whole suite.
What I like(d) about the Quick-starter was being able to right
click it
and to select the specific application (e.g., calc, impress, etc.)
that
I wanted to use rather than to pin a set of specific app launchers
to my
panel.

I agree though that that will be an option if the development
decision
is to deprecate the use of the Quick-starter, although I hope they
don't! :-)

BTW - in using the PPA, when you update, does it automatically remove
the old version of LibO prior to installing the new, and does it
install
the three packages in the correct sequence? I guess it does, but I've
always been wary of that so have traditionally always done it
manually
via synaptic to remove the previous install and then dpkg -i to
install
the new packages.

Thanks again

Andrew


Thanks for your speedy reply, Andrew ! Currently I have three LO icons 
on my panel - the generic LO, Writer, and Calc, respectively, 
corresponding to the services I most often use. Clicking the 
first-named opens a menu allows me to choose from the other four 
services with a simple click, which I presume serves the same function 
as the Quick-starter which you describe above (I've never used it)


From what you wrote above, I got the impression that the Quick-starter 
option has been available to you in all LO versions previous to 
6.1.0.3, which surprised me, as on the 6.0.6..2 version I presntly 
have installed, I don't see any «memory» option (I'm using the 
Swedish-language version, but I doubt that it differs in this respect 
from the English-language version I presume you use). After doing some 
searching, I've been given to understand that it was deprecated quite 
some time ago, but that installing the «libreoffice-systray» package 
would work. However, this alternative may also have been deprecated, 
unfortunatelyI haven't a clue


With regard to the pre-release PPA, in my experience it installs the 
new version over the older one. It works very well, - which hasn't 
always been the case when I've manually installed a pre-release 
version from the LO website - the only problem is that I often have to 
wait a short while before the PPA becomes available to me. Thus, for 
example, version 6.1.0.3 was successfully added to the PPA some three 
days ago, but it still hasn't appeared on my Update Manager. However, 
I regard waiting a few extra days for it to come as a small price to 
pay for the convenience and reliability it hitherto has offered me..

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

[Andrew]

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


Hi all

Have just downloaded and installed LibreOffice Version: 6.1.0.3 for
Linux Mint 19 ('Tara').

First off, thanks to all of the developers and team of geniuses
who put
this great piece of software together and keep pushing its quality to
ever greater heights. As always, the new install works smoothly,
and the
new interface is looking great.

I did notice that there is no longer an option to enable the
Quick-starter (in fact, there's now no longer any 'memory' menu
option
under 'options' within which to enable the Quick-starter). I don't
know
if this is a feature or a bug from a development perspective, but
from a
user perspective, it is a bug: I used to use it all of the time and
found myself missing it immediately.

Is there any likelihood in the future to bring this option back?
Or, is
there something in one of the config files I might be able to hack
as a
work around?

Anyway, thanks again to all involved. Great stuff and as always, I am
very pleased my donations are being put to such a good investment.

Best wishes

    Andrew


Andrew, wouldn't it suffice for your purposes to pin the LibreOffice 
icon(s) to the panel on LM (right click the icon desired in the meny 
and choose the option «Pin to the panel») ? I'm using the same version 
of LMyou do (but LO 6.0.6.2 rather than 6.1.0.3 - still waiting for 
the pre-release PPA to kick in) and it works very well for me


Henri


Hi Henri

Thanks for the reply.

I have a series of 'drawers' in a side panel, into which I have pinned 
the LibO app launcher, so that enables me to launch the whole suite. 
What I like(d) about the Quick-starter was being able to right click it 
and to select the specific application (e.g., calc, impress, etc.) that 
I wanted to use rather than to pin a set of specific app launchers to my 
panel.


I agree though that that will be an option if the development decision 
is to deprecate the use of the Quick-starter, although I hope they 
don't! :-)


BTW - in using the PPA, when you update, does it automatically remove 
the old version of LibO prior to installing the new, and does it install 
the three packages in the correct sequence? I guess it does, but I've 
always been wary of that so have traditionally always done it manually 
via synaptic to remove the previous install and then dpkg -i to install 
the new packages.


Thanks again

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

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

[Andrew]

Hi all

Have just downloaded and installed LibreOffice Version: 6.1.0.3 for 
Linux Mint 19 ('Tara').


First off, thanks to all of the developers and team of geniuses who put 
this great piece of software together and keep pushing its quality to 
ever greater heights. As always, the new install works smoothly, and the 
new interface is looking great.


I did notice that there is no longer an option to enable the 
Quick-starter (in fact, there's now no longer any 'memory' menu option 
under 'options' within which to enable the Quick-starter). I don't know 
if this is a feature or a bug from a development perspective, but from a 
user perspective, it is a bug: I used to use it all of the time and 
found myself missing it immediately.


Is there any likelihood in the future to bring this option back? Or, is 
there something in one of the config files I might be able to hack as a 
work around?


Anyway, thanks again to all involved. Great stuff and as always, I am 
very pleased my donations are being put to such a good investment.


Best wishes

Andrew


--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/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] 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] 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]

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] 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] 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] 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] 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] convert xlsx to CSV (and utf8?)

[Andrew]

Thank you, but I don't understand.


On 08/28/2017 10:48 AM, leleu wrote:

http://mooedit.sourceforge.net/
allow to "save as" changing the codage.


Je la 28/08/2017 19:21, A skribis :

Thank you for responding.  Yes it opens without issue.

Yet another look at the conversion details made me notice I needed 
changes.  Below are two incarnations.  For one thing I had left out 
column formatting, which I guess is required?  No difference in any 
event.


apb@yellow:/usr/local/src/greetonix/src$ 
/usr/lib/libreoffice/program/soffice.bin 
-env:UserInstallation=file:///tmp/libreoffice-1 --headless 
--nolockcheck --convert-to txt:Text \(encoded\):UTF8 --infilter=MS 
Excel 97:44,34,76,1,1/2/2/2,1033,true,false KGI_Discontinued.xlsx

Error: source file could not be loaded
Error: source file could not be loaded
Error: source file could not be loaded
convert /usr/local/src/greetonix/src/KGI_Discontinued.xlsx -> 
/usr/local/src/greetonix/src/KGI_Discontinued.txt using filter : Text
Error: Please verify input parameters... (SfxBaseModel::impl_store 
 failed: 
0xc10)


Also tried:

apb@yellow:/usr/local/src/greetonix/src$ 
/usr/lib/libreoffice/program/soffice.bin 
-env:UserInstallation=file:///tmp/libreoffice_1 --infilter='MS Excel 
97:44,34,76,1,1/2/2/2,1033,true,false' --headless --nolockcheck 
--convert-to 'csv:Text - txt - csv (StarCalc):44,34,76,1' 
KGI_Discontinued.xlsx

*Error: source file could not be loaded*

apb@yellow:/usr/local/src/greetonix/src$ ll KGI_Discontinued.xlsx
-rw-rw-r-- 2 apb apb 88334 Aug 18 16:00 KGI_Discontinued.xlsx


Which is an improvement, but not the solution.  All I really did was 
rearrange the order of the parameters, change a hyphen to an 
underscore in the tmp file path and change double quotes to single 
quotes.  I think I recall reading somewhere that order matters so 
that's what likely eliminated the "verify input parameters" message.  
You may also notice I changed output from utf8 to csv. I need *both* 
utf8 & csv.


Maybe I need yet another rearrangement to eliminate the file load error?

Thank you!



On 08/27/2017 06:41 PM, James Knott wrote:

On 08/27/2017 08:59 PM, A wrote:

I'm trying to convert a file from .xlsx to CSV.  After googling until
my eyes were bleeding, the below is the best I could come up with.
I've tried various incarnations of the below this is just the latest.
Any ideas what's wrong here?  The input file clearly exists. ubuntu
16.04 LibreOffice 5.1.6.2 10m0(Build:2)

Thank you in advance!

~

apb@yellow:/usr/local/src/greetonix/src$
/usr/lib/libreoffice/program/soffice.bin
-env:UserInstallation=file:///tmp/libreoffice-1 --headless
--nolockcheck --convert-to csv:Text \(encoded\):UTF8 --infilter=MS
Excel 97:44,34,76,1,,1033,true,true,false,false KGI_Discontinued.xlsx
Error: source file could not be loaded
Error: source file could not be loaded
Error: source file could not be loaded
convert /usr/local/src/greetonix/src/KGI_Discontinued.xlsx ->
/usr/local/src/greetonix/src/KGI_Discontinued.csv using filter : Text
Error: Please verify input parameters... (SfxBaseModel::impl_store
 failed: 
0xc10)

apb@yellow:/usr/local/src/greetonix/src$

apb@yellow:/usr/local/src/greetonix/src$ ll KGI_Discontinued.xlsx

-rw-rw-r-- 2 apb apb 88334 Aug 18 16:00 KGI_Discontinued.xlsx

apb@yellow:/usr/local/src/greetonix/src$

What happens if you just open the file in LibreOffice?












--
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] convert xlsx to CSV

[Andrew]

Read .xlsx, write/convert to .csv format with utf8 characters. From the 
command line.



On 08/28/2017 05:51 AM, James Knott wrote:

Sorry, I misread. I thought you were trying to read a CSV.  LibreOffice
can read and write CSV.  To save, just use Save As and select CSV for
the filter.


On 08/28/2017 03:29 AM, A wrote:

It opens just fine.


On 08/27/2017 06:41 PM, James Knott wrote:

On 08/27/2017 08:59 PM, A wrote:

I'm trying to convert a file from .xlsx to CSV.  After googling until
my eyes were bleeding, the below is the best I could come up with.
I've tried various incarnations of the below this is just the latest.
Any ideas what's wrong here?  The input file clearly exists.  ubuntu
16.04 LibreOffice 5.1.6.2 10m0(Build:2)

Thank you in advance!

~

apb@yellow:/usr/local/src/greetonix/src$
/usr/lib/libreoffice/program/soffice.bin
-env:UserInstallation=file:///tmp/libreoffice-1 --headless
--nolockcheck --convert-to csv:Text \(encoded\):UTF8 --infilter=MS
Excel 97:44,34,76,1,,1033,true,true,false,false KGI_Discontinued.xlsx
Error: source file could not be loaded
Error: source file could not be loaded
Error: source file could not be loaded
convert /usr/local/src/greetonix/src/KGI_Discontinued.xlsx ->
/usr/local/src/greetonix/src/KGI_Discontinued.csv using filter : Text
Error: Please verify input parameters... (SfxBaseModel::impl_store
 failed:
0xc10)
apb@yellow:/usr/local/src/greetonix/src$

apb@yellow:/usr/local/src/greetonix/src$ ll KGI_Discontinued.xlsx

-rw-rw-r-- 2 apb apb 88334 Aug 18 16:00 KGI_Discontinued.xlsx

apb@yellow:/usr/local/src/greetonix/src$

What happens if you just open the file in LibreOffice?











--
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] convert xlsx to CSV

[Andrew]

It opens just fine.


On 08/27/2017 06:41 PM, James Knott wrote:

On 08/27/2017 08:59 PM, A wrote:

I'm trying to convert a file from .xlsx to CSV.  After googling until
my eyes were bleeding, the below is the best I could come up with.
I've tried various incarnations of the below this is just the latest.
Any ideas what's wrong here?  The input file clearly exists.  ubuntu
16.04 LibreOffice 5.1.6.2 10m0(Build:2)

Thank you in advance!

~

apb@yellow:/usr/local/src/greetonix/src$
/usr/lib/libreoffice/program/soffice.bin
-env:UserInstallation=file:///tmp/libreoffice-1 --headless
--nolockcheck --convert-to csv:Text \(encoded\):UTF8 --infilter=MS
Excel 97:44,34,76,1,,1033,true,true,false,false KGI_Discontinued.xlsx
Error: source file could not be loaded
Error: source file could not be loaded
Error: source file could not be loaded
convert /usr/local/src/greetonix/src/KGI_Discontinued.xlsx ->
/usr/local/src/greetonix/src/KGI_Discontinued.csv using filter : Text
Error: Please verify input parameters... (SfxBaseModel::impl_store
 failed: 0xc10)
apb@yellow:/usr/local/src/greetonix/src$

apb@yellow:/usr/local/src/greetonix/src$ ll KGI_Discontinued.xlsx

-rw-rw-r-- 2 apb apb 88334 Aug 18 16:00 KGI_Discontinued.xlsx

apb@yellow:/usr/local/src/greetonix/src$

What happens if you just open the file in LibreOffice?







--
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] 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] Base - automatically running a macro on form opening

[Andrew Douglas Pitonyak]

Well, for sure you can fire a macro when a document opens. I expect it 
is the same for a form, but I have not tried it. Try this:


Tools > Customize > Events

You can set macros for Document loading finished (for example). There is 
a drop-down in the bottom for "Save in". Set this to the form, not 
LibreOffice since you only want this for your specific form / document.


Next, you want a macro that is triggered when you move to the next 
record. I don't remember off hand if you can do this (I have not looked 
at it in a few years). If I did, I probably mention it in AndrewBase.odt 
if I ever did this specifically. I just don't remember and I do not have 
time to look it up right now.



On 02/06/2016 04:52 AM, Marion & Noel Lodge wrote:

Hi Egbert,

If you are running on a Windows machine, I have found ways to do what you
were asking and I could make some suggestions if that would help.

Noel
--
Noel Lodge
lodg...@gmail.com

On 4 February 2016 at 14:59, Egbert Eissing <nicari...@yahoo.co.uk> wrote:


I need to fire up a macro automatically when I open a form, or when I move
to the next record.
There is obviously no form event that allows me to do that. I have placed
a simple macro, containing nothing but a message box into all relevant
event slots, to see whether any one of them will fire. But none did. This
appears to be strange to me, lacking such an important function.I am now
using a button to run my macro, but this is unsatisfactory.
Does anyone have an idea how I can accomplish my task?Thanks for any
help.Egbert

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



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

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] Save UNO state?

[Andrew Douglas Pitonyak]

Yes, you can certainly compare properties, but it would be a bit arduous 
to write with a bunch of special cases. Part of the problem is 
understanding which properties can be ignored, and which cannot and 
understanding how to write them. I wrote some code (not sure where it 
is) that copies a style. This is done one property at a time. I don't 
remember if I made it recursive or not. I probably did not, and, for 
this case, you would probably need to do that.


You would need to inspect the objects when possible and make comparison 
decisions based on that. It would also require error handling and 
special case code (probably). You would need to recognize when you had 
properties that you should not try to trace into if it is recursive in 
nature, which strikes me as the most difficult part.


On 08/17/2015 12:46 AM, Hi-Angel wrote:

Well, I think at some level that all comes to a simple objects.

Anyway, how do you compare properties? E.g. I was recently needed to
change with UNO the first page style of Writer document. In the end it
turned out to be the property «PageDescName» (a string) of the first
paragraph, and that's just impossible to infer deductively (why
paragraph? I could imagine it would be e.g. TextCursor, but a
paragraph could easily span for multiple pages).

So, could you compare properties for a Writer document before and
after the first page style was manually changed, and find that the
«PageDescName» just did changed?

2015-08-17 4:28 GMT+03:00 Andrew Douglas Pitonyak and...@pitonyak.org:

On 08/16/2015 03:53 PM, Hi-Angel wrote:

Often it is really hard to figure out for how to do something in UNO
unless someone already did it, and left a description on the Internet.
Even in the presence of MRI.

So I'm wondering: perhaps is there a way to save UNO state? So that
one could just save the state, change something they're interested in,
next again save the state. And the only thing that's left to do, is
just to peek at the difference between two files with a diff utility
to figure out the properties that were just changed.

Is your interest is in a specific object. For example, what properties
changed on the first table.

I can easily compare properties for an object, but, that only deals with
simple types such as strings and numbers. So, I can inspect an object and
display the values of all the simple types with the attribute names and
values. I can then save this in a text file, make a change to the object,
then check the values again.

First problem is that I am only looking at simple types. Sure, I could
change my inspection code to attempt to expand attributes that are other UNO
services, but, I would need to watch for referential loops (like if a table
refers to the owning document that would then refer to that table).


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


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

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

[Andrew Douglas Pitonyak]

Sorry for the late reply, but, does this help

https://forum.openoffice.org/en/forum/viewtopic.php?f=45t=20279


On 05/31/2015 07:28 AM, JTeagle wrote:

If this is not the best list for this question, please let me know of a more
appropriate one.

I'm using a few simple controls on a Calc sheet, and Libre Basic to
manipulate them. So far I have had success, pulling test from a text box,
pulling text from cells on the sheet, changing the list of strings shown in
a list box and handling button clicks.

Now I would like to improve the UI (from my point of view), such that once
the button click handler has done its job, the code sets the focus back to
the initial text box I was typing in and preselects all text, so that I can
immediately start typing the next name to work with.

I've Googled the heck out of it with various terms, looked through the SDK
docs and I'm using XRAY to see the properties and methods of the controls,
which is how I got this far... but none of them are helping now. I see no
property or method relating to selection or focus.

I *do* see a Start and End property, which are text ranges, but I don't
quite understand what they represent; I would have expected just one range
representing the first and last selected character positions - if they are
even related to selection.

I read somewhere that there's a SetFocus() method but that it is on the
*view* aspect of the edit box. No problem... but I can't find a way to
access the view portion either :(

There are lots of examples out there - many are even for forms - but none
seem to deal with focus or selection.

Can anyone point me towards some information on how to access such things? I
can't even get the selected text if I needed to.

Thanks.



--
View this message in context: 
http://nabble.documentfoundation.org/OEditModel-set-focus-pre-select-all-text-tp4150087.html
Sent from the Users mailing list archive at Nabble.com.



--
Andrew Pitonyak
My Macro Document: http://www.pitonyak.org/AndrewMacro.odt
Info:  http://www.pitonyak.org/oo.php


--
To unsubscribe e-mail to: users+unsubscr...@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] Can't change font color in LO 4.3.3 (Linux)

[Andrew Douglas Pitonyak]

No problem with 4.4.2.2 on Fedora, not back leveling to test.

Are you using the standard version or a distribution specific version?

On 05/14/2015 11:19 PM, minhsien0330 wrote:

Hi~
I found I can not change font color in LO 4.3.3 under Linux.
The procedure is:
(1) Open Writer or Calc.
(2) Type some words in Writer or Calc.
(3) Select the words and chage the color of words.
(4) Writer still not chage it.

Anybody has the same problem under Linux?
Thanks



--
Andrew Pitonyak
My Macro Document: http://www.pitonyak.org/AndrewMacro.odt
Info:  http://www.pitonyak.org/oo.php


--
To unsubscribe 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] [LibreOffice Writer] Table with alternat[]e row color

[Andrew Douglas Pitonyak]

On 04/19/2015 07:22 PM, Brian Barker wrote:

At 14:10 15/04/2015 +0200, Alain Ronly wrote:
I'm looking for a simple and automatic way how to tell to my tables 
in a writer document, to be formatted with alternat[]e rows color for 
example even rows will be blue in the background and odd rows will 
have a light blue as background color. I did not find any easy way to 
do it. Is there someone who has already solved this topic ?


Not me.

o Once you have set the background colour for one row, you can use the 
Format Paintbrush to paint the same colour on other rows. If you 
double-click the button, you can drag the paint bucket across 
alternate rows to achieve one colour and then repeat the process for 
the other colour.


o For large numbers of rows, you can copy an entire existing table and 
paste it immediately following - and you can repeat that process. 
You'll end up with multiple tables, but that may suffice, providing 
you delete the empty paragraph between them. If you need to, you can 
put the cursor into the second table and go to Table | Merge Tables 
(or right-click | Merge Tables) to merge the two tables into one.


o It is somewhat easier to set up such background colouring in a 
spreadsheet than in a Writer table. If you colour two rows you can 
easily copy them to two more. Then you can copy four rows to create 
eight in total. With this binary multiplication, you can very quickly 
achieve the desired size. If you then copy an appropriately-sized 
section of the spreadsheet and paste it into your text document using 
Paste Special... and HTML (HyperText Markup Language) you will get a 
table with the same background formatting. The table properties can be 
adjusted as necessary.


o The automatic way to colour spreadsheet rows alternately is to use 
Conditional Formatting and create a formula using the ROW() function 
to determine the oddness or evenness of the row number and control the 
background colouring using cell styles. But unfortunately - and as you 
might expect - the effect of such formatting is lost if you paste a 
copy into a text document as a table. So that's a dead duck.


o It's probably much easier to set up formatting such as this before 
you insert your data. If necessary, you should be able to copy any 
existing material and paste it into a new, formatted table.


I trust this helps.

Brian Barker


I wrote a macro some years back and I still use it today. You probably 
have no interest in the part that sets the borders...


Sub FormatTable(Optional oUseTable)
  Dim oTable
  Dim oCell
  Dim nRow As Long
  Dim nCol As Long

  If IsMissing(oUseTable) Then
oTable = ThisComponent.CurrentController.getViewCursor().TextTable
  Else
oTable = oUseTable
  End If
  If IsNull(oTable) OR IsEmpty(oTable) Then
Print FormatTable: No table specified
Exit Sub
  End If

  Dim v
  Dim x
  v = oTable.TableBorder
  x = v.TopLine
  x.OuterLineWidth = 2
  v.TopLine = x

  x = v.LeftLine
  x.OuterLineWidth = 2
  v.LeftLine = x

  x = v.RightLine
  x.OuterLineWidth = 2
  v.RightLine = x

  x = v.TopLine
  x.OuterLineWidth = 2
  v.TopLine = x

  x = v.VerticalLine
  x.OuterLineWidth = 2
  v.VerticalLine = x

  x = v.HorizontalLine
  x.OuterLineWidth = 0
  v.HorizontalLine = x

  x = v.BottomLine
  x.OuterLineWidth = 2
  v.BottomLine = x

  'v.Distance = 51

  oTable.TableBorder = v

  For nRow = 0 To oTable.getRows().getCount() - 1
For nCol = 0 To oTable.getColumns().getCount() - 1
  oCell = oTable.getCellByPosition(nCol, nRow)
  If nRow = 0 Then
oCell.BackColor = 128
SetParStyle(oCell.getText(), OOoTableHeader)
  Else
SetParStyle(oCell.getText(), OOoTableText)
If nRow MOD 2 = 1 Then
  oCell.BackColor = -1
Else
  REM color is (230, 230, 230)
  oCell.BackColor = 15132390
End If
  End If
Next
  Next
End Sub

--
Andrew Pitonyak
My Macro Document: http://www.pitonyak.org/AndrewMacro.odt
Info:  http://www.pitonyak.org/oo.php


--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? 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] Open File dialog is too large

[Andrew Douglas Pitonyak]

I am running Fedora Linux (64-bit).
I use LO 4.4.1.2 (official release).
I have two monitors
I use LO dialogs for open / close.

When I choose file open, the dialog is about 1.5 screens wide and it 
will NOT allow me to resize the dialog to make it narrower. Anyone else 
see this? I saw it when I upgraded from the previous version of LO.


I cleared my profile (I renamed ~/.config/libreoffice/4 to something 
else) and that fixed the issue.


Off hand, it looks like it is an issue in user/registrymodifications.xcu 
(if anyone cares).


Not sure what setting in that file caused the problem, but, if you ever 
see that problem, now you know what file is probably causing the issue.


--
Andrew Pitonyak
My Macro Document: http://www.pitonyak.org/AndrewMacro.odt
Info:  http://www.pitonyak.org/oo.php


--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://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] Search Calc Notes from GUI and API (macros)

[Andrew Douglas Pitonyak]

Sergey, I am copying you so that you know that I am more widely 
distributing your question.




Is it possible to search a Calc document and find comments?

I tried this recently using LO 4.4.1.2, and I cannot find text in a 
comment using the GUI.


To my knowledge this search has always worked in OpenOffice using the 
API. I was sent this Java code


= BEGIN INSERT

XSpreadsheet sheet = (XSpreadsheet) iaSheets.getByIndex(_curSheet).Value;
XSearchable xSch = (XSearchable) sheet;
XSearchDescriptor xSchDr = 
xSch.createSearchDescriptor();

xSchDr.setSearchString(searchStr);
xSchDr.setPropertyValue(SearchType, new 
Any((short)2)); // 2-  For cooment

xSchDr.setPropertyValue(SearchWords, new Any(false));
xSchDr.setPropertyValue(SearchByRow, new Any(true));
XCell xRangeCurrent = xSch.findFirst(xSchDr) as XCell;

   Search with parameter SearchType = 0 works, and with the parameter 
SearchType  = 2 is not working.
   Method findFirst always returns null. What am I doing wrong? Or what 
you can give advice to remedy this situation?


= END INSERT

I looked around and found this mentioned specifically as it relates to 
OpenOffice by Mr. Marcelly way back in 2006.


https://bz.apache.org/ooo/show_bug.cgi?id=67088

It is not clear to me that this ever worked in LO, but, if it is 
mentioned back in 2006, I assume that it probably did initially and that 
the functionality was removed (intentionally or accidentally) from LO.


Here is my corresponding Macro in Basic that demonstrates the problem.

Sub SearchSheet
  Dim oSheet'Sheet in which to replace
  Dim oSearch
  Dim x

  oSheet = ThisComponent.Sheets(0)
  oSearch = oSheet.createSearchDescriptor()
  oSearch.setSearchString(comment)
  oSearch.setPropertyValue(SearchType, 2)
  x = oSheet.findFirst(oSearch)
End Sub

--
Andrew Pitonyak
My Macro Document: http://www.pitonyak.org/AndrewMacro.odt
Info:  http://www.pitonyak.org/oo.php


--
To unsubscribe e-mail to: users+unsubscr...@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] Syntax highlighting

[Andrew Douglas Pitonyak]

On 03/04/2015 07:48 AM, Mohsen Pahlevanzadeh wrote:

body p { margin-bottom: 0cm; margin-top: 0pt; }Dear All,I need to export my 
articles as EPUB, My context of my odt, contais
 of code , so i need to syntax highlighting, How can i enable syntax
 highlighting in odt ?--Regards,Mohsen

This is not supported directly by LO, so you have a few options.

1. Do it manually

2. Copy from something that does and paste the code into your document

3. Use something like the code colorizer extension 
(http://extensions.libreoffice.org/extension-center/code-colorizer-formatter) 
and hope that it supports your language. What language are you using?


--
Andrew Pitonyak
My Macro Document: http://www.pitonyak.org/AndrewMacro.odt
Info:  http://www.pitonyak.org/oo.php


--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-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] When will LO have MS macro and function support?

[Andrew Douglas Pitonyak]

On 02/09/2015 01:44 PM, Thisis theone wrote:

Hello,

if we open up an example MS excel file, the macros and functions are not
100% working in LibreOffice.

When will LibreOffice have 100% MS macro and function support?

Or this is something that it's not worth it to do in LibreOffice?

IMHO if LibreOffice would have 100% MS compability for macros and functions
too, then... nothing would stand against LibreOffice to conquer the Office
world.

Thanks.

Although I agree that this would be great, it is not possible. Things 
are hampered in that LO supported things that MSO does not, and MSO 
supports things that LO does not. The moment you have an MSO macro that 
exploits a capability not supported by LO, things fail.; for example, 
the difference between a character highlight and a character background. 
How do you attempt to map this for 100% compatibility if it is not 
supported in LO. Sure, I am picking at nits here, but, I think that the 
most important take away in this regard is that even if we do a really 
good job, if we happen to miss that one thing that you need...



Even if we were only looking to say hit 80% compatible by emulating the 
objects and behavior in that way (and I suspect that it may not even be 
possible given how some of the VBA macros function), that still leaves 
20% of the stuff that might fail. And then, if your macro uses .NET 
libraries and things not available on non Windows platforms, those will 
not work unless the entire .NET stuff is supported.


Off hand, I would say that this is a low priority for the majority of 
the users (in other words, there exist things that the majority would 
put as a higher priority such as improved OOXML support).


Understand that this is a really hard task, which would require 
significant investment in time and money. The end result would still not 
provide 100% compatibility.


So, I don't really expect it.



--
Andrew Pitonyak
My Macro Document: http://www.pitonyak.org/AndrewMacro.odt
Info:  http://www.pitonyak.org/oo.php


--
To unsubscribe e-mail to: users+unsubscr...@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: LinuxQuestions.org's Office Suite of the Year: LibreOffice!

[Andrew Douglas Pitonyak]

On 02/06/2015 04:59 PM, jonathon wrote:

-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

On 06/02/15 09:09, Paul wrote:


Surely running MSO under Wine on Linux is a valid choice? Not one I
would choose, for sure, but a choice that should be on the poll
none the less?

The idea is to highlight _Linux_ software.

By allowing _use x under WINE_ as an option_, the poll then becomes
a contest about the non-native software. That would also mandate
including programs whose developers have promised will never be
released as native *Nix software.

jonathon



I have read a bunch of these posts and although at least one person 
thinks that MS office products MUST be on the list for it to be valid, 
has anyone really asked the question, can Wine run the product in question?


Microsoft Word 2013 is known to NOT work

There are only 8 votes requesting that it be made to work.

https://www.codeweavers.com/compatibility/browse/name/?app_id=10959

When Microsoft creates their products, they generally push the envelope 
and use the newest latest libraries, which Crossover is less likely to 
have ported. So, if MSO was included in the list as things that people 
run on Linux, then they would need to include numerous versions to try 
to get one that people are using.


There is not even an entry for MS Excel 2013, so no one has even cared 
enough to create one.


If I look at the MS Office 97 entry, there are zero votes to make it 
work, and only 149 CrossTie Downloads (downloads of the automated 
Cross-Over office installation stuff).


Now, to be more positive on MSO having any bearing, the generic MSO 2013 
entry (which is listed as known to not work) has 158 votes asking them 
to make it work.


https://www.codeweavers.com/compatibility/browse/name/?app_id=10518;details=1

Here are their top 25 requested to make work applications: The first 
number is the rank, the second is the number of votes.


1. 158 · Microsoft Office 2013
   https://www.codeweavers.com/compatibility/browse/name?app_id=10518
2. 49 · Star Wars: The Old Republic
   https://www.codeweavers.com/compatibility/browse/name?app_id=7626
3. 38 · The Elder Scrolls V: Skyrim
   https://www.codeweavers.com/compatibility/browse/name?app_id=9766
4. 36 · Origin
   https://www.codeweavers.com/compatibility/browse/name?app_id=9509
5. 36 · VMware vSphere Client
   https://www.codeweavers.com/compatibility/browse/name?app_id=8014
6. 33 · Diablo III
   https://www.codeweavers.com/compatibility/browse/name?app_id=6277
7. 30 · Guild Wars 2
   https://www.codeweavers.com/compatibility/browse/name?app_id=7951
8. 27 · World of Warcraft
   https://www.codeweavers.com/compatibility/browse/name?app_id=7714
9. 25 · The Elder Scrolls Online
   https://www.codeweavers.com/compatibility/browse/name?app_id=11974
10. 24 · Quicken 2014
   https://www.codeweavers.com/compatibility/browse/name?app_id=12227
11. 24 · WildStar
   https://www.codeweavers.com/compatibility/browse/name?app_id=9742
12. 23 · Microsoft Outlook 2013
   https://www.codeweavers.com/compatibility/browse/name?app_id=10958
13. 21 · League of Legends
   https://www.codeweavers.com/compatibility/browse/name?app_id=6282
14. 20 · Final Fantasy XIV
   https://www.codeweavers.com/compatibility/browse/name?app_id=7892
15. 20 · Steam
   https://www.codeweavers.com/compatibility/browse/name?app_id=206
16. 18 · Microsoft Visio Professional 2013
   https://www.codeweavers.com/compatibility/browse/name?app_id=11726
17. 18 · Civilization V
   https://www.codeweavers.com/compatibility/browse/name?app_id=7234
18. 17 · Microsoft Outlook 2010
   https://www.codeweavers.com/compatibility/browse/name?app_id=6135
19. 16 · Microsoft Visio 2010
   https://www.codeweavers.com/compatibility/browse/name?app_id=7688
20. 15 · Microsoft Office 365
   https://www.codeweavers.com/compatibility/browse/name?app_id=11826
21. 14 · World of Tanks
   https://www.codeweavers.com/compatibility/browse/name?app_id=7998
22. 13 · Elite Dangerous
   https://www.codeweavers.com/compatibility/browse/name?app_id=12975
23. 13 · Internet Explorer 10
   https://www.codeweavers.com/compatibility/browse/name?app_id=11348
24. 12 · Adobe Photoshop Lightroom 5
   https://www.codeweavers.com/compatibility/browse/name?app_id=11808
25. 12 · StarCraft II: Heart of the Swarm
   https://www.codeweavers.com/compatibility/browse/name?app_id=11488


I think that it does not matter that it is not listed as a possibility 
as one of the top office products (or word processors) used on Linux.


It looks like Word 2010 has 1507 crosstie downloads, so certainly some 
people are using older copies of Word.


https://www.codeweavers.com/compatibility/browse/name/?app_id=6132;details=1

--
Andrew Pitonyak
My Macro Document: http://www.pitonyak.org/AndrewMacro.odt
Info:  http://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

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

[Andrew Douglas Pitonyak]

On 02/05/2015 07:07 AM, Tom Davies wrote:

Hi :)
I think you can usually just install over the top to wipe the previous version.

However on an extremely rare occasion that might not work in which
case you might need to remove/uninstall everything and then reinstall
the newer version.  however 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

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

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] syntax hilighter for writer

[Andrew Douglas Pitonyak]

what do you want to syntax highlight?

On 01/28/2015 01:39 AM, m_pahlevanzadeh wrote:

Dear All,

I have been searhed for syntax highliter, But i found a set of under
milestone 4.x ,
Do you know compatiable with milestone 4.x?

--Regrads
Mohsen



--
View this message in context: 
http://nabble.documentfoundation.org/syntax-hilighter-for-writer-tp4137845.html
Sent from the Users mailing list archive at Nabble.com.



--
Andrew Pitonyak
My Macro Document: http://www.pitonyak.org/AndrewMacro.odt
Info:  http://www.pitonyak.org/oo.php


--
To unsubscribe e-mail to: users+unsubscr...@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] Help with writer files

[Andrew Miller]

Everything was working great until two days ago, I can no longer read any
of my saved files in doc format.
It opens into garbled text like this:

 Íòmë
#3jÄe_M?7kÒcŨWQyS#Cl¹jíŸ#ó�DÚ`WŽ{Œ#ñ·ÍÁ%×v#JÙ»HdÈ#\”†‡#|#îƒK«#�Mˆkûò¿¦Òi-##’´#ðáo¹#iû8ðª˜s!ô(Vò$¨eJD€PC9¥µWIv‰3…GÚÈ#ß

ys—…+1�×#Ý###Ùqâæ#u#Jô:4ŽWKÈ×_B›Û-0mç
ˆï,I^úyõ,ˆZ6´a�Q28š#–#ô#—¾X#©¸î;Ÿ ö
'9\¸+:�±â8³#š#Îò;èçV,‰Â°T#ÁDÿxÆÁÉ–�áÙ6”ƒ


Documents that were created in the past week open up with no issues,
just my previously saved documents converted from word are the issue.

Any help is appreciated

-- 
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] Shouldn't it be more secure to by default disable macro support in LibreOffice?

[Andrew Douglas Pitonyak]

Although yes, not allowing macros of any sort to run would be more 
secure, the default installation is to only allow macros from trusted 
sources and unsigned macros are disabled. So, macros signed by a trusted 
source are allowed and nothing else. This includes macros included with 
LO that may be part of things such as certain Wizards; at least there 
used to be wizards for things like document migration included.


I think that disabling all macros would be confusing if you attempted to 
use a Wizard and it failed to run. I could be mistaken, I did not bother 
to test (lazy I guess).


I don't consider LO usable until I have lowered the setting one level, 
which requires that I say yes / no for every document that I load that 
runs macros. I never set it to just run any macro.


--
Andrew Pitonyak
My Macro Document: http://www.pitonyak.org/AndrewMacro.odt
Info:  http://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

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

[Andrew Douglas Pitonyak]

Does the problem go away if you completely exist LO and then rename your 
LO user profile?



On 01/04/2015 01:03 AM, Dr. Jim Ishler wrote:

When I try to start LibrOffice I get an error that the program cannot be 
started.

It says the service manager is not available.

Premature end of 
file:///C:/Users/jishler/AppData/Roaming/LibreOffice/4/user/uno_packages/cache/registry/com.sun.star.comp.deployment.component.PackageRegistryBackend/common.rdb

I have tried reinstalling LibreOffice, repairing it, and unistalling and then 
reinstalling, but I always get the same error.  How can I fix this?

I am running Windows 7


--
Andrew Pitonyak
My Macro Document: http://www.pitonyak.org/AndrewMacro.odt
Info:  http://www.pitonyak.org/oo.php


--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
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] BASIC StrComp and tricky Unicode for example) SOLVED

[Andrew Douglas Pitonyak]

On 01/03/2015 01:00 PM, libreoffice-ml.mbou...@spamgourmet.com wrote:

Andrew Douglas Pitonyak wrote:

Yep, it pulls the value from the application language settings, so that
if I set that to Turkish for the application, I can test in Turkish.


   Print StrComp(ı, I, 0)  ' compare Turkish dotless i with upper
case i
   Print StrComp(i, I, 0)  ' compare lower case i to upper case i

returns 0 and 1. If I change back to English US, this evaluates as 
-1, 0.


I think in Turkish I is used as the upper-case dotless ı, and 
there's a separate character for the upper-case dotted i (which 
presumably should compare equal to the lower-case dotted i in that 
locale). Perhaps U+0130 İ.


Mark.


You are correct and it seems that LO handles these just fine. I am 
told that it will not handle all cases well (seems that there are a few 
cases in German that may not be correctly handed; for example, comparing 
characters with accents to characters without). I expect some 
clarification on this in the next week so that I can add more detail to 
a new section where I am attempting to add clarity so that others do not 
need to read the code and rely on trial and error to know what to 
expect. Oh, and perhaps file a bug report if the behavior is just wrong 
or inconsistent.


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

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

[Andrew Douglas Pitonyak]

Zeki, I think that I managed to sort this out!

I resorted to reading the source code... The short answer is that the 
application's language setting determines how the compare is done for a 
case-insensitive compare!


Also, based on what I read in the source code, I figured out how the 
locale is determined and used. I created a new section in my 
documentation that shows a few examples and indicates how to change the 
settings for testing. The actual snippet of code that does this is as 
follows:


 LanguageType eLangType = 
Application::GetSettings().GetLanguageTag().getLanguageType();

 pTransliterationWrapper-loadModuleIfNeeded( eLangType );
 nRetValue = pTransliterationWrapper-compareString( rStr1, rStr2 );

Yep, it pulls the value from the application language settings, so that 
if I set that to Turkish for the application, I can test in Turkish.



  Print StrComp(ı, I, 0)  ' compare Turkish dotless i with upper case i
  Print StrComp(i, I, 0)  ' compare lower case i to upper case i

returns 0 and 1. If I change back to English US, this evaluates as -1, 0.

I will be pushing a change to my web site shortly, complete with updated 
code examples (in section 7.3 of OOME) and an explanation.


Thanks to all for the pointers and thanks to Jim Caughran for the 
exchange that then had me thinking about this.


--
Andrew Pitonyak
My Macro Document: http://www.pitonyak.org/AndrewMacro.odt
Info:  http://www.pitonyak.org/oo.php


--
To unsubscribe e-mail to: users+unsubscr...@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] BASIC StrComp and tricky Unicode (Turkish, for example)

[Andrew Douglas Pitonyak]

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


Sub StrCompTest
  Print StrComp(ı, I, 0)  ' compare Turkish dotless i with upper case i
  Print StrComp(i, I, 0)  ' compare lower case i to upper case i
End Sub

In my locale, this returns -1 and 0. With a Turkish locale, I expect 
that the first compare will return a 0, but I am unsure how to test 
this. Any insights into this?


--
Andrew Pitonyak
My Macro Document: http://www.pitonyak.org/AndrewMacro.odt
Info:  http://www.pitonyak.org/oo.php


--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-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] BASIC StrComp and tricky Unicode (Turkish, for example)

[Andrew Douglas Pitonyak]

On 01/01/2015 02:16 PM, Luuk wrote:

On 1-1-2015 18:51, Andrew Douglas Pitonyak wrote:


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

Sub StrCompTest
   Print StrComp(ı, I, 0)  ' compare Turkish dotless i with upper
case i
   Print StrComp(i, I, 0)  ' compare lower case i to upper case i
End Sub

In my locale, this returns -1 and 0. With a Turkish locale, I expect
that the first compare will return a 0, but I am unsure how to test
this. Any insights into this?



I'm not an expert in this, but this page:
http://en.wikipedia.org/wiki/Dotted_and_dotless_I

Shows there is a small, and a capital version of the 'Turkish dotless i'

StrComp(i,I,0) only returns 0 for the small, and the capital i,
and not for the i's with diacritics   (í,ì,ï, )

I think the 'Turkish dotless i' should be treated as an i with a 
diacritic.




The code contains the Turkish dotless i, but it fails (as it should) on 
my computer. I am hesitant (perhaps lazy) to mess with my computer's 
locale since I don't have a good handle on the implications of changing 
it or whether or not I just need to change it in an LO configuration 
somewhere. I also don't want to try installing a Turkish version of 
things since I would not be able to read anything. Hopefully someone who 
is sufficiently familiar with these issues (say because they are turkish 
or are simply aware of other examples that will fail in my locale and 
work in theirs) can speak up. I do appreciate the wiki link, and it does 
confirm that this should work if my locale were Turkish and if LO deals 
with it correctly.


Andrew



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

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] Re: Macro to open form + pass on value from current form

[Andrew Douglas Pitonyak]

And, when you can solve a problem without a macro, that is generally the 
better path :-)


On 12/17/2014 01:02 PM, Andreas Säger wrote:

Am 17.12.2014 um 03:05 schrieb Joel Madero:

Hi All,

I have a form that has bookID as a unique key. I want to have a button
that is to open a second form and do the following:

(1) search for the bookID in another table (Series);
(2) If bookID does not exist in Series, create a new record that has the
bookID and open another form and passes the bookID to that form so I can
enter the appropriate info.

Guidance appreciated.


Best,
Joel


This can be done without macro using stand-alone forms, hyperlink button
and a criteria table.

1) [Example #1] Filter/Search with Forms (leveraging SubForms)

https://forum.openoffice.org/en/forum/viewtopic.php?f=100t=42845

2) [Tutorial] Standalone Forms / Switchboard:

https://forum.openoffice.org/en/forum/viewtopic.php?f=83t=40493






--
Andrew Pitonyak
My Macro Document: http://www.pitonyak.org/AndrewMacro.odt
Info:  http://www.pitonyak.org/oo.php


--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
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] Adequate API

[Andrew Douglas Pitonyak]

On 12/13/2014 06:22 PM, RAM B wrote:

Why there is no adequate API for so long time to program office suite?

OO:=CreateOleObject('com.sun.star.ServiceManager');
ddd:=oo.createinstance('com.sun.star.frame.Desktop');


varr := VarArrayCreate([0, 1], varvariant);
doc:=ddd.LoadComponentFromURL( 'private:factory/swriter', '_blank', 0,
VarArrayCreate([0, -1], varVariant));
ot:=doc.gettext;
cp:=ot.createtextcursor;
ot.insertstring(cp,'h1kjhk/h1jh',false);

like

doc:=createDocument(swriter,OOO_Blank);

cur:=createCursor();

insertString(cur,hello!);

why?

RAM B.



The original intent of the API was to directly control the internals 
using the existing objects built-in to LO. It was not intended to be 
used as you suggest. The existing API has certain advantages in many 
ways, sadly, accessibility is not one of them. More specifically, it is 
confusing at best until you have spent a lot of time looking at it.


Off hand, there is no specific reason that wrapper methods could not be 
written to do this sort of thing, but that requires a volunteer to 
choose to do it and have community buy in (or I suppose that some of 
these things could be done as an add-on or extension). So, then it just 
needs someone who has sufficient need, desire, or money to choose to do it.


Not sure that is what you meant to ask or not I do most of my work 
in basic, so my tendency would be write a Basic macro to do the work. 
This would not make it available (I think) from your example code, only 
from Basic. I think it would need to be full UNO implementation. If you 
see a real need and are able to build support for this, you could be the 
person to make this happen. Off hand, I would say that creating the new 
language or extension would be the most difficult part. The example as 
you present it would flat out not work since the calls would probably 
have to somehow be related to a document or thing. In other words, you 
can't just call insertString without context (I think anyway), so you 
would need some kind of object from which to call insertString. It turns 
out that your cursor object supports this call directly. Now i think 
that I am rambling.


Oh, and I see a real need for a simplified API but I do not have the 
time to lead such an effort; sadly.


--
Andrew Pitonyak
My Macro Document: http://www.pitonyak.org/AndrewMacro.odt
Info:  http://www.pitonyak.org/oo.php


--
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: macro pasting text instead of formula

[Andrew Douglas Pitonyak]

On 12/10/2014 12:23 PM, Joel Madero wrote:

Hi All,


Well, you set the string of a cell.
Set the formula instead.

So I just started from scratch because I had a ton of if statements
before, decided to go to switch to make it faster but I'm hitting the
same type of problem.

Document:
https://drive.google.com/file/d/0B5S-XtOUGGH5UmpBdnIzUUM3OFE/view?usp=sharing

Click Create Ledger and you'll see the macro begin.

Problem: Look at sheet Ledger under header Date (B7:B10). At first I
thought those were right but they are not. Convert those to date, you'll
see that all of them are 12/10/14.

I literally have no clue where those are coming from. They should be:
B7: 06/26/2009
B8: 06/26/2009
B9: 06/27/2009
B10: 06/28/2009

(all taken from RawData sheet).

If you look at the macro (Sub fillData) you'll see that the pasteValue
gets Date(year,month,date), furthermore you can see that year, month,
date all get the correct values (uncomment the print values in the
switch).

Terribly confused at this point, suggestions welcome.


Best,
Joel



I can see many things that you have done wrong. Here are a few comments

Your first problem... replace

pasteSheet.getCellByPosition(1,k).value = Date(year,month,day)

with

 pasteSheet.getCellByPosition(1,k).value = DateSerial(year,month,day)

DateSerial returns a date built from the component parts, Date does not.

Also, you probably want to set the format to use a Date. I won't bother 
with a complicated specified Numeric format for this, but will provide 
this simple example:


Dim oFormats
oFormats = ThisComponent.NumberFormats
Dim aLocale As New com.sun.star.lang.Locale
pasteSheet.getCellByPosition(1,k).value = DateSerial(year,month,day)
pasteSheet.getCellByPosition(1,k).NumberFormat = 
oFormats.getStandardFormat(com.sun.star.util.NumberFormat.DATE, aLocale)



Now for a few other comments.

You have this big select case for some things. Consider this:

Day month and year area already defined as type integer. This means that 
those big case statements can be removed as follows:


   month = mid(currentCellValue, 5,2)
   year = mid(currentCellValue, 10,2)
   If (year  10) Then
 year = year + 2010
   ElseIf (year  99) Then
 year = year + 2000
   End If
   day = mid(currentCellValue, 2,2)

   Dim oFormats
   oFormats = ThisComponent.NumberFormats
   Dim aLocale As New com.sun.star.lang.Locale
   pasteSheet.getCellByPosition(1,k).value = 
DateSerial(year,month,day)
   pasteSheet.getCellByPosition(1,k).NumberFormat = 
oFormats.getStandardFormat(com.sun.star.util.NumberFormat.DATE, aLocale)



Hope this helps.

AndrewMacro.odt is a good place to find specific focused examples.
OOME_3_0.odt contains numerous examples, but is more focused towards 
learning.


--
Andrew Pitonyak
My Macro Document: http://www.pitonyak.org/AndrewMacro.odt
Info:  http://www.pitonyak.org/oo.php


--
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: macro pasting text instead of formula

[Andrew Douglas Pitonyak]

On 12/10/2014 07:13 PM, Joel Madero wrote:

Hey Andrew,

First - thanks for giving explicit examples of where I went wrong :)
I'll study your examples and learn for the future.


Sometimes you need to specifically spelled out, I get that and your 
welcome.



Second - as for the switch, I was actually trying to conceptualize
abstracting more and doing it per digit but I need to think about it a
lot more. Thanks for the pointer for the simple if. If I can abstract
then I can have one switch that takes care of day, month, and year.


When possible, at least in other programming languages, I would simply 
provide the string along with a format specifier and perform the entire 
conversion in one shot. I don't know off hand if you can do a conversion 
by removing the D. Certainly this might fail with two digit years. I 
managed to damage a bunch of data by allowing LO decide how to convert a 
two digit year.



Lastly, thanks for the pointer to the other examples. I certainly learn
by doing (I even have some patches submitted to the code...completely
learned by doing/guess and check/looking at examples).


Simple examples are a good way to start. Your entire set of macros is 
very ambitious for a person who does not do this professionally.




Warmest Regards,
Joel

On 12/10/2014 12:23 PM, Joel Madero wrote:

Hi All,


Well, you set the string of a cell.
Set the formula instead.

So I just started from scratch because I had a ton of if statements
before, decided to go to switch to make it faster but I'm hitting the
same type of problem.

Document:
https://drive.google.com/file/d/0B5S-XtOUGGH5UmpBdnIzUUM3OFE/view?usp=sharing


Click Create Ledger and you'll see the macro begin.

Problem: Look at sheet Ledger under header Date (B7:B10). At first I
thought those were right but they are not. Convert those to date, you'll
see that all of them are 12/10/14.

I literally have no clue where those are coming from. They should be:
B7: 06/26/2009
B8: 06/26/2009
B9: 06/27/2009
B10: 06/28/2009

(all taken from RawData sheet).

If you look at the macro (Sub fillData) you'll see that the pasteValue
gets Date(year,month,date), furthermore you can see that year, month,
date all get the correct values (uncomment the print values in the
switch).

Terribly confused at this point, suggestions welcome.


Best,
Joel


I can see many things that you have done wrong. Here are a few
comments

Your first problem... replace

pasteSheet.getCellByPosition(1,k).value = Date(year,month,day)

with

  pasteSheet.getCellByPosition(1,k).value = DateSerial(year,month,day)

DateSerial returns a date built from the component parts, Date does not.

Also, you probably want to set the format to use a Date. I won't
bother with a complicated specified Numeric format for this, but will
provide this simple example:

Dim oFormats
oFormats = ThisComponent.NumberFormats
Dim aLocale As New com.sun.star.lang.Locale
pasteSheet.getCellByPosition(1,k).value = DateSerial(year,month,day)
pasteSheet.getCellByPosition(1,k).NumberFormat =
oFormats.getStandardFormat(com.sun.star.util.NumberFormat.DATE, aLocale)


Now for a few other comments.

You have this big select case for some things. Consider this:

Day month and year area already defined as type integer. This means
that those big case statements can be removed as follows:

month = mid(currentCellValue, 5,2)
year = mid(currentCellValue, 10,2)
If (year  10) Then
  year = year + 2010
ElseIf (year  99) Then
  year = year + 2000
End If
day = mid(currentCellValue, 2,2)

Dim oFormats
oFormats = ThisComponent.NumberFormats
Dim aLocale As New com.sun.star.lang.Locale
pasteSheet.getCellByPosition(1,k).value =
DateSerial(year,month,day)
pasteSheet.getCellByPosition(1,k).NumberFormat =
oFormats.getStandardFormat(com.sun.star.util.NumberFormat.DATE, aLocale)


Hope this helps.

AndrewMacro.odt is a good place to find specific focused examples.
OOME_3_0.odt contains numerous examples, but is more focused towards
learning.



--
Andrew Pitonyak
My Macro Document: http://www.pitonyak.org/AndrewMacro.odt
Info:  http://www.pitonyak.org/oo.php


--
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: Sphinx - voice translation - Linux

[Andrew Douglas Pitonyak]

I have not looked in a long time... I have trouble with my wrists 
sometime, so, it would be nice if I had something that would integrate...


Been  a few years since I looked so perhaps it is time for another look.

On 12/03/2014 04:48 AM, Tom Davies wrote:

Hi :)
We have the same thread going on the Accessibility Mailing List now too.
It might be worth looking at it through the Nabble or GMane interfaces.

Over there Eric suggested NaturallySpeaking 13 but had several good
detailed points about issues relating to the whole area of speech and voice
recognition.  Well worth a read if this area interests you but it's about
as long as one of my longer mails.  Interesting though! :)


Wrt Bible, Koran or Torah study programs Linux does have quite a large
range of different packages to help.  For the Bible there are different
programs to cover different versions (such as the King James(?) vs whatever
and whatever else).  Of course each person needs something slightly
different so i can well imagine Andrew's typical hefty research into a
topic of interest didn't find anything to suit him but something there
might suit you, if you are interested.

Regards from
Tom :)




On 3 December 2014 at 04:55, Walther Koehler walther.koeh...@posteo.de
wrote:


High Eric,

thank you for that information. I was trying to get a speech recognition
system running for some time.
I have been using the IBM-line of speech recognition ViaVoice/Nuance under
Win98 with some success. Now, I planned to use it in VirtualBox.

-Do you have experience with ViaVoice, are there reasons to prefer
NaturalSpeaking?

-Why did you choose KVM over VirtualBox?

Have a good day

Walther

Am Dienstag, 2. Dezember 2014 schrieb Eric:

On 12/2/2014 3:08 PM, charles meyer wrote:

Hi Tom,

I spoke with someone who uses Linux and they shared that Sphinx -
voice translation is new so many may not have tried it yet.

Sorry for jumping the gun, so to speak.

It's speech recognition, not voice translation. If I throw you off the
top of the building, I'm going to hear your voice. If I push you near
the edge of the roof, I would hear your speech..

Sphinx has been around for at least 15 years in different forms. It has
been, and probably always will be a system designed for IVR (interactive
voice response, speak or press one to get ignored by a customer service
representative). It is not and never will be a system for
general-purpose speech recognition.

The only useful speech recognition packages are NaturallySpeaking with a
not very close runner-up of Windows speech recognition. Google speech
recognition would be in the running if it wasn't bound to a very limited
number of apps with no user accessible grammars. I'm currently
experimenting with running Windows in a KVM virtual machine, running
NaturallySpeaking there and find a way to see the output of
NaturallySpeaking back to the Linux host OS.  If I can get the audio
stream clean enough, it looks like a promising technique for adding
speech recognition to Linux

Now all I need some help to figure out what I don't know about injecting
keystrokes into linux and may be help with fixing up KVM so it passes
audio cleanly under most conditions.



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



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

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

[Andrew Douglas Pitonyak]

Can you be more specific? Numerous packages named Sphinx, could not 
begin to guess which. Perhaps I am simply not well informed.


My best guess is this:

https://pypi.python.org/pypi/sphinxcontrib-libreoffice


On 12/01/2014 11:19 PM, charles meyer wrote:

I hope it's OK to post about Linux here?

If not, my apologies.

I was curious if any Linux users have used the Sphinx application and
how well it's worked?

Thanks so much.

Charles.



--
Andrew Pitonyak
My Macro Document: http://www.pitonyak.org/AndrewMacro.odt
Info:  http://www.pitonyak.org/oo.php


--
To unsubscribe e-mail to: users+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: How does 4.4 compress PDFs so well? Is there a quality problem?

[Andrew Douglas Pitonyak]

Note, I am not looking at the code, I am just guessing in my answers, 
but, if you are testing, perhaps you can test these things:



On 11/21/2014 05:43 AM, Paddy Landau wrote:

As for a pattern, I've not been able to find one. As mentioned before, there
seems to be no pattern as to whether the images are linked or embedded,


I expected that Linked / embedded is related to how the documents were 
added when the ODT document is created. That said, i was not aware that 
you could simply link an image in a PDF document, so I have almost 
nothing to add related to this.



large or small, resized or not.


This may be related to the perceived DPI of the original image as 
compared to the DPI of the created PDF. On export you can choose 
Lossless compressing, JPEG compression, and Reduce image resolution. 
Obviously this will not be true if you do not set reduce image 
resolution. When I look at those three combinations, I expect that no 
combination allows for images to never be modified.




It seems random. I'm sure it's not random, but still, I find it crazy to
modify any of the images especially as they are always made larger (why take
a lossless PNG image and make it into a bigger PNG?).

Paddy



--
View this message in context: 
http://nabble.documentfoundation.org/How-does-4-4-compress-PDFs-so-well-Is-there-a-quality-problem-tp4129492p4129794.html
Sent from the Users mailing list archive at Nabble.com.



--
Andrew Pitonyak
My Macro Document: http://www.pitonyak.org/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