[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

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

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: 

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

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

Re: [libreoffice-users] Re: macro to add annotation to selected text range

[Andrew Douglas Pitonyak]

Matt,

It occurs to me that I might come off a bit  arrogant in my response, 
but, my intention is to point you at a couple of places that contain the 
answer to one of your questions. So, please grant me some grace while 
reading and assume that I have the best of intentions. I have been 
having some stressful days lately and I have very little time.


On 11/19/2014 12:59 PM, Matt Price wrote:

Jim,

That was it!  Or, almost.  I changed the line to:

  oText.insertTextContent(oVC, oAnno, True)
And the annotation now gets attached to the whole range.

I wish I knew how to find the documentation for these functions!  I don't
know what the various parameters actually d -- what is the final Boolean
doing there?  How do you know?


The answer is well hidden, but I know where to look :-)

If you download this document (which has a bunch of macros so you will 
be warned that it has macros, you may tell it no, do not enable macros 
and it will still work fine, you just won't be able to click on all the 
buttons that run the macros from the document).


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

Table 123 says the following:

insertTextContent(XTextRange, XTextContent, boolean)

Insert text content such as a text table, text frame, or text field. In 
general, the text content should be created by the text object. If the 
Boolean value is True, the text in the text range is overwritten; 
otherwise, the text content is inserted after the text range.


How did I now to put that into the document? I probably looked here:


AOO documentation here:
http://www.openoffice.org/api/docs/common/ref/com/sun/star/text/XText.html#insertTextContent

or here:

LO documentation here:
http://api.libreoffice.org/docs/idl/ref/interfacecom_1_1sun_1_1star_1_1text_1_1XText.html

On the web site, it reads as follows:

void insertTextContent ( [in] com::sun::star::text::XTextRange  
xRange,

[in] com::sun::star::text::XTextContent  xContent,
[in] boolean  bAbsorb
)

inserts a content, such as a text table, text frame or text field.

Which contents are accepted is implementation-specific. Some 
implementations may only accept contents which were created by the 
factory that supplied the same text or the document which contains the text.


Parameters
xRangespecifies the position of insertion.
xContentthe text content to be inserted.
bAbsorbspecifies whether the text spanned by xRange will be 
replaced. If TRUE then the content of xRange will be replaced by 
xContent, otherwise xContent will be inserted at the end of xRange.


No, if you are still reading, let me say that it was easy for me to find 
because I have spent literally thousands of hours working on this stuff 
and I knew exactly where to look and what to look for (especially since 
you had a snippet). I do not expect that you would have found it as fast 
as I and, it is also not clear that without more exposure that it would 
have been clear that it was what you needed to see.


I found the LO link by searching for

libreoffice API insertTextContent

on Google. While playing with macros, it is common for me inspect the 
objects in question (I wrote my own object inspector, many people use 
XRay). I then identify method names that look promising and then use a 
Google search to figure out how to use that method.




But in any case, many thanks for solving htis problem, it's actually pretty
awesome to be able to do this with a single keystroke!


Glad you figured it out.



m



On Wed, Nov 19, 2014 at 12:38 PM, Jim Byrnes jf_byr...@comcast.net wrote:


On 11/19/2014 10:55 AM, Matt Price wrote:


Thanks Tom,

I've just spent some time looking htrough Andrew Pitonyak's macro guide.
It helps a little but there doesn't seem to be any direct documentation of
hte functions.  What I'm looking at is the second line reproduced below:

  oVC = ThisComponent.CurrentController.ViewCursor
  oText.insertTextContent(oVC.Start, oAnno, False)


Matt,
I don't use Writer much and honestly I'm not sure what you expect to see.
Try this.  In the above two lines change Start to End and False to True and
put those two lines right under your rem I don't know what to put in here
line. Then select some text and run the macro.

Regards,  Jim


  I think oVC.Start needs to be replaced with something else, but I can't

figure out what.  All of Andrew's examples with insertTextContent insert
the content at a single location, not at a text range, so maybe I need a
different function. If someone knows another method I'd appreciate the
advice.

Thanks,
Matt

On Wed, Nov 19, 2014 at 11:15 AM, Tom Davies tomc...@gmail.com wrote:

  Hi :)

The best documentation is at;
https://wiki.documentfoundation.org/Documentation/Publications
and the most recent full books are also on the official LibreOffice
website.

For macros i think the best book by far is Andrew Pitonyak's guide on

https://wiki.documentfoundation.org/Documentation/Other_

Re: [libreoffice-users] Base Help Anyone

[Andrew Douglas Pitonyak]

On 11/18/2014 07:32 AM, Alan B wrote:

On Tue, Nov 18, 2014 at 6:35 AM, Alan Pedder alanped...@hotmail.co.uk
wrote:


I
  have been using Base to provide a database for my paintings via a
simple form.  I recorded 200 records and then added the facility to
include a photograph .jpg file and this is when the gremlins started to
appear.


It constantly issues error messages when adding data
and causes me to endlessly loose work as it has failed to write to the
table from a form for no obvious reason I can see, sometimes I can add a
  new data or several set/records on the form OK and then it will fail
with the error message as follows where the Table1 is my Table


Hello Alan. I haven't used Base to store binaries however I have monitored
this list for a while and used Base for a few small projects.

I expect the two primary recommendations you will get are...
1. Don't store data in Base, use a separate database back end because the
embedded HSQL is not very stable. To that end I've recently found the
native MySQL connector works well for me (never had reliable connections
with the Java or ODBC connectors).
2. Don't store binaries in Base, store a path/pointer to the binary. Keeps
the table size down, minimizes loss if the db becomes corrupted.
To re-enforce what was just said, some of which is obviously just an 
opinion


LO contains a database component which stores all of the data in a 
single file which is then pulled into memory when in use. This included 
database is HSQLDB


http://en.wikipedia.org/wiki/HSQLDB

If you create a standard Base document using what came with LO, then 
you are using HSQLDB as the back end to manage your data. You can use 
other database systems on the back-end. i am not an expert and cannot 
enumerate them, but, I expect that mariadb and postgre are both examples 
of other back-end database implementations that people use. The problem 
with that is that (I think) that you must have these programs running as 
a server to access them. The advantage is that they are more robust and 
less prone to errors; especially when you store a large amount of data.


I ran into significant problems when I stored a large number of images 
in a Base document backed by HSQLDB. I expect that the same problem 
would not have occurred if I had used a different DB to actually store 
the images (such as MySQL, MariaDB, or PostGRE). One method that may 
work is to not store the large binaries in the database, but, instead, 
store a path to the individual image in the DB and then store image 
itself on disk. I have used this method in production systems when 
storing very large binaries (by large I mean that each binary may be a 
couple of GB).


I stopped using Base years ago because of those Gremlins. I believe that 
many of the gremlins that plagued me have been fixed, but I would be 
hesitant to use it to store much binary data using HSQLDB as the back-end.


Just my opinion and perhaps others on the list can offer a more recent 
experience.


--
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] LO Writer page numbering resets itself halfway through document

[Andrew Douglas Pitonyak]

On a whim, can you run the macro below. As a paranoid sort, I would say...

1. Save your document.
2. Run this macro.
3. If I missed something and it modifies the document, do not save the 
changes (it should not change the document).


Sub FindPageBreaks
  REM Author: Andrew Pitonyak
  Dim iCnt As Long
  Dim oCursor as Variant
  Dim oText As Variant
  Dim s As String
  Dim iRightCounter As Long   : iRightCounter = 0
  Dim wasRightPage As Boolean : wasRightPage = False

  oText = ThisComponent.Text
  oCursor = oText.CreateTextCursor()
  oCursor.GoToStart(False)
  Do
If NOT oCursor.gotoEndOfParagraph(True) Then Exit Do
iCnt = iCnt + 1
wasRightPage = False
If NOT IsEmpty(oCursor.PageDescName) Then
  s = s  Paragraph   iCnt   has a new page to style   _
 oCursor.PageDescName  CHR$(10)
End If
If Not IsEmpty(oCursor.PageNumberOffset) Then
  s = s  Paragraph   iCnt   has a new PageNumberOffset to   _
 oCursor.PageNumberOffset  CHR$(10)
End If
If oCursor.BreakType  com.sun.star.style.BreakType.NONE Then
  s = s  Paragraph   iCnt   has a page break  CHR$(10)
  'oCursor.BreakType = com.sun.star.style.BreakType.NONE
End If
  Loop Until NOT oCursor.gotoNextParagraph(False)
  MsgBox s
End Sub

What will it tell you? It should tell you every time that the page style 
changes, and every time that the page number is specifically told to 
change PageNumberOffset.


I am curious if you see that it is showing a page number offset change 
at a page change when the page numbering changes.


It would be easy to change this macro to clear page number changes. At 
least I expect that it should be as easy as setting an empty value for 
this. I should test that.


Yep, just checked, I made a change as follows, which clears all page 
number changes after paragraph 10.


If Not IsEmpty(oCursor.PageNumberOffset) Then
  s = s  Paragraph   iCnt   has a new PageNumberOffset to   _
 oCursor.PageNumberOffset  CHR$(10)

REM THIS IS THE NEW THING HERE
  If iCnt  10 Then
Dim oEmpty
oCursor.PageNumberOffset = oEmpty
  End If
End If




On 11/13/2014 09:17 PM, anne-ology wrote:

My guess would be you've found a bug ...
or maybe ghosts  ;-)



From: svenja meyerricks ajn...@gmail.com
Date: Thu, Nov 13, 2014 at 9:09 AM
Subject: [libreoffice-users] LO Writer page numbering resets itself halfway
through document
To: users@global.libreoffice.org

Dear all,

I am not sure what to try anymore, so hoping that anyone on this list can
help please.

I have a long document (thesis) in .odf format, and the page numbers reset
themselves to 1 after page 170 or so (the page where the page break occured
sometimes changes, but even when I temporarily resolved it -see below- a
random page break or two always came back).

To resolve this, I have

- deleted and re-inserted page numbers several times (issue remained)
- searched for visible page breaks between pages (there are none)
- checked in the format/paragraph/text flow tab whether the first
paragraph on the reset page had the Insert Break box checked (it didn't)
- looked for the same in the paragraphs before and after the invisible page
break, but couldn't find anything.
- uninstalled and re-installed LibreOffice Version: 4.2.7.2 (that fixed it
at first, but then the same thing happened)

I would be massively grateful if anyone could help please, as I'm not sure
what else to try.

Many thanks,

Svenja



--
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] Printing Reports from BASE extends to Writer?

[Andrew Douglas Pitonyak]

I expect something like this to print the document

ThisComponent.printPages(Array())


Of course, you need to load it first so you would likely have something like


oDoc = StarDesktop.loadComponentFromURL( URL_OF_THE_DOCUMENT, _

_blank, 0, Array() )


And then print the oDoc

I did not try this, but it should work. Also, don't just close the document

On 10/30/2014 10:18 AM, Paul D. Mirowsky wrote:

Yes, that seems correct.

On 10/29/2014 4:55 PM, Andrew Douglas Pitonyak wrote:
Are you asking if it is possible to use a macro to open a document 
and then print it?


On 10/28/2014 11:56 PM, Paul D. Mirowsky wrote:
Can this be extended to Writer document, eliminating the requirement 
of opening Writer and selecting 'Print'?


On 10/28/2014 4:05 AM, Walther Koehler wrote:

Hi Peter

just another proposal:

sub printreport()

Dim oDoc as Object
Dim arg(0) as new com.sun.star.beans.PropertyValue

oDoc=ThisComponent
arg(0).name = Name
arg(0).value =   myprinter   
oDoc.printPages(arg())
end sub

Yours
Walther

Am Dienstag, 28. Oktober 2014 schrieb Peter Goggin:

On 28/10/14 15:01, Marion  Noel Lodge wrote:

Hi Peter,

A macro similar to this should do what you want -

Sub PrintReport()
ThisDatabaseDocument.ReportDocuments.getbyname(name of your
report).open()
End Sub

Then edit your Menu form, double click on the Print button and under
Events

| 'Mouse button pressed', link the button to the PrintReport() 
sub.  Then


when you run your application, clicking on the button should fire 
your

report.

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

On 28 October 2014 13:24, Peter Goggin petergog...@bigpond.com 
wrote:
I have a report run from a push button on a menu form. I can 
print it
from the screen, but in Access I was able to program a push 
button to

print id directly.  Is this possible in BASE? I cannot find any
reference to this.

Regards


Peter Goggin

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

Thanks for the suggestion. However all the subroutine does is display
the report on the screen. I want to be able to send it to the printer
without first displaying it on the screen. So far I cannot see any
reference on how to doi this.

Regards

Peter Goggin













--
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] Printing Reports from BASE extends to Writer?

[Andrew Douglas Pitonyak]

Are you asking if it is possible to use a macro to open a document and 
then print it?


On 10/28/2014 11:56 PM, Paul D. Mirowsky wrote:
Can this be extended to Writer document, eliminating the requirement 
of opening Writer and selecting 'Print'?


On 10/28/2014 4:05 AM, Walther Koehler wrote:

Hi Peter

just another proposal:

sub printreport()

Dim oDoc as Object
Dim arg(0) as new com.sun.star.beans.PropertyValue

oDoc=ThisComponent
arg(0).name = Name
arg(0).value =   myprinter   
oDoc.printPages(arg())
end sub

Yours
Walther

Am Dienstag, 28. Oktober 2014 schrieb Peter Goggin:

On 28/10/14 15:01, Marion  Noel Lodge wrote:

Hi Peter,

A macro similar to this should do what you want -

Sub PrintReport()
ThisDatabaseDocument.ReportDocuments.getbyname(name of your
report).open()
End Sub

Then edit your Menu form, double click on the Print button and under
Events

| 'Mouse button pressed', link the button to the PrintReport() 
sub.  Then


when you run your application, clicking on the button should fire your
report.

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

On 28 October 2014 13:24, Peter Goggin petergog...@bigpond.com 
wrote:

I have a report run from a push button on a menu form. I can print it
from the screen, but in Access I was able to program a push button to
print id directly.  Is this possible in BASE? I cannot find any
reference to this.

Regards


Peter Goggin

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

Thanks for the suggestion. However all the subroutine does is display
the report on the screen. I want to be able to send it to the printer
without first displaying it on the screen. So far I cannot see any
reference on how to doi this.

Regards

Peter Goggin








--
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] Help with Conditional Macro Please

[Andrew Douglas Pitonyak]

On 10/26/2014 06:29 PM, Budgie wrote:

Yes, apostrophe sorry.
DATEVALUE, that was it.
Many thanks once more.
Will report back if problems, else thanks again,
Budgie



In general, it is better to use the built-in methods when ever possible 
since they will easily stay with the sheet without complaining about 
contains macros (especially if you share them).


Also, there seems to be an easier learning curve with built-in methods! :-)

--
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] SOT - interesting article!

[Andrew Douglas Pitonyak]

On 09/22/2014 01:00 PM, Brian Barker wrote:

At 17:05 22/09/2014 +0100, Gordon Burgess-Parker wrote:
http://www.computerweekly.com/blogs/public-sector/2014/09/microsoft-gets-flack-over-rubb-8.html 



What a pity they cannot spell flak - even in a headline!

Brian Barker



I suppose that it depends on how you read it. flak is the stuff you 
use to shoot down a plane and flack has some meaning related to 
publicity. I could infer either as being correct. I might consider it 
flak because I think that it paints MS in a bad light, but, it might be 
Flack simply because they are receiving publicity (although bad) about it.


Interesting observation Mr. Barker.

--
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] Table presented totally wrong.

[Andrew Douglas Pitonyak]

On 09/11/2014 02:15 PM, Stef Bon wrote:

I got a template.docx of my education institution, and tried to open
it using LibreOffice.
I found out too late - after I sent it, I got comments of receiver - that writer
did show the table totally wrong.
I have seen that some tables do not show proper spacing when opened in 
LO. I suppose that the proper thing to do (which I have been lax on) is 
to create a bug report so that it can be fixed. I have no idea if the 
problem is with Word or Write.


If I see this problem then I generally either fall back to use Word (if 
I have it available) or I fix the problem in LO and then save it as a 
doc file. I have not checked to see if fixing in LO and then saving it 
as a DOCX file produces a similar format in Word.


--
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] dateValue() to dateText()?

[Andrew Douglas Pitonyak]

I have never tried conditional formatting, but, it may apply, sorry I 
don't have time to investigate further, but, hopefully it helps.


https://help.libreoffice.org/Calc/Conditional_Formatting



On 09/05/2014 11:04 PM, Ross wrote:

I have a spreadsheet to keep track of payments. In one column I will type
'ctrl+;' to enter the date. These cells are formatted for date and duly show
the date. If a date is entered the amount received will appear in the
adjacent cell (the amount is the same for everyone, so it's part of the cell
formula).  On a separate sheet I keep track of payments due. These cells
check for entries in the 'Date' column. If the 'Date' column cell is blank,
they show amount due (requiring 'number/currency' formatting); if there is
an entry in the 'Date' column cell (ie. there has been a payment) I want the
cell to show the date from the 'Date' column. However, because the cells are
formatted for 'number/currency' I get a number. Under formulas we have
dateValue(). What is the opposite of that? Why isn't there a dateText()
formula? What am I missing?



--
View this message in context: 
http://nabble.documentfoundation.org/dateValue-to-dateText-tp4121333.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] Re: Running a Macro from a form

[Andrew Douglas Pitonyak]

I always assume that it might be useful, which is why any of my 
documents exist :-)


So, by all means, post the code.

On 08/31/2014 02:58 AM, Marion  Noel Lodge wrote:

Hi Allan,

With the help of Andrew and Alex, you may have solved your problem by now.
But if not, I run lots of SQL commands in my Base applications and I could
post the Basic code I use, if that was likely to be of any use to you.

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


On 29 August 2014 19:32, Alex Thurgood alex.thurg...@gmail.com wrote:


Le 28/08/2014 13:46, Allan Newton a écrit :

Hi Allan,


However if I create blank form with just one button and set the

properties

of that button to

run the macro it fails at the line

  if IsNull(ThisComponent.CurrentController.ActiveConnection) then

  with the error message

  BASIC runtime error.

Property or method not found: ActiveConnection.



Can anyone help me please?

That error message is telling you (or should be telling you) that you
have no Database Context. ActiveConnection is instantiated via a
database connection context :


http://api.libreoffice.org/docs/idl/ref/interfacecom_1_1sun_1_1star_1_1sdbc_1_1XConnection.html

so the macro in your form has to create such a context before
ActiveConnection can return any value.

As you don't say whether your form has been made within your ODB file,
or whether it is independent, it is hard to help out much further.
Generally, if the form is created within the ODB file, the connection
context is initiated upon opening the main ODB interface, whereas an
independent form needs to establish the connection context first. If
your form is within the ODB file, then one of the reasons why the
connection context might not be found is because it needs to walk up the
window hierarchy to find the main or parent. As far as I know, this has
always been a weakness of the CurrentComponent method within Base
containers where child form windows do not automatically inherit the
connection context. Andrew has indicated a way of obtaining the
connection context from by walking up the Model hierarchy of the
Database container.


From a quick read, the answer to your problem seems to have been
published here :

https://forum.openoffice.org/en/forum/viewtopic.php?f=45t=42882#p198477


Alex





--
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] Running a Macro from a form

[Andrew Douglas Pitonyak]

On 08/28/2014 07:46 AM, Allan Newton wrote:

In a database of mine a very convenient way to execute some operations is by
running a small series of SQL statements.

  


As Base has no direct way to run a text file of SQL statements I asked on
Ask Libre Office and was given code in Basic that would read and execute a
file of SQL.

  


The first few lines of code are shown below

  


REM  *  BASIC  *

rem Option Explicit

  


Sub DoSQL

  


rem how to read text file

rem https://forum.openoffice.org/en/forum/viewtopic.php?f=20t=33009

rem how to execute sql

rem
http://ask.libreoffice.org/en/question/21205/libreofficebase-how-to-execute-
sql-from-basic-script/

rem check database connection

DIM txtfile AS STRING

DIM f1 AS INTEGER

DIM s AS STRING

DIM oStatement AS OBJECT

  


MsgBox(Code started)

if IsNull(ThisComponent.CurrentController.ActiveConnection) then

  ThisComponent.CurrentController.connect

endif

  


If I run this from the macro menu it runs perfectly.

  


However if I create blank form with just one button and set the properties
of that button to

run the macro it fails at the line

  if IsNull(ThisComponent.CurrentController.ActiveConnection) then

  with the error message

  BASIC runtime error.

Property or method not found: ActiveConnection.

  


Can anyone help me please?

  


My final objective would be a form with 3 or 4 buttons each of which would
execute a different file of SQL

  


Regards

  


Allan

  


__

Allan Newton

Optical System Design

  





I assume that you have read this:

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

I have not looked at this stuff in a long time, but, here are a few 
thoughts off hand.


1. The error is stating that the ActiveConnection property is not 
available from the current controller for the current document. So, what 
is different with respect to the current document when you run this from 
a form compared to running this from an event handler? Again, I am 
just guessing, but... is the form part of a Base document? If it is, 
then you may need to grab the parent containing Base document, but that 
is a straight up guess. Do you know that you have an active connection? 
I think that this leads directly back into the link above related to 
ThisDatabaseDocument compared to ThisComponent.


Another possibility is that you test the current controller to see if it 
supports the ActiveConnection property. The fact that you test to see if 
the ActiveConnection is null, tells me that if you suspect that it may 
not contain one. I assume that you do something like this if needed:


oBaseContext = CreateUnoService(com.sun.star.sdb.DatabaseContext)
oDataBase = oBaseContext.getByName(sDBURL)
oCon = oDataBase.getConnection(, )

At one point, I even did something silly like this inside of an event 
handler (not that I know if that would work for your or if it would 
still work):


oCon =  oEvent.Source.Model.Parent.ActiveConnection
container = oCon.Parent.DatabaseDocument.FormDocuments

I hope this helps a little.

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

[Andrew Douglas Pitonyak]

The most of which I am aware is the ability to see which cells reference 
the current cell, and, even then, you won't see the cells if they are 
not visible on screen.


It requires a macro to turn on and off. It is rather obscure; I think it 
is meant for debugging.


On 07/30/2014 02:37 AM, Pat Brown wrote:

Hi,
In a relationall DB there is a facility to display all the tables and
this also shows how the tables are related and also which fields are
related and how they are related. This is extremely useful to get an
overall pcture of how things fit together and, importantly in this case,
what the effects would be of changing something in one table on the data in
the other tables. Does such a feature exist in Calc? With a large number of
sheets and many cells looking up data in cells on other sheets it would be
great to be able to see how changing a sheet name or a column heading would
affect the rest of the data.

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] status of macro in ODF interoperability?

[Andrew Douglas Pitonyak]

On 07/23/2014 11:40 AM, M. Fioretti wrote:

Greetings,

When I wrote this, almost 10 years ago, things didn't looking too good
for inter-suite macro compatibility:

http://archive09.linux.com/feature/47935

today, I have the feeling thing's haven't really improved, when it
comes to macros inserted in ODF files, even considering only the
FOSS-based suites, i.e. AOO, LO, Calligra... but I am not sure. What's
your opinion, or reports from the trenches? Any feedback is welcome.

 Thanks,
Marco

Do the other programs you mention support macros?

When you write a program, you have a set of routines, functions, and 
syntax that is supported (roughly speaking although not totally 
accurate). This part of the language means things such as how do I 
wrote a loop. Then you have the part of how do I control a specific 
word processor. The part that you use to control the word processor is 
very specific to LO internals. The language itself does not provide a 
means to manipulate what might be contained in the document. It merely 
provides the framework that you then use to control the program. I can 
control MS Office from a macro in LO, and that has nothing to do with 
specific commands in LO that you can use to manipulate a document. It is 
how you use the language to use the stuff provide by MS to control 
office. The stuff that you use to control LO is very dependent on the 
internal implementation of LO. So, those specific objects and such will 
not exist in another application.


Based on this, I suspect no compatibility. A macro in LO is mostly 
compatible with AOO. They are diverging, so things will only get worse.


--
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] status of macro in ODF interoperability?

[Andrew Douglas Pitonyak]

On 07/25/2014 03:17 AM, M. Fioretti wrote:

On Fri, Jul 25, 2014 02:25:29 AM -0400, Andrew Douglas Pitonyak wrote:

On 07/23/2014 11:40 AM, M. Fioretti wrote:
that is supported (roughly speaking although not totally accurate). This
part of the language means things such as how do I wrote a loop. Then you
have the part of how do I control a specific word processor. The part that
you use to control the word processor is very specific to LO internals. The
language itself does not provide a means to manipulate what might be
contained in the document.

Andrew,

no offense meant, but at first sight this reply of yours sounded to me
as just an expansion, much better worded of course, of what I myself
wrote in that piece in 2005 I had linked to initially:

http://archive09.linux.com/feature/47935

then I thought: maybe you mean that the second category of macros I
mention there (those for one specific document) doesn't really
exist, or cannot really exist?

Thanks,
Marco


First, no offense taken; I am hard to offend, especially when you are 
polite :-)


You are certainly correct that I did restate some of what you said. In 
fact, you also said something in your article that I danced around, and, 
it is probably the most important point. And that is


There is no macro language specification.

Even if there were a macro language specification, it still would not 
help unless that macro specification included not just the language 
semantics, but, also, commands used to manipulate the document and to 
interact with the program in general. When I hear language 
specification, I never think about specific things to externally 
control a program. So, they would also need to specify an API usable to 
manipulate documents, switch between documents, etc.



--
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] How to locate python macro for editing?

[Andrew Douglas Pitonyak]

On 07/25/2014 06:16 PM, Jim Byrnes wrote:

I am using Ubuntu 12.04 and LibreOffice 3.5.7.2.

A couple of years ago I created a python macro and a custom menu entry 
to run it.  It still works but I am going to change the underlying 
sheet and will need to change the macro.  The problem is I haven't 
done any work with macros since I wrote it and now I can't find it to 
edit.


If I look in Tools--Macros--Organize Macros--Python I see:

MyMacros (It's not in here)
LibreOfficeMacros (It's not in here)
MySpreadsheet.ods (clicking or double clicking this does nothing)

It is not in /usr/lib/libreoffice/share/Scripts/Python

or

/.config/libreoffice/3/user/Scripts/python

I can't remember if it is possible to embed a python macro in a sheet 
or not.  If it is how do I edit it?


The name of the macro in the menu is enterPmts.  I have searched the 
file system for enterPmts.py and variations but have found nothing.


I'm feeling a little dumb right now so any help is appreciated.

Regards, Jim




Clearly there is a difference between feeling dumb and being dumb 
since it looks like you looked in the right places :-)


I know little to nothing about macros in Python, but, here are some 
random uninformed thoughts.


1. You want to know if the macro is embedded in a document. Well, how do 
you run the macro? Are you able to run this macro when no documents are 
loaded? If yes, then, that macro is NOT contained in a document.


2. Have you attempted something extreme like find . | grep -i enterPmts

How do you know that the macro is named enterPmts.py anyway? If it 
really is named that, then you may need to simply search the entire file 
system. Sadly, I do not have version 3.x installed, so I cannot test.


I think that it is possible to store macros in a different location and 
import a link to them, so, it may not live where you expect. Depending 
on how you run them, however, (at least in basic) there is a script.xlc 
and script.clb file that references the libraries and macros (for 
basic). I expect that you might have something similar in the python 
directory. Do you have a python directory, or, only the basic directory 
(.config/libreoffice/3/user/python)? If you do, does that directory 
contain a file with a link to stuff?





--
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] Calc macro - selection by keyboard not recorded

[Andrew Douglas Pitonyak]

I generally send only to the list. This is what you missed if it did not 
make it.


You are doing nothing wrong The macro recorder fails to record 
certain actions and should be reworked from the start, but, that is not 
likely to happen (sadly). If you want to set the first character to bold 
regardless of what you have selected, you could run something like this 
(your welcome):


Sub FirstCharBold
  Dim oOldSelection 'The original selection of cell ranges
  Dim oDoc
  Dim oCells
  Dim oCell
  Dim oEnum
  Dim iRows As Integer
  Dim iCols As Integer
  Dim iRow As Integer
  Dim iCol As Integer
  oDoc = ThisComponent

  REM store the current selection
  oOldSelection = oDoc.CurrentSelection
  If HasUnoInterfaces(oOldSelection, com.sun.star.text.XText) Then
'Inspect oOldSelection
 BoldFirstChar(oOldSelection.getText())
  ElseIf HasUnoInterfaces(oOldSelection, 
com.sun.star.sheet.XSheetCellRanges) Then

oCells = oOldSelection.getCells()
oEnum = oCells.createEnumeration()
Do While oEnum.hasMoreElements()
  oCell = oEnum.nextElement()
  BoldFirstChar(oCell.getText())
Loop
  ElseIf HasUnoInterfaces(oOldSelection, 
com.sun.star.sheet.XSheetCellRange) Then

iCols = oOldSelection.getColumns().getCount() - 1
iRows = oOldSelection.getRows().getCount() - 1
For iRow = 0 To iRows
  For iCol = 0 To iCols
oCell = oOldSelection.getCellByPosition(iCol, iRow)
BoldFirstChar(oCell.getText())
  Next
Next
  Else
Print Help, what is selected
  End If
End Sub

Sub BoldFirstChar(oText)
  Dim oCurs
  oCurs = oText.createTextCursor()
  ' Goto start of text but do not select anything.
  oCurs.gotoStart(False)
  If oCurs.goRight(1, True) Then
oCurs.CharWeight = com.sun.star.awt.FontWeight.BOLD
  End If
End Sub


On 07/17/2014 01:41 AM, je...@lang.hm wrote:

david_lynch david_ly...@blueyonder.co.uk posted to 
users@global.libreoffice.org at 0:23 on Sun, 13 Jul 2014 about Calc macro - selection 
by keyboard not recorded:


On 13/07/2014 01:46, Andrew Douglas Pitonyak wrote:

On 07/12/2014 04:41 PM, david_lynch wrote:

Although reasonably experienced using calc, I haven't used macros much.

snip
What am I doing wrong please?

David Lynch

4.2.4.2 on Windows 8


You are doing nothing wrong The macro recorder fails to record
certain actions and should be reworked from the start, but, that is
not likely to happen (sadly). If you want to set the first character
to bold regardless of what you have selected, you could run something
like this (your welcome):


snip

What did Andrew suggest? As far as I can tell, the snipped suggestion never 
made it to this list.

[RANT]

This is a perfect example of why it is stupid to not post ordinary replies to 
this list!

[/RANT]


Many thanks Andrew. I had simplified what I wanted: your code will, I

think, enable me to complete the task.

David Lynch


--
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] Calc macro - selection by keyboard not recorded

[Andrew Douglas Pitonyak]

On 07/13/2014 03:22 AM, david_lynch wrote:

On 13/07/2014 01:46, Andrew Douglas Pitonyak wrote:


On 07/12/2014 04:41 PM, david_lynch wrote:

Although reasonably experienced using calc, I haven't used macros much.

snip
What am I doing wrong please?

David Lynch

4.2.4.2 on Windows 8



You are doing nothing wrong The macro recorder fails to record 
certain actions and should be reworked from the start, but, that is 
not likely to happen (sadly). If you want to set the first character 
to bold regardless of what you have selected, you could run something 
like this (your welcome):



snip

Many thanks Andrew. I had simplified what I wanted: your code will, I 
think, enable me to complete the task.


David Lynch


Glad it helped!

--
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] Bug with Chapter Title in running headers

[Andrew Douglas Pitonyak]

I wanted to applaud you for a well done bug report. Spent some time 
looking at this so that when the QA team looks at this someone will have 
already tested. More thoughts at the bottom.


On 07/10/2014 11:30 AM, Kartik Subbarao wrote:
I seem to be running into a bug with Libreoffice intermittently 
displaying the wrong Chapter Title field in the header. I've reported 
this as bug 81012 in bugzilla:


https://www.libreoffice.org/bugzilla/show_bug.cgi?id=81012

In the meantime, I wanted to ask if people had any suggestions for 
workarounds. Here's the problem:


I have a Page Style that uses the Chapter Title in the right page 
header. In this document, I've created a section to contain each 
chapter, with endnotes appearing at the end of the section. This works 
fine for the most part, up through the first page of endnotes in a 
chapter. After that though, the title of the *first* chapter is 
displayed instead of the title of the *current* chapter (see the 
rh.odt and rh.pdf files in the bug report to see exactly what I'm 
saying).


This poses a problem for me since my actual document is a 300+ page 
book with lots of chapters, and some chapters have several pages of 
endnotes that end up being wrongly formatted.


I'm seeing this bug in 4.2.5.2, and it appears that the bug goes at 
least as far back as 3.3.0.4. (That was the earliest version that I 
was able to download and test from the download.documentfoundation.org 
site).


Current workarounds I'm thinking about:

1) Edit the PDF file directly to fix the chapter titles before 
printing the book (Somewhat cumbersome and perhaps time-consuming to 
figure out how to do properly)
2) Create several copies of the .odt file, hardcoding the Chapter 
Title in the header (the first file would be hardcoded to the first 
chapter, the second file hardcoded to the second chapter and so on), 
use --headless and --convert-to pdf to convert each of those files to 
PDF, and then cut+paste the appropriate chapters from each of those 
PDF files into a final PDF file that has all of the headers correct. 
(Tedious but probably workable, assuming that all of the automated 
tools work the way they should).


Any other thoughts/ideas would be welcome.

Thanks,

-Kartik

You are using end notes, so, why not use a page break and use a specific 
page style for your end notes with a particular field rather than simply 
setting it to whatever the last chapter happened to be.


--
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] Templates as Extensions in Calc

[Andrew Douglas Pitonyak]

On 06/18/2014 10:23 AM, Kevin O'Brien wrote:

I noted in the document CG4004 - Using Styles and Templates in Calc there
is a discussion about installing Templates using the Extension Manager. So
far I have not had any success in finding any Templates packaged in this
manner. Am I just looking in the wrong places, or are most Templates really
just offered as *.ots files to manually install?

Thanks,



I have never packaged or used templates packages as an extension. If you 
want to test one, however, take a look at this:


http://extensions.openoffice.org/en/project/professional-template-pack-english

http://extensions.openoffice.org/en/project/professional-template-pack-ii-english

http://extensions.openoffice.org/en/project/oxygenoffice-extra-templates




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

[Andrew Douglas Pitonyak]

On 06/11/2014 07:53 AM, Gavin Buxton wrote:

Hi

I'm writing a book on using spreadsheets for computer modeling, and on my
last model I've ran into a slight problem. Libreoffice calc is doing
something new. I'm using macro's to update the time step by simply copying
the new information over the old information. For example, imagine having a
number in cell A1 and then in cell B1 you type =A1 + 1. Then you copy and
paste (special with number only) the number from B1 to A1, such that A1 is
now 1 more than it was to start with and B1 is now double the original A1.
I can keep running the macro and continually count upwards. I create a
button that when pressed runs the macro. However, whereas before pressing
the button repeatedly always worked, now I have to press the button and
then click elsewhere on the spreadsheet and then press the button again.

Wondering if I'm missing anything obvious?

Nope, probably not missing something obvious :-)

Are you using dispatch messages?

What happens if you change the macro to do something like this:

  Dim oSheet
  oSheet = ThisComponent.Sheets(0)
  oSheet.getCellByPosition(0, 0).setValue(oSheet.getCellByPosition(1, 
0).getValue())


Note, cell (0,0) is A1 and (1,0) is B1.


My guess is that the problem goes away.  I think that it is related to 
what has the focus and how you issue the dispatch.


--
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] Extensions by Openoffice

[Andrew Douglas Pitonyak]

I publish the same extension to both LO and AOO and it works fine in both.

The extension will work, or not, based on how the extension is written. 
What is the extension? Do you know the implementation language? If


My extension is in basic so there is no external dependency, which means 
that it should work on any platform or distribution (unless I use an API 
that was changed in one or the other). I would say just install it and 
see if it works. That said, if they have a different version based on 
the platform, it is less likely to work. If it is written in basic, it 
is probably fine. In C++, I expect that it might not work; but I am only 
guessing.


Which extension is it? What platform do you use (windows? Linux? Mac?)

On 06/12/2014 06:05 PM, peter wrote:

Hi! I want to install some extensions from Openoffice in LO, can I do it
without any severe problems? Will they function in Libreoffice?

Peter



--
View this message in context: 
http://nabble.documentfoundation.org/Extensions-by-Openoffice-tp4112242.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] Macro's in Libre Calc

[Andrew Douglas Pitonyak]

Be certain to only do what you really need to do using a macro, and then 
let things such as formulas do the rest of the work.


It sounds like you want to have a Calc document with 366 sheets (so that 
it will work with leap years) with the same sheet on each page. Well, 
the sheet is the same except for the date.


I might argue that you could simply leave the date empty and let that be 
filled in, but, lets ignore that for a second.


As a test, I created a Calc document. On Sheet 1, I entered the text 
Date into A1. I entered the date 01/01/14 in cell B1.
I created Sheet2 and in cell A1, I entered the formula: =Sheet1.A1. In 
cell B1, I entered the formula: =Sheet1.B1 + 1.
I then copied cells A1:B1, created a new sheet (Sheet3), and then I 
pasted those two cells into location A1:B1 on sheet3.


At this point, Cell A1 has the same text on each sheet, and, cell B1 has 
the dates 1/1/14, 1/2/14, and 1/3/14. Now, if I updated cell Sheet1.B1 
with a new date, then B1 updates in all the other sheets.


Is there any particular reason that you must use a new sheet for each 
printed page? Might you be able to create all the pages on the first 
sheet such that they are all on the first sheet? You would place the 
second page far enough down that it would then print on the second page 
and use formulas to refer to the previous page / date, and then do a 
copy and paste of multiple pages in one shot. Admittedly, this will use 
a bunch of rows (around 18000 is my guess), but that is likely faster 
than created a macro.


If you do opt to write a macro

Listing 403 in OOME_3_0.odt demonstrates inserting sheets. The code 
would probably look something like:


Dim i As Integer
For i = 1 to 365
  ThisComponent.Sheets.insertNewByName(Sheet  CStr(i + 1), i)
Next

OK, now you have 366 sheets. You probably want to copy the content from 
sheet (i-1) to sheet i as you go. If you raelly want to transfer that 
content, you can do something like get the transferable content (Listing 
439 has an example), but, to do that, you would need to set the desired 
sheets to be active, which just feels annoying and tricky (but it can be 
done). Probably easier to:


Manually set Sheet 1 as you want.
Build Sheet 2 by hand using formulas to refer to Sheet 1. Write the 
macro to insert the sheets after 2. If you only want to copy formulas, 
then use getFormulaArray on sheet 2, then use setFormulaArray for the 
rest of the sheets... And I need to go to sleep now.


On 06/09/2014 06:24 PM, Philip Ward wrote:

Hi Tom/all

sorry for delay in getting back, and cheers for the info, ill take a look
tomoz night and the link, that much on the go at the moment...

basically what im after is...

A cleaning/HSE Check sheet, that gets printed out, and the staff fill it
out, ie tick the boxes, say whats gone of in that day etc.

i have laid out a sheet, over 2 pages, and the only thing that i want to
basically do is print out 365 (or obviously a leap year 366) page document,
and automatically add a new date to the printed sheet for that.

i didnt want to copy and paste the same thing 365 times, for 4 or 5 times,
as there are different parts of the business, ie Cafe/Bar/Icecream kiosk
etc, which all need their individual style/setup.

i was looking for a quick way to copy the sheet, add a new sheet, paste it,
then do the same thing over and over again. On the second sheet i know i
can make a date = Previous sheet/Cell and +1 to it, and this would be the
one thats copied all the rest of the year, but thats about where my
knowledge on libre finishes (having brought most of what i knew from
excel), but have never done any macro's of this sorts before, well part
from gimp to re-size/touch up pictures, and even then found that i could
have done it quicker manually!

i just would prefer not to copy and paste something a potential 1825
times!! my control and V key probably woudlnt like me very much

Cheers
Phil


On 8 June 2014 22:00, Tom Davies tomc...@gmail.com wrote:


Hi :)
Andrew Pitonyak's guide is pretty good and might be helpful

https://wiki.documentfoundation.org/Documentation/Other_Documentation_and_Resources#Programmers

Really it is best to just ask the question here and let this team build-up
the best answer by trying out different things.
Good luck and regards fro m
Tom :)




On 8 June 2014 19:23, Philip Ward skegg...@gmail.com wrote:


Hi Guys,

Who is the best person to speak to about macro's in calc?

cheers
Phil

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

Re: [libreoffice-users] making graphics stay where you put them

[Andrew Douglas Pitonyak]

On 05/22/2014 07:52 AM, Virgil Arrington wrote:
I think, conceptually, that is a problem. You can anchor to page, 
paragraph, character, and as character, whatever that means.


If you anchor it as a character, then just think of it as one huge 
character. You can type text before and after it, but, the baseline of 
the image will be set to the baseline of a character. If it is sitting 
in the middle of a paragraph, there will be a line above and below it. 
If you have two pictures next to each other on the same line anchored as 
character, then, their baseline will be the same, so, if they are not 
the same height, it may look a bit strange.


--
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] making graphics stay where you put them

[Andrew Douglas Pitonyak]

On 05/25/2014 10:44 AM, Regina Henschel wrote:

Hi Andrew,

Andrew Douglas Pitonyak schrieb:


On 05/22/2014 07:52 AM, Virgil Arrington wrote:

I think, conceptually, that is a problem. You can anchor to page,
paragraph, character, and as character, whatever that means.


If you anchor it as a character, then just think of it as one huge
character. You can type text before and after it, but, the baseline of
the image will be set to the baseline of a character.


The possible settings are far more. You can combine the vertical 
positions {top, bottom, center, from bottom} with the references 
{baseline, character, row}. That gives 12 combinations, and then in 
addition the different possible values for 'from bottom'.


 If it is sitting

in the middle of a paragraph, there will be a line above and below it.


?? I have no lines.


If you have two pictures next to each other on the same line anchored as
character, then, their baseline will be the same, so, if they are not
the same height, it may look a bit strange.


That is a matter of aesthetic perception; the tools exist to make is 
looking nice.


Kind regards
Regina


Merely indicating what I expect when I insert two images, anchor them as 
character and place them on the same line. I was not aware that I could 
then change other items when it was anchored as a character (primarily 
because I have never needed to do so (or considered looking). I think I 
just learned something :-)  As always, you are very helpful Regina!


--
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] making graphics stay where you put them

[Andrew Douglas Pitonyak]

On 05/21/2014 03:16 PM, Bruce Byfield wrote:

If you've done much work positioning graphics in text, then you know how
difficult it can be to make sure that the graphics stay in place. In the past,
many experts have come up with recommendations about the best settings to use,
but these suggestions either don't work if you try to export to another format
or else have been made obsolete by changes to the program over the year.

In preparation for my upcoming book on OpenOffice/LibreOffice, I'm hoping to 
solve
this  problem once and for all. Could anyone who is interested reproduce the
two methods below, then try to break them by copying and pasting, adding text
around the graphics, and anything else you can think of? I would be very
interested in hearing results, especially on platforms other than Linux.


I almost always anchor the picture AS a character on a line by itself 
with a specific character style that should keep it with the next 
paragraph, a manually inserted caption. You can see this in any of my 
macro documents. AndrewMacro and OOME are both very long with numerous 
images and they have no problems.


Years ago I had my images inside of frames, but, I found a very nasty 
bug that caused OOo to crash based on a certain set of conditions. I 
manually edited the XML in a text editor to remove the problem so that I 
could keep the document. I do believe that bug was fixed by Sun :-)


--
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: Intentionally crashing LibreOffice when frozen/LibreOffice will not start.

[Andrew Douglas Pitonyak]

http://en.wikipedia.org/wiki/R_(programming_language)

R is a free software programming language and software environment for 
statistical computing and graphics.


Calc has a limit of one million rows (well, 1048576 if I remember 
correctly).


I expect that you will not have this problem if you manipulate the data 
using R. I don't remember off hand how large my data sets were when I 
last used R, but I never had a problem apart from figuring out how to 
accomplish what I wanted.


If you have trouble when Calc performs an auto-save, then disable 
auto-save.


GNUmeric used to have a row limit of 65536 rows, but, that was removed. 
I have no idea if they simply set a new maximum, or, if they removed the 
limits in some other way.


On 05/01/2014 08:36 AM, Jacqueline Tarleton wrote:

But I am getting more comfortable with using R itself to answer these...

Excuse my ignorance - What is R?

This particular Thread has provided amazing details on the limitations of
Libre Office Calc, tips, hints, and workarounds- except do not know what is
R. I apologize in advance for not offering a solution. Jackie
On Apr 17, 2014 5:57 PM, andrewH ahoer...@rprogress.org wrote:


Thanks Tom!

Gnumeric is a great product and I have used it before. I was hoping to use
Calc in this case because I am trying to learn to use the LO database,
Base, as a stand-alone or a front end for PostgreSQL. But I find it very
hard to define, use, and even just to import a file into a database if I
can not first look at it and determine how missing variables are coded,
which fields are character and which are numeric, etc. Some census products
are really good at giving users this kind of metadata, others not so much.
(The Economic Census metadata is hard enough to read and understand (would
you put material intended to explain something to the public in
pipe-delimited text?) that I have written to them asking for meta-meta
data). So I wanted to use Calc for exploration and base to do the heavy
lifting, in the hope that things might be easier if I stayed withing one
document family. Now I am thinking that some other approach will be easier.

Warmest regards, Andrew


On Sat, Apr 5, 2014 at 2:09 AM, TomD [via Document Foundation Mail Archive]
ml-node+s969070n4104190...@n3.nabble.com wrote:


Hi :)
Try Gnumeric;
http://www.gnumeric.org/download.html

It's a dedicated spreadsheet program with a tiny footprint that uses
minimal resources, so it's faster, lighter and more robust than Excel
or Calc.  Many people find Gnumeric to be better than Calc or Excel
for serious or hefty spreadsheets and/or for handling many more
spreadsheets in a shorter time-frame.

It can be installed alongside LibreOffice and/or MS Office.  It uses
the same format as LibreOffice natively so most spreadsheets can be
bounced between the 2 programs quite happily.

Part of the advantage of LibreOffice is that it fits well into a wider
eco-system and co-operates well with a wider range of programs and
suites allowing you to tailor individual machines to specific
use-cases and yet still retain the ability to share files between
different machines and different people using different OSes and
programs.

Regards from
Tom )




On 5 April 2014 06:43, Andrew Douglas Pitonyak [hidden email]

http://user/SendEmail.jtp?type=nodenode=4104190i=0

wrote:


On 04/04/2014 07:44 PM, andrewH wrote:

I am working with a data set that keeps causing my LibreOffice to

freeze.

I
am pretty sure that this is only because it is big. It is a

pipe-separated

text from the US Economic Census imported into Calc, about 30 columns

and

around a million rows. (The actual data set is bigger, but Calc quits

at a

million-odd. The complete file is about 0.8 gig.) I suspect but can

not

prove that this is related to file handling somehow, e.g. breaking

down

during auto-saving. The first time I saved the data as a Calc file it

took

nearly an hour with the soffice.bin *32 process running at 25

percent

of

CPU time and using about 825 meg of memory the entire time. (Not sure

why

this is showing up as a 32-bit version).  And when Calc freezes, all

the

LibreOffice programs freeze. So I can't just switch to another file

and

noodle away while waiting.


It looks to me as though Calc cannot handle more than 1048576 rows of

data,

Do you have more rows than that? If yes, then I think that you cannot

open

the file.

If you have less than that, and, if you think that you are simply

running

out of memory if you can figure out how to get the data to me, I

can

run

a test on a 64 bit version (running on Linux). My machine has 32 GB of
RAM...


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



--
To unsubscribe e-mail to: [hidden email]

http://user/SendEmail.jtp?type=nodenode=4104190i=1

Problems?
http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more:

http

Re: [libreoffice-users] forums, The AOO one

[Andrew Douglas Pitonyak]

Note, it is NOT the official AOO forum that has the spam problem, it is 
OOoForum.org (just to be clear). The AOO forum (which also supports LO) 
runs great!


On 04/25/2014 08:01 AM, Tom Davies wrote:


Many magazines and places have forums or comments threads suffering 
from a similar lack of knowledge about LO/AOO or OpenSource generally 
and seem to try to push people back into buying MS Office

http://forums.computeractive.co.uk/showthread.php?t=232925
Compared to MS Office 2003 or even Works it was complicated = that's 
probably because MS Office was pre-installed on their machine but LO 
requires a few double-clicks.

http://forums.pcworld.com/index.php?/topic/147741-alternatve-to-libre-office/

Some languages have a strong enough team that they run forums.  Well 
at least 1!

http://www.libreoffice-forum.de/
(at a guess Italy and perhaps Brasil and others run their own too)

There is at least 1 unofficial forum;
http://libreofficeforum.org/
Originally set-up to show the need but the owner had invested too much 
into it by the time people started looking at it and it never became 
official.  Perhaps going to follow a similar path to ubuntuforums.


I was unaware of these.




It's a shame about the Apache forums being over-run with spam!  I 
didn't notice much at

https://forum.openoffice.org/en/forum/
It looked like Hagar  co were more active than spammers.  Is the OOo 
one a different link?  Perhaps timing or just that i didn't look in 
the right places in my brief skim-read.


No, this forum is well maintained. I refer to oooforum.org



Regards from
Tom :)




On 25 April 2014 12:18, Charles-H. Schulz 
charles.sch...@documentfoundation.org 
mailto:charles.sch...@documentfoundation.org wrote:


Hi

On 25 avril 2014 13:06:20 CEST, Andrew Douglas Pitonyak
and...@pitonyak.org mailto:and...@pitonyak.org wrote:

On 04/24/2014 03:05 PM, Tom Davies wrote:
 Hi :)
 Just popped into the Apache OpenOffice forum
 https://forum.openoffice.org/en/forum/
 and noticed their header claims User community support forum for
Apache
 OpenOffice, LibreOffice and all the OpenOffice.org

They were very intentional about that. Does LO even have a separate
forum?

THe OOoForum has been plagued with spammers since the forum
itself has
not been maintained so spammers can access it at will. It seems that
the
spammers have hit it hard enough that it is always slow. When I
connect

I feel that I can be sure that I will see hundreds (or more) new spam
messages since my last visit and not much else.

I visited one of the forum topics today and the first 4000 posts on
that
topic were spam. There are so many that it is not feasible to control
it
without some level of automation. I gave up trying to keep up
with the
spam and disabling accounts because I just do not have sufficient
time.
The official AOO Forum, however, is well maintained and usable.


Having a forum for LibreOffice is an old project and we had
several attempts for it. The issue is you need manpower and
volunteers to manage and maintain them, clean and block spam etc.
If we have these volunteers we will open a forum. As it stands
today we have 4 support options:
- mailing lists
- Nabble (mailing lists via a forum interface)
- Ask LibreOffice (Next generation collaborative support site )
- external forums (libreofficeforum.org http://libreofficeforum.org)

So far it may be observed we have pretty much everything covered ;-) .

Best,

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
mailto:users%2bunsubscr...@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

--
Envoyé de mon téléphone avec Kaiten Mail. Excusez la brièveté.

--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
mailto:users%2bunsubscr...@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

Re: [libreoffice-users] forums, The AOO one

[Andrew Douglas Pitonyak]

On 04/24/2014 03:05 PM, Tom Davies wrote:

Hi :)
Just popped into the Apache OpenOffice forum
https://forum.openoffice.org/en/forum/
and noticed their header claims User community support forum for Apache
OpenOffice, LibreOffice and all the OpenOffice.org


They were very intentional about that. Does LO even have a separate forum?

THe OOoForum has been plagued with spammers since the forum itself has 
not been maintained so spammers can access it at will. It seems that the 
spammers have hit it hard enough that it is always slow. When I connect 
I feel that I can be sure that I will see hundreds (or more) new spam 
messages since my last visit and not much else.


I visited one of the forum topics today and the first 4000 posts on that 
topic were spam. There are so many that it is not feasible to control it 
without some level of automation. I gave up trying to keep up with the 
spam and disabling accounts because I just do not have sufficient time.

The official AOO Forum, however, is well maintained and usable.

--
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] Retrofitting a template to a document

[Andrew Douglas Pitonyak]

I think that you want an extension called template-changer that allows 
you to set the document's template. A quick internet search showed this 
as one link to it


http://extensions.services.openoffice.org/en/project/template-changer

Same template will likely work for AOO or LO.

On 04/17/2014 04:57 PM, Toki wrote:

On 4/17/2014 12:46 AM, Tom Davies wrote:

It's also a good idea to post a bug-report using that office suite's
 bug-reporting system.

I'd rather deal with Microsoft's bug reporting system for non-paying 
customers.


jonathon


Do they have one? Last I checked, the text IO routines in their C++ 
libraries had bugs that I first had to create work arounds for ten years 
earlier. And I pay them over $1000 a year to use their compilers and 
such with an MSDN license. When I think of companies that are responsive 
to bugs, MS is pretty low on the list. Last time I called MS Support, 
they wanted a credit card to discuss with me if a new version of the 
software provided a fix for a limitation in the older version of a 
product that I was using. That was back in the early 90's. My only other 
interaction with MS support has been reactivating operating systems when 
they decided that the OS installed on the machine was pirated and I had 
to reactive the OS. Only had to do that three or four times in the last 
10 years. Annoying as all get out when it happens though.



--
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] Any thoughts on Tutor.com's policy of MS Word only?

[Andrew Douglas Pitonyak]

First, if you opt to go this route, be prepared to spend the money to 
buy the software.



On 04/17/2014 11:14 AM, Jeffrey Deutsch wrote:

Hello,

I'm thinking of applying for an online tutoring position at Tutor.com.
However, they require that tutors (and applicants, for the mock tutoring
session) have Microsoft Word (2007 or later) itself -- they specifically
say that OpenOffice is not acceptable. I'd rather not spend $110 just to
get MS Word (or $140 for MS Office, or $10/month or $100/year to rent MS
Office) for this specific job, when OpenOffice/LibreOffice has worked just
fine for me for the past decade.

Does anyone here have any relevant experience (eg, does Tutor.com in
practice allow OpenOffice/LibreOffice, is it absolutely necessary to get MS
Word, do you know of similar online tutoring services that allow
OpenOffice/LibreOffice, etc)?


So you are wondering if anyone knows why they request this? Likely not 
here, but, I can say that even between different versions of MSO you may 
have different behavior and rendering of documents. If they provide 
macros, they will not likely work in AOO or LO correctly. If they have 
complicated documents, that could be a problem in slight things. I 
notice, for example, slight differences in rendering between LO/AOO and 
MSO with respect to tables and their exact size on the page.


You can always take the position, and, when you have a problematic 
document, drop the money.




Thank you in advance!

Jeff Deutsch
Speaker  Life Coach
A SPLINT - ASPies LInking with NTs
http://www.asplint.com

Listen to the universe while it whispers before it has to shout.
Marion Grobb Finkelstein, Communication Catalyst --
http://www.MarionSpeaks.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] Do Macros run serially or in parallel?

[Andrew Douglas Pitonyak]

On 04/05/2014 09:13 AM, Marion  Noel Lodge wrote:

Hi,

Sorry I've been slow to respond to all your posts.  It has taken me a while
to sort out what I think is happening.


Many of us are very busy and totally understand when it takes time to 
respond!



Fernand, thanks for your code suggestion.  I pasted it into the start of my
macros and the Wait() statement worked perfectly.  Then I incorporated it
into my Init macro and discovered that none of my Wait() statements
worked.  The same applied to the AccName macro.  I was really puzzled and
probably spent longer than I should have on the problem, but I felt I
really needed an answer.  Finally, through much trial and error I found
which macros Wait() worked in and which it didn't.  My testing was not
exhaustive, but it seems that Wait() doesn't work in any macro that is
called from one of the Form's events.  When I got back to reading my
emails, I discovered that Andrew was predicting that this might be the
case!


So if you really wanted wait to work inside an event handler, you would 
need to write your own and then simply perform a busy wait. Something 
like this code that won't work as written (too lazy to look up syntax 
and such)


tempLong = getSystemTicks()
StopWhen = tempLong + someDeltaValue
Do While StopWhen  getSystemTicks()
  Do something to eat a bit of time
  For i = 0 To 1000
  For j = 0 To 1000
  doubleTemp = i + j
  Next
  Next
End



Then it occurred to me that, rather than use separate text files for
printing out the Now() values, if I used just one file, it would give me
the order of processing, and the exact times would not be so important.  So
I did that and also added System Ticks / 1000.  The result was as follows -


I purposely suggested two different files because if things were not 
serial, then you might have two places attempting to write to the same 
file at the same time (concurrency problem). My concern was that:


1. Macro A updates the form and control returns to Macro A that 
continues to run.

2. The form event is triggered calling Macro B before Macro A finishes.

So, if one macro updated a field on a form, which caused an event to be 
triggered, then the triggered event might be running in a separate 
thread (at the same time) as the macro that updated the field. In fact, 
if this was not the case, then I expected that the behavior would always 
be the same, and it sounded like the behavior was not always the same 
for you.



Init 1.  05/04/2014 23:20:37  43421.801
Init 2.  05/04/2014 23:20:37  43421.801
Init 3.  05/04/2014 23:20:37  43421.817
Init 4.  05/04/2014 23:20:37  43421.833
Init 5.  05/04/2014 23:20:37  43421.848
Init 6.  05/04/2014 23:20:40  43424.36
Init 7.  05/04/2014 23:20:40  43424.375
Name 1.  05/04/2014 23:20:40  43424.625
Name 2.  05/04/2014 23:20:40  43424.625
Name 3.  05/04/2014 23:20:40  43424.625

This demonstrates that macro Init ran before macro Name.

From this, and a number of other tests I ran, I believe that -
1.  Macros are always processed serially on a first come first served basis.
2.  If macro A calls macro B, then Macro A waits until macro B has
completed before the remaining code of macro A is processed.

These were the conclusions that I was hoping for.  As well, I now have a
mechanism for checking out other timing situations where I'm not sure what
is going on.

So thank you all for your input - it has been an interesting journey!

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

PS Alex, Yes you are right - the account name needs to be fetched from
another 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

Re: [libreoffice-users] Do Macros run serially or in parallel?

[Andrew Douglas Pitonyak]

Yes, I did the same test on Linux, and it works there as well.

Sub NowTest
  Dim s As String
  s = 1.Now()
  Wait(2000)
  s = s  CHR$(10)  2.Now()
  MsgBox s
End Sub

Can you try running this method, and, then, after that works, use 
similar code in your event handler to print a message to the screen in 
the two places of interest to see if maybe the wait command fails to 
work in an event handler.


I did a quick test to see if the NOW function returned a value with 
precision greater than one second, and, it seems that it does not. if it 
did, then waiting for 500 milliseconds should clearly show fractional 
seconds, yet, my fractional seconds are always on the order of 10^-7


Sub NowTest
  Dim s As String
  Dim l As Double
  l = Now
  s = 1.Now()   =   l
  Dim dSec As Double
  Dim lSec As Long
  lSec = CLng((l*1440 - CLng(l*1440)) * 60)
  dSec = (l*1440 - CLng(l*1440)) * 60 -lSec
  s = 1.Now()   =   dSec

  Wait(1000)
  l = Now
  lSec = CLng((l*1440 - CLng(l*1440)) * 60)
  dSec = (l*1440 - CLng(l*1440)) * 60 -lSec
  s = s  CHR(10)  2.Now()   =   dSec
  MsgBox s
End Sub


On 04/04/2014 03:23 AM, Fernand Vanrie wrote:

Noel , Andrew,

What system are you running ?

on windows the wait is doing OK

try this code


s1 = 1.   + Now()
Wait(2000)
s2 = 2.   + Now()
msgbox (s1  chr(13)  s2)

s1 an s2 differs from 2 seconds (wait 2000)

Greetz

Fernand

Hi Andrew,

Yes, that is what seems to be happening.  Even if there is a bit of code
between the Wait(2000) and the next Print #giInit, the time is the same.
Only if there is substantial code after the Wait(2000) does the time
change.  For example -
1.  04/04/2014 13:50:24
2.  04/04/2014 13:50:24
3.  04/04/2014 13:50:24
4.  04/04/2014 13:50:24
5.  B4 UpdateFundAndGenLed()  04/04/2014 13:50:24
6.  04/04/2014 13:50:28
7.  04/04/2014 13:50:28

After 5. the Init macro calls another macro.

Something odd seems to be happening with the Wait command. Perhaps I am
missing something.  You can see why I was wanting to get fractions of a
second in the print statements.

Noel

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


On 4 April 2014 03:06, Andrew Douglas Pitonyak and...@pitonyak.org 
wrote:



So, are you saying that you have:


Print #giInit, 1.   + Now()
Wait(2000)
Print #giInit, 2.   + Now()

And it prints the same value for now?



On 04/03/2014 09:12 AM, Marion  Noel Lodge wrote:


Thanks for the replies to my original post.

They gave me something to work on and I have made some progress.  I 
think

that the macros run in series, but I am not yet sure of that.

For some reason the wait(2000) commands that I inserted into the the
macros
don't seem to work and I am getting several lines with the 
identical time

stamps, like this -
1.  03/04/2014 23:44:57
2.  03/04/2014 23:44:57
3.  03/04/2014 23:44:57

I looked up the formatting for time stamps and
DD:MM: hh:mm:ss.00 is supposed to give fractions of a second, 
but I

don't know how to apply this to the Now() function.

The code I am using to print to the text files is -

   giInit = FreeFile()
   Open D:\LibreOffice\InitfTransEntry.txt for Output as giInit
   Print #giInit, 1.   + Now()

Any suggestions as to how I can format Now(), or should I use a 
different

function to get more accurate timing?

Thanks,

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


On 2 April 2014 00:05, Andrew Douglas Pitonyak and...@pitonyak.org
wrote:

  Sadly, I do not have a definitive answer to your question, but I 
do have

some thoughts... (see inline)


On 04/01/2014 06:57 AM, Marion  Noel Lodge wrote:

  Hi,
In opening my database accounting system, I trigger via the Form: 
When

loading event, a macro, (Sub Init()), containing the database
initialisation routines.

As the Form loads it displays the first record in the database,
including
the account number.   To make things easier for the user, the Text
modified
event on the account number control, triggers a macro, (Sub 
AccName()),

that displays the account name.

  And I assume that this is built into the form.


   Sometimes the system has crashed because it seems that Sub 
AccName()

has

fired before Sub Init() has finished.  (Sub AccName() depends on 
some of

the structures that Sub Init() sets up.)

Is it possible that both Subs are running in parallel or do they 
always

run
in series on a first come first served basis?

  Warning: Speculation... So insert the following text before each

statement
below:  I am making a wild unsubstantiated guess that

1. The form is populated before Init() finishes
2. AccName() is called as soon as text is pushed into the control.

So, if this is the case, then AccName may be called before Init()
finishes. If you really want to know if they run at the same time, 
you
could do a not so quick test and modify each routine so that the 
macro

does
something like this:

Sub Init()
Write current time to a file
delay a second or two
Do the work
delay a second or two
Write the current time

Re: [libreoffice-users] Do Macros run serially or in parallel?

[Andrew Douglas Pitonyak]

Oh, and you can use GetSystemTicks() to return the number of system 
ticks, which should be a better judge of when something occurred. Also, 
if Wait does not work, you can always use a busy wait based either on 
now or GetSystemTicks.


On 04/04/2014 03:23 AM, Fernand Vanrie wrote:

Noel , Andrew,

What system are you running ?

on windows the wait is doing OK

try this code


s1 = 1.   + Now()
Wait(2000)
s2 = 2.   + Now()
msgbox (s1  chr(13)  s2)

s1 an s2 differs from 2 seconds (wait 2000)

Greetz

Fernand

Hi Andrew,

Yes, that is what seems to be happening.  Even if there is a bit of code
between the Wait(2000) and the next Print #giInit, the time is the same.
Only if there is substantial code after the Wait(2000) does the time
change.  For example -
1.  04/04/2014 13:50:24
2.  04/04/2014 13:50:24
3.  04/04/2014 13:50:24
4.  04/04/2014 13:50:24
5.  B4 UpdateFundAndGenLed()  04/04/2014 13:50:24
6.  04/04/2014 13:50:28
7.  04/04/2014 13:50:28

After 5. the Init macro calls another macro.

Something odd seems to be happening with the Wait command. Perhaps I am
missing something.  You can see why I was wanting to get fractions of a
second in the print statements.

Noel

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


On 4 April 2014 03:06, Andrew Douglas Pitonyak and...@pitonyak.org 
wrote:



So, are you saying that you have:


Print #giInit, 1.   + Now()
Wait(2000)
Print #giInit, 2.   + Now()

And it prints the same value for now?



On 04/03/2014 09:12 AM, Marion  Noel Lodge wrote:


Thanks for the replies to my original post.

They gave me something to work on and I have made some progress.  I 
think

that the macros run in series, but I am not yet sure of that.

For some reason the wait(2000) commands that I inserted into the the
macros
don't seem to work and I am getting several lines with the 
identical time

stamps, like this -
1.  03/04/2014 23:44:57
2.  03/04/2014 23:44:57
3.  03/04/2014 23:44:57

I looked up the formatting for time stamps and
DD:MM: hh:mm:ss.00 is supposed to give fractions of a second, 
but I

don't know how to apply this to the Now() function.

The code I am using to print to the text files is -

   giInit = FreeFile()
   Open D:\LibreOffice\InitfTransEntry.txt for Output as giInit
   Print #giInit, 1.   + Now()

Any suggestions as to how I can format Now(), or should I use a 
different

function to get more accurate timing?

Thanks,

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


On 2 April 2014 00:05, Andrew Douglas Pitonyak and...@pitonyak.org
wrote:

  Sadly, I do not have a definitive answer to your question, but I 
do have

some thoughts... (see inline)


On 04/01/2014 06:57 AM, Marion  Noel Lodge wrote:

  Hi,
In opening my database accounting system, I trigger via the Form: 
When

loading event, a macro, (Sub Init()), containing the database
initialisation routines.

As the Form loads it displays the first record in the database,
including
the account number.   To make things easier for the user, the Text
modified
event on the account number control, triggers a macro, (Sub 
AccName()),

that displays the account name.

  And I assume that this is built into the form.


   Sometimes the system has crashed because it seems that Sub 
AccName()

has

fired before Sub Init() has finished.  (Sub AccName() depends on 
some of

the structures that Sub Init() sets up.)

Is it possible that both Subs are running in parallel or do they 
always

run
in series on a first come first served basis?

  Warning: Speculation... So insert the following text before each

statement
below:  I am making a wild unsubstantiated guess that

1. The form is populated before Init() finishes
2. AccName() is called as soon as text is pushed into the control.

So, if this is the case, then AccName may be called before Init()
finishes. If you really want to know if they run at the same time, 
you
could do a not so quick test and modify each routine so that the 
macro

does
something like this:

Sub Init()
Write current time to a file
delay a second or two
Do the work
delay a second or two
Write the current time to a file
End Sub

Use a different file for each subroutine, then compare the start 
and end

time to see if they overlap. You can probably get away with using a
simple
print statement at the start and end.


   If the latter, are there coding techniques that can be used to 
ensure

that


Sub Init() always runs first?

  If things run serially and AccName is called based on something 
done in

Init(), it may be possible that Init() cannot complete until after
   AccName() finishes.


I suppose that another possibility is to set a Global variable 
such as
InitComplete. set to false when Init() starts, and set to true 
when it

completes. Modify AccName to check for InitComplete. If things are
serial,
then you may need to simply return. If not, then have AccName wait 
for a

few seconds and try again. If things are truly serial, then I would
expect
them to fail every time

Re: [libreoffice-users] Intentionally crashing LibreOffice when frozen/LibreOffice will not start.

[Andrew Douglas Pitonyak]

On 04/04/2014 07:44 PM, andrewH wrote:

I am working with a data set that keeps causing my LibreOffice to freeze. I
am pretty sure that this is only because it is big. It is a pipe-separated
text from the US Economic Census imported into Calc, about 30 columns and
around a million rows. (The actual data set is bigger, but Calc quits at a
million-odd. The complete file is about 0.8 gig.) I suspect but can not
prove that this is related to file handling somehow, e.g. breaking down
during auto-saving. The first time I saved the data as a Calc file it took
nearly an hour with the soffice.bin *32 process running at 25 percent of
CPU time and using about 825 meg of memory the entire time. (Not sure why
this is showing up as a 32-bit version).  And when Calc freezes, all the
LibreOffice programs freeze. So I can't just switch to another file and
noodle away while waiting.


It looks to me as though Calc cannot handle more than 1048576 rows of data,

Do you have more rows than that? If yes, then I think that you cannot 
open the file.


If you have less than that, and, if you think that you are simply 
running out of memory if you can figure out how to get the data to 
me, I can run a test on a 64 bit version (running on Linux). My machine 
has 32 GB of RAM...



--
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] Do Macros run serially or in parallel?

[Andrew Douglas Pitonyak]

So, are you saying that you have:

Print #giInit, 1.   + Now()
Wait(2000)
Print #giInit, 2.   + Now()

And it prints the same value for now?


On 04/03/2014 09:12 AM, Marion  Noel Lodge wrote:

Thanks for the replies to my original post.

They gave me something to work on and I have made some progress.  I think
that the macros run in series, but I am not yet sure of that.

For some reason the wait(2000) commands that I inserted into the the macros
don't seem to work and I am getting several lines with the identical time
stamps, like this -
1.  03/04/2014 23:44:57
2.  03/04/2014 23:44:57
3.  03/04/2014 23:44:57

I looked up the formatting for time stamps and
DD:MM: hh:mm:ss.00 is supposed to give fractions of a second, but I
don't know how to apply this to the Now() function.

The code I am using to print to the text files is -

  giInit = FreeFile()
  Open D:\LibreOffice\InitfTransEntry.txt for Output as giInit
  Print #giInit, 1.   + Now()

Any suggestions as to how I can format Now(), or should I use a different
function to get more accurate timing?

Thanks,

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


On 2 April 2014 00:05, Andrew Douglas Pitonyak and...@pitonyak.org wrote:


Sadly, I do not have a definitive answer to your question, but I do have
some thoughts... (see inline)


On 04/01/2014 06:57 AM, Marion  Noel Lodge wrote:


Hi,

In opening my database accounting system, I trigger via the Form: When
loading event, a macro, (Sub Init()), containing the database
initialisation routines.

As the Form loads it displays the first record in the database, including
the account number.   To make things easier for the user, the Text
modified
event on the account number control, triggers a macro, (Sub AccName()),
that displays the account name.


And I assume that this is built into the form.


  Sometimes the system has crashed because it seems that Sub AccName() has

fired before Sub Init() has finished.  (Sub AccName() depends on some of
the structures that Sub Init() sets up.)

Is it possible that both Subs are running in parallel or do they always
run
in series on a first come first served basis?


Warning: Speculation... So insert the following text before each statement
below:  I am making a wild unsubstantiated guess that

1. The form is populated before Init() finishes
2. AccName() is called as soon as text is pushed into the control.

So, if this is the case, then AccName may be called before Init()
finishes. If you really want to know if they run at the same time, you
could do a not so quick test and modify each routine so that the macro does
something like this:

Sub Init()
   Write current time to a file
   delay a second or two
   Do the work
   delay a second or two
   Write the current time to a file
End Sub

Use a different file for each subroutine, then compare the start and end
time to see if they overlap. You can probably get away with using a simple
print statement at the start and end.


  If the latter, are there coding techniques that can be used to ensure that

Sub Init() always runs first?


If things run serially and AccName is called based on something done in
Init(), it may be possible that Init() cannot complete until after
  AccName() finishes.


I suppose that another possibility is to set a Global variable such as
InitComplete. set to false when Init() starts, and set to true when it
completes. Modify AccName to check for InitComplete. If things are serial,
then you may need to simply return. If not, then have AccName wait for a
few seconds and try again. If things are truly serial, then I would expect
them to fail every time, and they don't fail every time, so it is likely
not the case.




If the former, how can I ensure that Sub AccName() waits until Sub Init()
has finished?


Oh wait, see above! :-)




Can someone point me to any articles on this subject?

Thanks,

Noel
--
Noel Lodge
lodg...@gmail.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




--
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] Do Macros run serially or in parallel?

[Andrew Douglas Pitonyak]

Sadly, I do not have a definitive answer to your question, but I do have 
some thoughts... (see inline)


On 04/01/2014 06:57 AM, Marion  Noel Lodge wrote:

Hi,

In opening my database accounting system, I trigger via the Form: When
loading event, a macro, (Sub Init()), containing the database
initialisation routines.

As the Form loads it displays the first record in the database, including
the account number.   To make things easier for the user, the Text modified
event on the account number control, triggers a macro, (Sub AccName()),
that displays the account name.


And I assume that this is built into the form.


Sometimes the system has crashed because it seems that Sub AccName() has
fired before Sub Init() has finished.  (Sub AccName() depends on some of
the structures that Sub Init() sets up.)

Is it possible that both Subs are running in parallel or do they always run
in series on a first come first served basis?


Warning: Speculation... So insert the following text before each 
statement below:  I am making a wild unsubstantiated guess that


1. The form is populated before Init() finishes
2. AccName() is called as soon as text is pushed into the control.

So, if this is the case, then AccName may be called before Init() 
finishes. If you really want to know if they run at the same time, you 
could do a not so quick test and modify each routine so that the macro 
does something like this:


Sub Init()
  Write current time to a file
  delay a second or two
  Do the work
  delay a second or two
  Write the current time to a file
End Sub

Use a different file for each subroutine, then compare the start and end 
time to see if they overlap. You can probably get away with using a 
simple print statement at the start and end.



If the latter, are there coding techniques that can be used to ensure that
Sub Init() always runs first?


If things run serially and AccName is called based on something done in 
Init(), it may be possible that Init() cannot complete until after  
AccName() finishes.



I suppose that another possibility is to set a Global variable such as 
InitComplete. set to false when Init() starts, and set to true when it 
completes. Modify AccName to check for InitComplete. If things are 
serial, then you may need to simply return. If not, then have AccName 
wait for a few seconds and try again. If things are truly serial, then I 
would expect them to fail every time, and they don't fail every time, so 
it is likely not the case.




If the former, how can I ensure that Sub AccName() waits until Sub Init()
has finished?


Oh wait, see above! :-)



Can someone point me to any articles on this subject?

Thanks,

Noel
--
Noel Lodge
lodg...@gmail.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] shutdown glitch

[Andrew Douglas Pitonyak]

On 03/28/2014 11:34 AM, rmg wrote:
Yes, the book also says it's not case sensitive and I have to admit 
I've played fast and loose with case elsewhere without ill effect. And 
anyway the minimalist Goodbye without that still gives the problem.


Case is usually not an issue. I think that with case, you must be right 
on with case for enums the first time that they are used (like when you 
set a font weight to BOLD). I do not know if it matters while specifying 
a an object or service when you use CreateObject or not. Apart from 
that, I am not aware of case issues in Basic.


--
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 to put Basic IDE code completion to work

[Andrew Douglas Pitonyak]

That is the behavior that I have seen :-)

On 03/19/2014 04:23 PM, Fernand Vanrie wrote:

hallo Miklos
thanks but
only  and ( are auto clossing
dot operator is not functioning at all (maybe a keyboard problem ?)
tab do nothing
sub and Function not closing

do i something wrong ?

using Windows 7 (4.2.2.1)

 On Tue, Mar 18, 2014 at 10:26:08PM +0100, Fernand Vanrie 
s...@pmgroup.be wrote:

Found new Basic IDE options in 4.2 , but where to find some
documentation how this new stuff works ?

In worst case, https://speakerdeck.com/vmiklos/gsoc-students-panel
starting from slide 53 talks about this topic.

Gergo, did you have some wiki page or so describing the new features?

Thanks,

Miklos





--
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] Need confirmation about Date type confusions

[Andrew Douglas Pitonyak]

Yep, I see this on Linux as well. Nice little bug. You will notice that 
it fails to compile.


Here is one hack / work around

dStart.year = oevent.source.context.getcontrol(test1).getdate().year
dStart.day = oevent.source.context.getcontrol(test1).getdate().day
dStart.month = oevent.source.context.getcontrol(test1).getdate().month

That said:

Are you just using a whole mess of global variables? For example:

ss = date

Later, you have this:

oevent.source.context.getcontrol(test1).date = cdatetounodate(date)

Now, the problem seems to be related to this not previously defined 
variable date. If you remove that, then your original macros works 
without any other change. So, can you change your variable name from 
date to something else?



On 02/27/2014 04:57 PM, Fernand Vanrie wrote:
Since 4.1 the Date property from a 
com.sun.star.awt.UnoControlDateFieldModel returns no longer a 
Isodate but a Unodate.


Since its stay like that in 4.2 is started to correct all or BASIC 
code who uses a com.sun.star.awt.UnoControlDateFieldModel.


But i runed by accident in a  bug where as soon we have a ss = Date 
(who normaly returns today date as  a string) the Date property of a 
com.sun.star.awt.UnoControlDateFieldModel is corrupted with a BASIC 
syntax error.

Symbol date already defined differently
 as soon i left out the ss = Date the error disappeared
The error is not in 4.0
4.1 ?
The error is there in 4.2 under Windows all versions.

To reproduce the bug run the code below, who opens a dialog. The 
dialog has a Datecontrol who can been filed with todays date using a 
listener on the button.

Run the code and you run in the error
cancel the first row (ss = date ) to run without error

sub testDateError
  ss = date


   oDialogModel = createUnoService( 
com.sun.star.awt.UnoControlDialogModel )

   oDialogModel.PositionX = 10
   oDialogModel.PositionY = 10
   oDialogModel.Width = 100
   oDialogModel.Height = 100
   oDialogModel.Title = test datecontrol
   oDialogControl = createUnoService( 
com.sun.star.awt.UnoControlDialog )

   oDialogControl.setModel( oDialogModel )
   odialogModel = odialogcontrol.model
   oDateModel = oDialogModel.createInstance( 
com.sun.star.awt.UnoControlDateFieldModel )

   oDateModel.PositionX = 20
   oDateModel.PositionY = 20
   oDateModel.Width = 40
   oDateModel.Height = 14
   oDateModel.dropdown = true
   oDateModel.Name = test1
   oDateModel.TabIndex = nNumControls
   oDialogModel.insertByName( test1, oDateModel )
   oDateControl = oDialogControl.getControl( test1 )
   odialogModel = odialogcontrol.model
   oButtonModel = oDialogModel.createInstance( 
com.sun.star.awt.UnoControlButtonModel )

   oButtonModel.PositionX = 40
   oButtonModel.PositionY = 70
   oButtonModel.Width = 60
   oButtonModel.Height = 14
   oButtonModel.Name = pressbuton
   oButtonModel.Label = press to fill with date
   oDialogModel.insertByName( pressbuton, oButtonModel )
   oButtonControl = oDialogControl.getControl( pressbuton )
   oActionListener = CreateUnoListener(pressbuton + _, 
com.sun.star.awt.XActionListener )

   oButtonControl.addActionListener( oActionListener )
   oDialogcontrol.setVISIBLE(true)
   oDialogcontrol.execute()

end sub
sub pressbuton_actionPerformed( oEvent As com.sun.star.awt.ActionEvent )

 oevent.source.context.getcontrol(test1).date = cdatetounodate(date)
dim dStart as New com.sun.star.util.Date
dStart.year = oevent.source.context.getcontrol(test1).date.year
dStart.day = oevent.source.context.getcontrol(test1).date.day
dStart.month = oevent.source.context.getcontrol(test1).date.month
end sub

Sub Main



--
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] large .odt file

[Andrew Douglas Pitonyak]

Can you send the file directly to me off list?

On 02/24/2014 01:07 PM, HValisuo wrote:

I am using libreoffixe
Version: 4.1.4.2
Build ID: 410m0(Build:2)
in openSUSE Tumbleweed.

I am editing a text file of less than 200 hundred A4 pages. The file size
had grown to 7.4MB. (Maybe because I had some stupid style definitions I had
made.)

I saved the file in .html format, exited libreoffice, restarted, read back
the file and saved in .odt format. The new size was less than 250KB. I lost
some of my style definitions but now everything is again OK, maybe even
better than before.

I wonder, if my file could be of any use to the developers.






--
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] opening file via macro failes

[Andrew Douglas Pitonyak]

Download AndrewBase.odt

Listing 41 (ShowFlatDriverArgs) will display the supported arguments. In 
fact, just before the listing, there is a button that you can click in 
the document that will run the macro and display the arguments for you.


The macro may be structured such that the file must exist on disk 
because it calls methods like GetSourceCodeDir and LoadDBLibs. Check it 
out and let us know if you are not able to run it.


I have not looked at this in a few years, so my memory is a bit vague, 
but, it should help


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


On 02/26/2014 11:01 AM, Niklas Johansson wrote:

Hi HP

So first of all I tried your macro with the LibreOffice 4.2.0 and did 
not experience any problems, once I set up a valid url of course. I 
used the following code.


Sub TryToOpenCsvFromTheInternet
   Dim loadArgs2(1) as New com.sun.star.beans.PropertyValue

   lurl = 
http://download.finance.yahoo.com/d/quotes.csv?s=%40%5EDJI,GOOGf=nsl1ope=.csv;

   lsfo = 44/32,34,ANSI,2,

   loadArgs2(0).Name = FilterName
   loadArgs2(0).Value = Text - txt - csv (StarCalc)
   loadArgs2(1).Name = FilterOptions
   loadArgs2(1).Value = lsfo

   lDoc = StarDesktop.LoadComponentFromURL(lurl,_blank,0,loadArgs2())
   lSheet = lDoc.Sheets().getByIndex(0)
End Sub


When it comes to the documentation of the filter options this is 
probably as close as you get:
https://wiki.openoffice.org/wiki/Documentation/DevGuide/Spreadsheets/Filter_Options#Filter_Options_for_the_CSV_Filter 



There is also a simple and effective way to find out different 
options, as described by Villeroy [1]


quote
Open the csv manually with all bells and whistles. Then run the 
following code and copy the FilterOptions.


|Sub showFilterOptions()
Dim args(),i%
   args() = ThisComponent.getArgs()
   for i = 0 to uBound(Args())
  if args(i).Name = FilterOptions then inputbox 
args(i).Name,,cStr(args(i).value)

   next
End Sub|
end of quote

[1] http://140.211.11.67/en/forum/viewtopic.php?t=58105p=256500#p256500

Med vänlig hälsning
Niklas Johansson

HP4 skrev 2014-02-25 16:57:

Hi,
I can't find any information on how to set the arguments for
LoadComponentFromURL when loading a csv-file via macro over the 
network.

The example below worked fine with OpenOffice some time ago, but yields
exceptions when running it with LibreOffice because the function call
returns a NULL pointer. So my question:

- where can I find a list of valid filters for LibreOffice?
- what arguments do I have to provide to read csv-files?

The available documentation in the API on how to supply these 
arguments is

useless when it doesn't provide the allowed values or a hint how to
construct them. Also I couldn't find any helpful information via Google.

BR
HP

Sub Main
Dim loadArgs2(1) as New com.sun.star.beans.PropertyValue

lurl = http://domain.org/file.csv;
lsfo = 44/32,34,ANSI,2,

loadArgs2(0).Name = FilterName
loadArgs2(0).Value = Text - txt - csv (StarCalc)
loadArgs2(1).Name = FilterOptions
loadArgs2(1).Value = lsfo

lDoc = StarDesktop.LoadComponentFromURL(lurl,_blank,0,loadArgs2())
lSheet = lDoc.Sheets().getByIndex(0)
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] Re: Basic IDE Right Click

[Andrew Douglas Pitonyak]

So the problem was likely related to your user profile... If the problem 
occurs again, try renaming your user profile while LO is not running and 
then restart LO.


On 02/26/2014 05:10 PM, Bill Martin wrote:

Thanks for the pointer Tom, but that doesn't seem to make any difference.

So for no good reason I went in and uninstalled Libre from the XP machine
which seemed to take a /lng/ time, but eventually completed as expected.
No error messages.  It left tons of files laying around the machine though
so I manually deleted everything I could find.  Then I rebooted XP.

Finally I downloaded fresh install files from LibreOffice.org (4.2.1.1) and
reinstalled them.  At that point things seem to work properly.  I'll have to
use it some to verify, but the original problem is resolved.

Thanks.

Bill



--
View this message in context: 
http://nabble.documentfoundation.org/Basic-IDE-Right-Click-tp4098726p4099206.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] HOW CAN I CONVERT A NUMBER IN LibreOffice CALC TO TEXT IN LibreOffice CALC?

[Andrew Douglas Pitonyak]

On 02/22/2014 04:41 PM, Tanstaafl wrote:
It is called bottom or in-line posting, and is preferred by the more 
technically inclined.


Bottom and Top posting seems to be a personal preference often pursued 
with religious zeal (as you mention below). While quickly browsing, top 
posting is easier to follow unless your email client hides all previous 
posts for you. I installed an extension to do this in Thunderbird; 
without it, bottom posting is almost impossible to follow. The extension 
makes it easy to follow ongoing conversations regardless, but is 
annoying if you were not following things from the start and want to 
catch-up :-(


in-line posting seems to be assumed for Thunderbird. Makes the response 
more like a conversation.


It is primarily Outlook users who prefer blind top-posting (ie, 
quoting the entire message they are replying to and adding their 
comment at the top).


You must work hard to get Outlook to do anything else. I know you used 
to be able to convince Outlook to do otherwise. I don't even know if you 
can still do that. Every time MS releases a new version of something 
these days, it usually feels like I need to relearn the product. It 
annoys me.


My limited exposure says that every large company using Outlook likely 
works in this way.


Most people who are rabidly anti bottom/inline posting will go out of 
their way to complain about how bad bottom posting is, and will 
invariably use BLIND bottom posting - quoting the ENTIRE message ABOVE 
your comment, which is admittedly way WORSE than blind top-posting - 
as examples of why bottom/inline posting is bad. They almost always 
simply refuse to even acknowledge the difference between BLIND bottom 
posting, and inline posting (quoting only the relevant portion, and 
putting your responses/comments AFTER the relevant quoted text, which 
is much cleaner and easier to read than even top-posting, mainly 
because you can clearly see the full context).


You can make everyone angry and happy by doing both. Place your entire 
message at both the top and the bottom :-)


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

[Andrew Douglas Pitonyak]

On 02/19/2014 04:08 PM, Bill Martin wrote:

I've tried to implement the simple example shown in the Calc Help system for
the Declare Statement.  Somewhere it expects to find a file: user32.dll but
I have no idea where to find it.  Windows has  many user32.dll files for
it's own use  but presumably none of them are relevant to LibreOffice.The
file does not seem to be included in the DLL files that install with Libre.
So does it need to be downloaded from the web somewhere and manually
installed?I'm just trying to understand how to link Basic to a DLL file so I
can go off and do something more complex.   Thanks.Bill


The point is that the user32.dll file is not relevant to LibreOffice, 
yet you should be able to call methods in it.


What is your operating system? Obviously it is Windows, so, which 
version of windows? 7, 8?


What error do you receive if you try to run the following macro?

Declare Sub MyMessageBeep Lib user32.dll Alias MessageBeep ( Long )
Declare Function CharUpper Lib user32.dll Alias CharUpperA_
   (ByVal lpsz As String) As String

Sub ExampleCallDLL
  REM Convert a string to uppercase
  Dim strIn As String
  Dim strOut As String
  strIn  = i Have Upper and Lower
  strOut = CharUpper(strIn)
  MsgBox Converted:  CHR$(10)  strIn  CHR$(10) _
 To:  CHR$(10)  strOut, 0, Call a DLL Function
  REM On my computer, this plays a system sound
  Dim nBeepLen As Long
  nBeepLen = 5000
  MyMessageBeep(nBeepLen)
  FreeLibrary(user32.dll )
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] LO Base: MySQL or Mariadb ?

[Andrew Douglas Pitonyak]

I have seen nothing that indicates that you cannot use Maria DB as a 
drop-in replacement for MySQL at this point.


Last I tried it was with Drupal 7. It just worked. I expect the same for 
Base, if it is not so, file a bug report against Maria DB.


--
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] LO Base/MySQL questions

[Andrew Douglas Pitonyak]

On 02/07/2014 09:07 AM, Ian Whitfield wrote:

Sorry All

I'm running PClinuxOS (latest) and LO 4.1.2.3 and MySQL 5.1.55

A MySQL 'expert' was telling me recently that HSQL is only meant to be 
a prototyping utility and should *NEVER* be used for any proper work 
- - interesting!!??


I can confirm that when it crashes it takes everything with it so you 
have to backup every time you make change. This is what forced me to 
MySQL.


Thanks again


I had a lot of trouble a while back, so I stopped using it and started 
writing my own program in C++. Of course, this is time consuming, but it 
is something I enjoy doing.


That said, I did write some things through MySQL with no problems.

--
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] LO Base/MySQL questions

[Andrew Douglas Pitonyak]

On 02/07/2014 02:38 AM, Ian Whitfield wrote:


Hi All

I've been using the Base/MySQL combination since mid-last year now and 
it is fantastic!! It is much faster, never crashes or freezes and just 
works the way it is supposed to. I can definitely recommend it to 
anyone!! (In my opinion this should be the standard and HSQL should be 
dropped)


The advantage of HSQL is that it creates a single file and you do not 
need to run a database daemon in the background (I am assuming that the 
MySQL connector uses that rather than knowing how to read the MySQL 
files directly).  In other words, it does serve a need.


The disadvantage of HSQL, (speculation, so assume half of what I am 
about to say is wrong) is that it sounds less stable, if you crash Base, 
it is more likely to lose data, and everything stays in memory.




Now I have a couple of questions...

1) Where does MySQL store the Database? (I think it's in the root 
somewhere)


Are you using Windows or Linux? Try looking under something like:

C:\Program Files\MySQL\MySQL Server #.#\my.ini

Look in that file for the basedir and datadir variables.

And now I see I need to run.


2) Is it easy to move it into the /home directory?
3) Where do I find the LO front-end form?
4) If I copy these two files to another machine will I be able to get 
the Database running on this second machine?


Side question

I have a couple of graphics/photos in each record - Is it possible to 
'Link' these instead of embedding them so that if you up-date a photo 
it will automatically update in the Database? If this is possible will 
it effect Base at all? (faster, slower etc)


Thanks for any help

IanW
Pretoria RSA.



--
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: North America Touching Basis

[Andrew Douglas Pitonyak]

I popped on over to the Cincinnati when Jean Webber (documentation team) 
was there for a conference so that we could have lunch. It was nice to 
finally meet her in person :-)


On 01/29/2014 09:58 PM, Ruth Ann wrote:

Hi Joel,
Well, I am in the Mid-west, so it would be kind of far to travel just 
to say Hello, but I would be happy to help if there is something you 
think I can do.

Ruth Ann, in Ohio, USA

On 1/29/2014 8:55 PM, Joel Madero wrote:

None right now - honestly we're not even close to that point and that's
why this is going so far off topic that it's become quite frankly a
waste of my time. I have sent out emails over the last 2 years trying to
encourage participation from North American users - we have some, not
nearly enough and yet now the conversation has turned into something
quite different. Once we see a solid force of people who are
contributing consistently then we can discuss locations.

That being said - the idea was to just say hi to my North American
colleagues and see if anyone had some spare cycles to help QA out with
the endless tasks we have. So, if someone is interested in helping ping
me privately and I'll help you get started. No development skills are
needed.


Best,
Joel






--
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: North America Touching Basis

[Andrew Douglas Pitonyak]

QA is a great place to start You can jump in when you have time, you 
become familiar with different features, and it is a huge help...


You will probably enjoy it Ruth Ann. Good of you to help her through it 
Joel!


Do we have a FAQ or WIKI page to help people become involved in the QA 
process?


On 01/29/2014 10:49 PM, Joel Madero wrote:

I got in touch with Ruth Ann privately and am helping her get involved
with QA and will do so with anyone else who wants to productively help.


Best,
Joel




On 01/29/2014 07:34 PM, anne-ology wrote:

Ruth Ann - you're definitely not alone,
but I guess they're not interested in hearing from us in the
mainland  ;-)



From: Ruth Ann came...@gmail.com
Date: Wed, Jan 29, 2014 at 8:58 PM
Subject: Re: [libreoffice-users] Re: North America Touching Basis
To: users@global.libreoffice.org


Hi Joel,
Well, I am in the Mid-west, so it would be kind of far to travel just to
say Hello, but I would be happy to help if there is something you think I
can do.
Ruth Ann, in Ohio, USA


On 1/29/2014 8:55 PM, Joel Madero wrote:

  None right now - honestly we're not even close to that point and that's

why this is going so far off topic that it's become quite frankly a
waste of my time. I have sent out emails over the last 2 years trying to
encourage participation from North American users - we have some, not
nearly enough and yet now the conversation has turned into something
quite different. Once we see a solid force of people who are
contributing consistently then we can discuss locations.

That being said - the idea was to just say hi to my North American
colleagues and see if anyone had some spare cycles to help QA out with
the endless tasks we have. So, if someone is interested in helping ping
me privately and I'll help you get started. No development skills are
needed.


Best,
Joel






--
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: North America Touching Basis

[Andrew Douglas Pitonyak]

On 01/29/2014 08:22 PM, Joel Madero wrote:

On 01/29/2014 05:07 PM, anne-ology wrote:

Andrew, well said.

Joel, ... [see my comments below, interspersed within Andrew's]

Um honestly I don't have the time. Sorry but first line made me realize
how far off point this is getting.

All in all, this is about the project and whatever it takes to build the
project in North America. If you or anyone else wants to try to have a
conference/meet and greet somewhere feel free to lead the charge.

All the best,
Joel



One of my strategies has been to take note of specific computer 
conferences that are hosted in the area, for example, Linux Fest. I have 
managed to assemble some people at previous Linux Fest gatherings in 
Columbus Ohio (but I could not attend the conference in 2013, first one 
I missed). I have met some interesting people.


It does not pull people in from far away that would not be in the area 
already, but, some of the people are willing to travel for the 
conference a bit and then meet. I will see if I can make that happen in 
2014 again.


Will see how many of those close to Ohio are willing to meet-up for that :-)

--
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: North America Touching Basis

[Andrew Douglas Pitonyak]

On 01/29/2014 04:35 PM, Joel Madero wrote:

On 01/29/2014 11:38 AM, anne-ology wrote:

Pacific coast then Atlantic coast then Pacific coast -
yet there's a couple thousand miles in between;
seems to me, if you really wanted our participation - and help,
financial  otherwise - you'd meet somewhere in between ... ... ...  ;-)

Well the reality is the population density is on the coasts (for the
most part) so events happen on the coasts.

Best,
Joel



But the Largest US Cities are generally not on the coast (which does not 
make your statement wrong).


1. New York City
2. Los Angeles
3. Chicago
4 Houston
5 Philadelphia
6, Phoenix
7. San Antonio

In fact, if I list the top 20, there is a very small number on the coast.

There is a large tech population in California, I will give you that 
much.


If you want to hit the largest population (east coast) with the smallest 
average travel distance, you pick the middle of Ohio (Columbus, Ohio).


I think that what you really want is:

1. Easy / cheap air fare to the location
2. Affordable lodging and food

What I have not bothered to figure out if (1) means you want to choose 
an airline's hub city, which increases the odds that you will have a 
direct flight, or, if you want a city that is not a hub since the 
airline often charges more for direct flights. I remember considering 
leaving from Detroit Michigan to fly to Florida, but, it was cheaper for 
me to use a connector into Detroit before getting on that same flight to 
Florida.


--
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] Deleting Table Column Causes Whole Table To Dissapear

[Andrew Douglas Pitonyak]

On 01/27/2014 09:16 AM, Tom Robinson wrote:

Hi,

I'm new to Libreoffice (I'm using it in Windows 8.1).

I tried to delete columns in an existing table created under OpenOffice (in 
Windows XP), and this causes the whole table to be dissapear. Would appreciate 
any advice.

Thank's.
I do not have a good answer, but I have had a bit of experience. I have 
not worked directly with Base in a while, so my information may be 
outdated. All of my comments as they relate to your question are based 
on using Base with the internal HSQL database, and not while connection 
Base to an external DB such as MySQL.


I vaguely remember that using the GUI I was not able to drop a column. 
When I did need to do this, I created a new table with the columns that 
I desired and I copied all of the old data into the new table using a 
single SQL statement. I never attempted to drop a column using a SQL 
statement (as opposed to using the GUI).


Especially since you experienced data loss, be sure to keep backups of 
your documents; always!


--
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: Recalc cell(filename) [partially solved]

[Andrew Douglas Pitonyak]

So, are you using Apache OpenOffice (AOO) or LibreOffice (LO)? I only 
ask because you posted to the LO group about a bug you reported in 
AOO Not that I have not done similar things given that I subscribe 
to both mailing lists.





On 01/15/2014 12:56 AM, James E Lang wrote:

Related bug report: AOO Bug 68188



--
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] State of password support.

[Andrew Douglas Pitonyak]

Thanks for the link

On 12/19/2013 01:05 AM, Massimo Del Zotto wrote:
2013/12/18 Andrew Douglas Pitonyak and...@pitonyak.org 
mailto:and...@pitonyak.org


You mean recently?As in the latest version of LO has a problem
with passwords?

 No, I am referring to OOo. I am considering to switch to LO because 
of this problem and I'm trying to figure out if this problem is 
considered more important by LO developers.



Oh, I had not considered that you were using OOo.

As a side note, I had never considered that any of them did not take 
passwords seriously.


I don't take any of the volunteer responses as not taking it seriously, 
just super technical (almost to the point of silly when it is mentioned 
that while displayed, it is not encrypted in memory  or something 
like that).




2013/12/18 Andrew Douglas Pitonyak and...@pitonyak.org 
mailto:and...@pitonyak.org


Which forum, do you have a link to the post?

This was in the OOo forum, 
https://forum.openoffice.org/en/forum/viewtopic.php?f=9t=65690.
I'm not well aware how the forum admins interact with the OOo 
developer base, it looks to me they don't. I'd say this is another 
problem in itself but luckly, I'm not really interested in that one.


You will notice that the forum admins are all listed as Volunteer. 
None of the people in question likely have any official association with 
OpenOffice. To my knowledge, they are simply people that help by 
answering questions and they may have some level of moderator 
capability. In my mind, an Admin has the ability to help with certain 
user issues or in literally maintaining the system.



Massimo, you seem to be more informed of this than I, but, I am
only aware of one (what I consider) real bug that existed with LO
and passwords. At one point, I was no longer able to open a
password protected file. Specifically, one version of LO was not
able to open a password protected file.  I am pretty sure it was
LO and not AOO anyway. 


[...omissis...]

Thank you very much Andrew, this is very informative. I'm currently 
inclined to switch to LO.


I only remember one glitch with respect to passwords, and that was just 
related to an inability to open anything with a password. They fixed 
that pretty quickly.


There is some issue related to crashing it seems, but, that is really 
tough to diagnose and fix. it might even be related to something very 
difficult to fix even if you do know the problem (like a saved temporary 
file is stored without encryption). Oh, I see that MaxDZ8 states this.


I think that the real way to obtain a fix for this is to create a test 
case that is reproducible. something like manually killing OOo while it 
is running. You will need to do this with a recent copy of LO or AOO 
rather than with OOo for the bug report to be of any use. It is that 
reproducible thing that is really tough. If you cannot reproduce it, you 
are not likely to be able to fix it unless you are very lucky.


--
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] State of password support.

[Andrew Douglas Pitonyak]

On 12/17/2013 10:12 AM, Massimo Del Zotto wrote:

However, I recently had a problem with OOo password protection. Somehow it
disabled password protection for a file I was working on and it took me a
while to restore it. Asking for help on OOo forum, I have been informed
password protection is somehow considered unnecessary by... I don't know
who to be honest.


You mean recently?As in the latest version of LO has a problem with 
passwords?



The forum administrator strongly
suggested me to not use it, and even pointed out a few previous cases in
which password protection caused data loss (!!!).

Which forum, do you have a link to the post?


I think *this is unacceptable *so I started looking more seriously at LO.
Digging the mailing list archives, I noticed there are quite a few messages
regarding password protection. It seems most problem were between keyboard
and chair, the only exception being perhaps an inter-operability problem
after switching to AES-256.

In your experience, how is LO with password protection?
Massimo, you seem to be more informed of this than I, but, I am only 
aware of one (what I consider) real bug that existed with LO and 
passwords. At one point, I was no longer able to open a password 
protected file. Specifically, one version of LO was not able to open a 
password protected file.  I am pretty sure it was LO and not AOO anyway.


I believe that I have seen things such as:

1. I forgot my password, how I open my document
2. I am not able to open a password protected document created by MS Office
3. Problems signing a document

I don't ever remember anyone saying that password protection should be 
dropped. Does not mean that it has not been said. I have seen people 
pushing to drop the ability to write non-ODF format, but I don't 
remember anyone advocating no support for passwords.


I have also seen reports of another bug that sometimes causes total data 
loss of a file, but, since it is not reproducible in any sort of 
meaningful way, the bug has not been researched.


--
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] Anchoring frames to paragraphs vs. to characters

[Andrew Douglas Pitonyak]

On 11/30/2013 05:17 PM, Kevin O'Brien wrote:

I am having trouble understanding the difference between these two
options. I think I get anchoring to a page, and anchoring as a
character is pretty clear. But I have not yet grokked how to paragraph
and to character are different. Can anyone enlighten me?
I believe that anchoring to a paragraph is the same as anchoring to the 
first character in the paragraph. If you anchor to a character, then you 
can be certain that it will be on the same page as the character. 
Consider a few operations.


Merge two paragraphs:

BEFORE:
par 1
[ANCHOR] par 2


AFTER:
[ANCHOR] par 1 par 2

If I am anchored to a paragraph, if I insert two pages of text to the 
front of my paragraph, the frame will not move because the location of 
the first character in the paragraph did not move. The same is not true 
if the frame is anchored to a specific character.


I have no idea, off hand, how to anchor a frame to a specific character; 
but if I was creative, I could probably figure it out!


--
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] How-to draw Square around math/formula??

[Andrew Douglas Pitonyak]

can you insert the formula into a frame and then give the frame a border?

On 11/30/2013 05:01 PM, Gary Kline wrote:

Organization: Thought Unlimited.  Public service Unix since 1986.
Of_Interest: With 27 years  of service  to the  Unix  community.


hi guys,

I've tried everything I ccan think of [ besides asking various
lists ]  without any luck.  what I am trying to do *seems* simple,
but no-joy.

I have a simple equsion that I want to put INSIDE a square.  can
any libreoffice wizards clue me in?

(The formula string is simply:

int from a to R lim R rightarrow infinity

and you guys can imaging what that outputs. )

How, then, do I get libreoffice|formula to create a
medium-thickness square that I can save as, say, Integraly.pdf.

tia,

gary kline




--
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] Detailed information on frame positioning Writer

[Andrew Douglas Pitonyak]

On 11/30/2013 08:38 PM, Kevin O'Brien wrote:

Is there a source for detailed information on frame positioning in Writer?

Thanks,


Let me provide some context around Mr. O'Brien.

1. He is very smart.
2. He is well versed with OpenOffice. Sufficiently well versed, that I 
have seen him (in person) teach detailed classes on OpenOffice.


In other words, I assume that he has looked in the obvious places. That 
said, and because Mr. Drescher asked, consider this link:


https://wiki.documentfoundation.org/images/9/96/WG40-WriterGuideLO.odt

When I look at this document, Frames begins on page 120.

The anchoring information is on page 123 and it is well written, and has 
the following relative to paragraph and character.


*To Paragraph*

The frame is associated with a paragraph and moves with the paragraph. 
It may be placed in the margin or another location. This method is 
useful as an alternative to a table for placing icons beside paragraphs. 
It is also used to center text on a page in documents which will be used 
in a master document (frames anchored to pages will disappear from the 
master document).


*To Character*

The frame is associated with a character but is not in the text 
sequence. It moves with the paragraph but may be placed in the margin or 
another location. This method is similar to anchoring to a paragraph.




--
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] Detailed information on frame positioning Writer

[Andrew Douglas Pitonyak]

On 12/01/2013 04:41 PM, Regina Henschel wrote:


you can look into the spec
http://docs.oasis-open.org/office/v1.2/os/OpenDocument-v1.2-os-part1.html#__RefHeading__1418758_253892949 




o, smart! I had not considered looking at the spec! :-)

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

[Andrew Douglas Pitonyak]

https://wiki.openoffice.org/wiki/Documentation/How_Tos/Calc:_FV_function



On 11/27/2013 07:12 PM, Dave Liesse wrote:
I've had troubles in the past finding specific financial functions, as 
well.  Can't help from the function standpoint in this case, but you 
could always fall back on the actual equation:


FV = PV*(1+i)^n

where FV is future value, PV is present value, i is the periodic 
interest rate, and n is the number of periods.


Dave



On 11/27/2013 15:10, Cliff Scott wrote:
I haven't done much spread sheet formula work so please don't mind a 
couple

of simple questions.

I would like to do two things:

1. Calculate compound interest on an amount given the rate and number of
interest periods. Looking at the list of functions there are lots of 
ones
that come close to that, but I wasn't able to find one that would do 
exact

that.

2. How do I write a conditional loop in Calc? If I want to calculate a
formula for 10 iterations how would I do that? For instance
Value=Value*N+Value. That would give me the compound interest also. I 
can do

it with a bunch of cells strung out each one representing one interest
period, but for any length of time it becomes unwieldy.

Thank you very much for any help.

Cliff






--
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] Bugs and Issue

[Andrew Douglas Pitonyak]

On 11/21/2013 12:52 AM, McDennis Cabatingan wrote:

I have this document that has a textbox that I rotated to 90degrees

and everytime I save it to .Docx or .xlsx to send it to my Boss

the text box I rotated is not rotated.

  


I already gone to several check and found out the it will occur only every
time I convert my file to .xlsx or .docx.

Mark,

I opened a bug for you...

https://www.libreoffice.org/bugzilla/show_bug.cgi?id=71876

Perhaps you can create an account and attach a sample document and also 
add extra information such as the version of LO that you are 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

Re: [libreoffice-users] Re: Templates with pop up variables in Writer

[Andrew Douglas Pitonyak]

On 11/15/2013 03:39 AM, Stefan Gruber wrote:

Hello,

John Meyer schrieb:

Basically, I want two things:  One capture two pieces of
information (Name and date) and second, insert both variable
into pre-set fields. The date I want to go into a field in the
format Day, Month Name, Year but I want to accept it in
MM/DD/ format.

For Variables you can easily insert input fields or input lists
into a template. They will popup automatically when you create a
new document from this template.

Rethink the need of reformatting the date variable, because you
will need macro coding then. What about asking for day, month,
year independently?

HTH
Stefan


If you are looking to create the document creation date, will it suffice to:

Insert  Fields  Other  DocInfo  Created

And then you can insert the Date and / or Time. I think that this is the 
date that the document was created from the template, and then, you need 
not prompt the user.




--
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] Customize an index

[Andrew Douglas Pitonyak]

Sadly, I believe that it is not possible to do this directly.

The following link discusses this:

https://forum.openoffice.org/en/forum/viewtopic.php?f=7t=1227



On 11/12/2013 05:12 PM, MENGUAL Jean-Philippe wrote:

Hi,

I want to have an lexical index. Mine is a somewhat particular as, in 
general, one keyword refers to one place in the book (one sentence, 
one chapter). So, instead of having only Keyword Tab page number, 
I'd like that Keyword or page number to be an hyperlink, such as 
it is with a table of contents.


If it's not possible in the core feasnve, does an extension exist or 
some way to do that? I'm frustrated so far because I need to do a 
classical index, then the same with hyperlinks refering to marks, 
etc. it's not convinient at all!


Thanks for your help.

Regards,




--
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] HELP: Frame placement, wrapping, and collision

[Andrew Douglas Pitonyak]

You may have some control if you change how your anchor your frames. For 
example, if you anchor as a character, but then you cannot move it 
around at will.


On 11/07/2013 06:47 AM, Adam Tauno Williams wrote:

Version: 4.1.2.3:build410m0

I have a document with many examples and illustrations.  These are
typically in frames.  I also place tables in frames.

But frames seem to 'flow' *very* poorly.  They may often even end up
overlapping each other and then their placement must be manually
tweaked.  This is very frustrating in a 500+ page document.

Frames seem to wrap with *only* the body text of the document and do
nothing to avoid colliding with each other.

Is there some option I am not setting or some style/technique to get
frames to try to fit naturally into the flow of the text.  Anchor to
paragraph is my typical method; but it seems I really need an
anchor-to-paragraph-getting-as-close-as-you-can option without either
crashing into other frames or leaving a blank inch and a half on the
previous page.



--
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] Working sheet Macro file path

[Andrew Douglas Pitonyak]

Forwarding Heena's response back to the list.

I don't believe that this is possible, but, if I am wrong, someone on 
the list may know.


On 10/29/2013 12:01 AM, Heena Gupta wrote:

Hi,


I want to know the path of the library that contains the macro that is 
currently running.. If anybody knw, plz let me knw...



On Tue, Oct 29, 2013 at 4:51 AM, Andrew Douglas Pitonyak 
and...@pitonyak.org mailto:and...@pitonyak.org wrote:


On 10/28/2013 03:54 AM, Heena Gupta wrote:

Hi,

Can anyone tell me how to get the path of current working
sheet macros file
or library through macro ?

Thanks  Regards,
HEENA GUPTA


Can you clarify your question? Specifically, are you asking:

1. What is the path to the current document (easy, it is available
from ThisComponent)
2. Where are my macros usually stored (also easy, but I would need
to look up how to get it, probably from the configuration provider)
3. What is the path to the library that contains the maro that is
currently running (no idea if that is possible)


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

mailto:users%2bunsubscr...@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




--
HEENA GUPTA
09811963647


--
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] Working sheet Macro file path

[Andrew Douglas Pitonyak]

On 10/28/2013 03:54 AM, Heena Gupta wrote:

Hi,

Can anyone tell me how to get the path of current working sheet macros file
or library through macro ?

Thanks  Regards,
HEENA GUPTA



Can you clarify your question? Specifically, are you asking:

1. What is the path to the current document (easy, it is available from 
ThisComponent)
2. Where are my macros usually stored (also easy, but I would need to 
look up how to get it, probably from the configuration provider)
3. What is the path to the library that contains the maro that is 
currently running (no idea if that is possible)



--
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: Modified Flag Set / No Changes

[Andrew Douglas Pitonyak]

I have at least one file that does this. It is a DOCX file. Anything I 
say is a guess, but


When a file is stored on disk, things such as page numbers may be stored 
in the file, but, in LO, the data does not determine things like the  
page number; the view controller portion determines this. So, when you 
open a document, it shows things such as page numbers as they were 
stored in the file, but, these are recalculated after the document has 
been loaded. I believe that there are numbers field types that do this 
(for example, figure numbers).


I have loaded long documents, jumped to the middle of the document, and 
a few seconds latter, literally see the page number change in front of 
me. This was some time back and I don't remember what document I was 
dealing with...


So, why would page numbers and such change? there are many reasons I 
suppose. Your computer may have a slightly different version of the font 
specified in the document. I see this a lot when a Microsoft Specific 
font is used and I load the document on a Linux System that either 
substitutes the font (because it does not have the one specified) or it 
has one by the same name that is not really exactly the same (such as 
Courier).


I seem to remember an option that I used to see but don't remember 
seeing recently about formatting for printer fonts or something, might 
be related to that.


Especially if the document was not last edited in LO, there may be 
different pagination rules in LO than in something like Word.


Understanding what has changed is probably tricky at best without 
comparing the generated documents on the system that reports the change 
and the original system used to create the document. I suppose it is 
even possible that it does not know for certain if things have changed, 
but I am just guessing.



On 10/22/2013 05:27 PM, David Gast wrote:

Thanks to all who replied.  Perhaps I was not clear.  I am trying to find out 
why the Modified Flag
would be set if I have made no changes.  What objects can LibreOffice Calc 
*silently* modify when starting
up that would cause the modified flag to be set?

While I can copy the files to a computer at home and try different versions, it 
would not actually be useful
for my purposes (perhaps someone on the list wants to know, however).  If some 
file opened without change
in another version of LibreOffice Calc, then it might mean that the file was 
created in that version.  That would
obviously be unacceptable if the exam was to be done in the lab using a 
particular version.

Unfortunately, the lab is public space (for many classes) and I do not
the authority  to modify what the technicians call the lab load in
the middle of a semester.  We will update to the latest version in early 
January.

Best regards,

David Gast

From: David Gast [david.g...@csulb.edu]
Sent: Monday, October 21, 2013 12:33
To: users@global.libreoffice.org
Subject: [libreoffice-users] Modified Flag Set / No Changes

Hi
Perhaps you can help.

My students submit examinations done in LibreOffice Calc to a web page.
I bundle them up and download them to a Windows XP box running
LO Version 3.6.4.3 (Build ID: 2ef5aff).  In previous semesters, an older
version was used.  There were no problems like this in previous semesters.

This semester close to one third of the submitted examinations are
being modified when opened by me for grading.  I confirmed by

   1. Open file (usually from the Cygwin command line, but also from Recent 
Documents)
   2. Immediately clicking the X close icon in the upper right hand corner.
   3. A message pops up asking whether I want to change, dismiss, or cancel.

I typed nothing, yet if I cancel, and then do a save-as, the saved-as file is 
different.

I have two hypotheses.

#1)
RANDBETWEEN() is used this year in some problems, perhaps it sometimes causes 
this
problem.  I cannot recreate that behavior, however.  Further, Compare document 
shows no
differences, nor does oodiff.

#2)
Some students did work outside of class and the version they used is not 100% 
compatible
with the version in the labs.  My reasoning is that I found in one submittal (I 
have not checked
all of them to this level of detail) that one of the fonts changed from 
something like
New Times Roman1 to New Times Roman.   (I used unzip and then a script to 
split the
various files into lines so that diff produced useful output.)

Any advice?  Is it possible to determine what LO is changing?

Best regards,

David Gast







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

Re: [libreoffice-users] Macro issue

[Andrew Douglas Pitonyak]

On 10/22/2013 01:35 AM, Heena Gupta wrote:

Hi guys,

  When i run the MS Excel macro in libre office, it runs correctly but shows
the output while clicking on the cell on which output comes.


Option VBASupport 1
Sub Button1_Click()
Dim a As Integer
Dim b As Integer
Dim c As Integer
Range(B1).Select
a = ActiveCell.Text
Range(B3).Select
b = ActiveCell.Text
c = a + b
Range(B8).Select
ActiveCell.FormulaR1C1 = c
End Sub

Thanks  Regards,
  Heena Gupta


Are you saying that the screen updates while your macro runs?

To quote Bernard Marcelly: (see 
http://forum.openoffice.org/en/forum/viewtopic.php?f=20t=42396)


Freezing screen is done with method lockControllers() of the document's 
Model.

Freezing recalculations is done with method addActionLock() of the document.
With Basic it's simple:

|myDoc = ThisComponent
myDoc.lockControllers()
myDoc.addActionLock()
' --- modify your cells here ---
myDoc.removeActionLock()
myDoc.unlockControllers()|

If you are asking what I think you are asking, you would only lock and 
unlock the controller and not use the action lock.


--
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] LO Base Sub Forms

[Andrew Douglas Pitonyak]

If I remember correctly (and I have not looked at this in a while), I 
think that you need to link the master and slave fields.


So, if you open your form in edit mode, load the form navigator, right 
click on your sub-form and choose properties, navigate to the Data tab, 
do the values in the Link master fields and Link slave fields look 
right to you?



On 10/15/2013 08:09 AM, Ian Whitfield wrote:


Hi All

I'm still stuck with LO Base Sub Forms!! I've been at this for some 
time, off and on, but over the past few months I have been very busy 
converting, editing and checking/updating my DB to now run on MySQL.

I must say it is a GREAT improvement!!

OK - My OpSys is PClinuxOS 2012-10. LO 4.1.1.2, MySQL 5.1.55

I have three tables in my DB - 'Members', 'Story', 'eMails'.
I have one Main Form Members (that references the 'Members Table) 
AND contains a Sub Form eMail (that references the 'eMail' Table). 
Also on the Main Form is a Button that should pop-up, over the Main 
Form, a Story Form that references the Story table).


All the individual Tables and Forms work well on their own - BUT ...

The eMail Sub Form does not link to the individual Members record 
and cycle with each record so I can not add info to this Sub Form that 
will be linked with the correct record.

The Button does not work at all!!

I have worked on this so many times off and on that I'm now rather 
confused on how to go about it or what I did before.


My 'eMails' Table contains the fields - MessageID, Date, In/Out, 
Title, Message. ID (My Foreign Key)
My 'Story' Table contains the fields - StoryID, Story, ID (My Foreign 
Key)


If I remember correctly I created the eMail Sub Form at the time I 
laid out the new Data Base and under the Button properties I currently 
have When pressed - Standard.Story.OpenForm (document, Basic)


Can someone help me out of this mess???

Thanks for ANY help.

IanW
Pretoria RSA




--
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] [CALC] row_only and column_only cell references

[Andrew Douglas Pitonyak]

On 10/12/2013 07:55 AM, Ady wrote:

Hello,

I've been having problems with certain type of *references* in Calc.

For example, the formula sum(1:2) works correctly in other
spreadsheet software, but it errors in Calc.


I was not aware that you could do that in any product. It is not 
supported in Calc of which I am aware. Villeroy has a messy solution 
(see post 6). Well, you probably should read all the posts...


http://forum.openoffice.org/en/forum/viewtopic.php?f=9t=9527

So, the ony soltions I have seen based on a quick search is to either 
define a range, or to use offset.




The most problematic cases are related to functions such as
indirect(), address() and the like. For example, the following
formula should tell whether a number in A1 is prime or not:

=SUMPRODUCT(1*(MOD(A1,ROW(INDIRECT(1:INT(A1^0.5=0))=1

but Calc doesn't seem to accept the type of reference
(ini_row:fin_row). Instead I have to add a column to the
reference, as in:

=SUMPRODUCT(1*(MOD(A1,ROW(INDIRECT(a1:aINT(A1^0.5=0))=1

to make it work in Calc.

There are several settings that affect the way Calc parses and shows
some type of cell references, so I wonder whether there is some
setting that I should change for Calc to be able to accept this type
of references (ini_row:fin_row), or whether this is some kind of
bug or lack of a feature.

A similar issue happens with column-only references, such as
sum(A:B).

To be clear, I'm not saying that row-only (or column-only) references
are better in any way. I'm just trying to make them work as in (a.k.a
compatible with) other spreadsheet software.

If there is a better place (mailing list, irc, forum,...) to ask this
question, please let me know.

TIA,
Ady.



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

[Andrew Douglas Pitonyak]

I use the same mechanism used to number things like tables and figures, 
but I create a new field for my equations and then I enter them manually.


On 10/06/2013 02:09 AM, fajar2 wrote:

How to numbering multiple equation in libre office math.
Current implementation numbered equation in libre Office  just give 2 
x1 table for each equation.
This is not suitable for multiline equation. If i give one table for 
one part equation, there must be many space for multiline equation.
I need multiline equation numbering  like Latex style, so each line in 
multiline equation got same vertical space with other paragraph line.

Make just 1 x 2 table for each equation make redundant of  space.



--
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] replace normal font with superscript

[Andrew Douglas Pitonyak]

When I had to do something similar, I wrote a macro :-)

If you do not know much about macros, you probably need to record one,
and I expect that the macro recorder is poor enough that the only real
solution would be to do the first one by hand, copy the correct result
to the clipboard, then record a macro that pastes the value and then
searches for the next occurrence. If you are left with a regular m2
selection, run the macro again. if not, well, you are finished.

On 10/02/2013 04:50 AM, Thomas Blasejewicz wrote:
 Good evening
 Thisis probably a rather stupid question and has been answered on this
 list (somewhere) a million times ...

 (The job is already done - manually - so there is no hurry; I would like
 to know the trick.)

 I had a piece of text (txt file), which contained a lot of things like
 m2 (square meter).
 Working in Writer I tried to do a find and replace and turn the 2
 into superscript.
 But I could not figure out how that works. I ALWAYS got m2 as
 superscript, even I selected only 2 and then format - superscript.
 (after I while of trying I gave up and replaced those number manually)

 What is the trick required to turn 2 into superscript?
 But ONLY in m2 and not all 2, since there were lots of other numbers
 too.

 Thank you in advance.
 Thomas


-- 
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: FTP Access - Can you Test a Bug

[Andrew Douglas Pitonyak]

On 09/25/2013 04:06 AM, Alex Thurgood wrote:

Le 24/09/2013 20:49, Joel Madero a écrit :


Hi Joel,



Can someone with access to ftp and using Linux test this bug out, it's
been hanging and needs a tester, please comment directly on bug with
results (if possible), else email me and I'll report on bug.

https://bugs.freedesktop.org/show_bug.cgi?id=62981


I can not test on Ubuntu Ringtail, as I'm suffering from bug 64223, 
which fails to load any document from a remote FFTP destination in 
Nautilus, stating that the file is corrupted and then giving me a 
general IO error.



Alex


Alex, does this work as I expect? namely, you enter the site, and 
Nautilus makes it look like it is local so that you can use commands 
such as ls or cp from a shell? If yes, are able to use cp to copy 
a file?


One of my thoughts is that if Nautilus tries to make the file look 
local, then LO would not know that the file is not local, so I would be 
inclined to blame Nautilus.



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