Re: How to access UNO_CONSTANTS definitions via OLE/COM? (Re: Windows version: ProgIDs and typelibs for OLE/COM ?

[Andrew Pitonyak]

This is how I get the manager using Basic: 

Get the type description manager from the default context; see section 10.4 
Context, which also shows how to enumerate all of the singleton objects 
available.
Function GetTypeDescriptionManager()
  Dim sTDMName$  ' Name of the type description manager.
  sTDMName = "/singletons/com.sun.star.reflection.theTypeDescriptionManager"
  GetTypeDescriptionManager() = GetDefaultContext().getValueByName(sTDMName) 
End Function

The following method enumerates all “things” in the com.sun.star.awt module.

Sub EnumerateTypesTest
  Dim oTDM      ' Type Description Manager.
  Dim oTDE      ' Type Description Enumerations.
  Dim oTD       ' One Type Description.
  Dim typeArray ' Types for which descriptions are returned.
  Dim s$        ' Utility string variable.
  
  REM All supported types.
  typeArray = Array(com.sun.star.uno.TypeClass.VOID, _
     com.sun.star.uno.TypeClass.CHAR, _
     com.sun.star.uno.TypeClass.BOOLEAN, _
     com.sun.star.uno.TypeClass.BYTE, _
     com.sun.star.uno.TypeClass.SHORT, _
     com.sun.star.uno.TypeClass.UNSIGNED_SHORT, _
     com.sun.star.uno.TypeClass.LONG, _
     com.sun.star.uno.TypeClass.UNSIGNED_LONG, _
     com.sun.star.uno.TypeClass.HYPER, _
     com.sun.star.uno.TypeClass.UNSIGNED_HYPER, _
     com.sun.star.uno.TypeClass.FLOAT, _
     com.sun.star.uno.TypeClass.DOUBLE, _
     com.sun.star.uno.TypeClass.STRING, _
     com.sun.star.uno.TypeClass.TYPE, _
     com.sun.star.uno.TypeClass.ANY, _
     com.sun.star.uno.TypeClass.ENUM, _
     com.sun.star.uno.TypeClass.TYPEDEF, _
     com.sun.star.uno.TypeClass.STRUCT, _
     com.sun.star.uno.TypeClass.UNION, _
     com.sun.star.uno.TypeClass.EXCEPTION, _
     com.sun.star.uno.TypeClass.SEQUENCE, _
     com.sun.star.uno.TypeClass.ARRAY, _
     com.sun.star.uno.TypeClass.INTERFACE, _
     com.sun.star.uno.TypeClass.SERVICE, _
     com.sun.star.uno.TypeClass.MODULE, _
     com.sun.star.uno.TypeClass.INTERFACE_METHOD, _
     com.sun.star.uno.TypeClass.INTERFACE_ATTRIBUTE, _
     com.sun.star.uno.TypeClass.UNKNOWN, _
     com.sun.star.uno.TypeClass.PROPERTY, _
     com.sun.star.uno.TypeClass.CONSTANT, _
     com.sun.star.uno.TypeClass.CONSTANTS, _
     com.sun.star.uno.TypeClass.SINGLETON)

  oTDM = GetTypeDescriptionManager()

  Dim sBaseName$ : sBaseName = "com.sun.star.awt"
  
  ' Change com.sun.star.reflection.TypeDescriptionSearchDepth.ONE
  ' to com.sun.star.reflection.TypeDescriptionSearchDepth.INFINITE
  ' to traverse more than a single level.
  oTDE = oTDM.createTypeDescriptionEnumeration(sBaseName, _
             typeArray, _
             com.sun.star.reflection.TypeDescriptionSearchDepth.ONE)
  
  While oTDE.hasMoreElements()
    oTD = oTDE.nextTypeDescription()
    s$ = s & oTD.Name & CHR$(10)
  Wend
  MsgBox s
End Sub

To get the information on a specific fully qualified type, use the following 
macro (adapted from an example by Bernard Marcelly):

Function GetOOoConst(constString)
  Dim sTDMName$
  Dim oTDM
  
  sTDMName = "/singletons/com.sun.star.reflection.theTypeDescriptionManager"
  oTDM = GetDefaultContext().getValueByName(sTDMName) 
  
  If oTDM.hasByHierarchicalName(constString) Then 
    GetOOoConst = oTDM.getByHierarchicalName(constString) 
  Else 
    MsgBox "Unrecognized name : " & constString, 16, "OOo API constant or enum" 
  End If 
End Function

The method is usable to obtain constant and enumeration values from a text 
string

Print GetOOoConst("com.sun.star.awt.FontSlant.ITALIC")

This can also return an object that describes the type. This can be used to 
enumerate the values and the strings.

Sub EnumerateEnumerations(sName$)
  Dim oTD       ' One Type Description.
  Dim oTDE      ' Element enumeration
  Dim s$        ' Utility string variable.
  Dim sNames
  Dim lValues
  Dim i As Long
  Dim iCount As Integer
  

  oTD = GetOOoConst(sName)
  If IsNull(oTD) OR IsEmpty(oTD) Then
    Exit Sub
  End If
  
  If HasUnoInterfaces(oTD, "com.sun.star.reflection.XEnumTypeDescription") Then
  
    'MsgBox Join( oTD.getEnumNames(), CHR$(10))
    sNames = oTD.getEnumNames()
    lValues = otd.getEnumValues()
    For i = LBound(sNames) To UBound(sNames)
      iCount = iCount + 1
      If (iCount > 40) Then
        MsgBox(s)
        s = ""
      End If
      s = s & lValues(i) & CHR$(9) & sNames(i) & CHR$(10)
    Next
  ElseIf HasUnoInterfaces(oTD, 
"com.sun.star.reflection.XConstantsTypeDescription") Then
    lValues = oTD.getConstants()
    For i = LBound(lValues) To UBound(lValues)
      iCount = iCount + 1
      If (iCount > 40) Then
        MsgBox(s)
        s = ""
      End If
      s = s & lValues(i).getConstantValue() & CHR$(9) & lValues(i).getName() & 
CHR$(10)
    Next
  Else
    'Inspect oTD
    MsgBox "Unsupported type " & sName
    Exit Sub
  End If
  MsgBox s
End Sub

This can be used to see enumerations.

EnumerateEnumerations("com.sun.star.awt.FontSlant")  

This can be used to see constant groups.

EnumerateEnumerations("com.sun.star.awt.FontWeight")  

Re: Macro book

[Andrew Pitonyak]

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


On Saturday, March 13, 2021 09:05 EST, Carl Marcum  wrote:
 Hi Michael,

Where can I find the english version for the 4th edition?

Thanks,
Carl

On 1/29/21 11:04 AM, Dr. Michael Stehmann wrote:
> Hello,
>
> Andrew Pitonyak puplished his book "OpenOffice.org Macros Explained"
> on 19th of June 2018 (4.th edition).
>
> Now there is an extended german translation available:
>
> https://www.uni-due.de/~abi070/ooo.html
>
> It's a great work. As far as I see it's the only up-to-date and
> available book for this subject.
>
> And so it is very relevant.
>
> It has been notified on users...@openoffice.apache.org .
>
> Kind regards
> Michael
>


-
To unsubscribe, e-mail: dev-unsubscr...@openoffice.apache.org
For additional commands, e-mail: dev-h...@openoffice.apache.org
 


 

Re: good daytime whenever you are

[Andrew Pitonyak]

Okay, I hate autocorrect sometimes.. I should have proofed it before I sent it 
sorry.


if you create something using openoffice, you own it, open office does not. It 
is yours.


⁣Sent from BlueMail ​

On Feb 5, 2021, 7:04 AM, at 7:04 AM, Andrew Pitonyak  
wrote:
>Of course, the medium shirts not matter
>
>⁣Sent from BlueMail ​
>
>On Feb 5, 2021, 6:23 AM, at 6:23 AM, Naturecheer Naturecheer
> wrote:
>>I mean if a saved open office file contains a literary work, can this
>>file
>>be protected with copyrights by an author of a file under his name?
>>
>><https://www.avast.com/sig-email?utm_medium=email_source=link_campaign=sig-email_content=webmail>
>>Без
>>вирусов. www.avast.com
>><https://www.avast.com/sig-email?utm_medium=email_source=link_campaign=sig-email_content=webmail>
>><#DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2>

Re: good daytime whenever you are

[Andrew Pitonyak]

Of course, the medium shirts not matter

⁣Sent from BlueMail ​

On Feb 5, 2021, 6:23 AM, at 6:23 AM, Naturecheer Naturecheer 
 wrote:
>I mean if a saved open office file contains a literary work, can this
>file
>be protected with copyrights by an author of a file under his name?
>
>
>Без
>вирусов. www.avast.com
>
><#DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2>

Re: Writer and .docx

[Andrew Pitonyak]

On Saturday, October 17, 2020 04:56 EDT, Pedro Lino 
 wrote:
 Hi all

> On 10/17/2020 9:11 AM Matthias Seidel  wrote:

> My point is that one should do the work in ODF and only export to
> "foreign" formats if needed.

+1
This is how Gimp works. You can import any format, work on it using the 
program's own format XCF (not Photoshop's PSD to please the majority) and in 
the end you can export to whatever format (PNG, JPG, etc)

In fact the "foreign" formats don't even show up in the Save options. For me 
this is the best solution!

On the other hand (as it happens in LibreOffice) exporting to Microsoft's XML 
will never be perfect (Microsoft will make sure!) and there will always be 
people complaining but it is far better that there is a single conversion 
before sending the document!
(1) Sometimes contractually obligated to deliver some products in DOCX format. 
I am pretty good at knowing what things will export properly to DOCX format and 
which will not (just because I have done it often enough). Only once have I had 
a client (it was government DoD) that would accept (and even required) and ODT 
file. 

(2) Frequently exchange documents with clients that will use/require DOCX. 

(3) I frequently work with people who are better off not having to deal with 
the extra steps of converting between formats. 

All else being equal, if you fall into the categories above, I usually tell 
them to use LibreOffice because it will natively support reading and writing 
DOCX format. When I ask people why they chose LibreOffice over Apache 
OpenOffice, DOCX support is the reason usuall listed. 

Andrew Pitonyak


 

Re: Fonts list

[Andrew Pitonyak]

Sorry, I cannot check based on Apache OpenOffice since it is not installed on 
the machine I am using at this precise moment, but, on my Linux box with 
LibreOffice, I have a list of fonts here: 

/opt/libreoffice6.2/share/fonts/truetype

I also do not have a Windows machine near by for me to test, but, you might be 
able to find the fonts included with the installation files. If I did not find 
them there, I would pull the source code and then search for font files. 
Searching for files that end with ttf will give yo a good idea (if you are able 
to do that). 


https://openoffice.apache.org/source.html

https://github.com/apache/openoffice

Let me test this by quickly pulling the source code
 git clone https://gitbox.apache.org/repos/asf/openoffice.git aooNote that on 
Windows, the above command takes a bit of work to be usable (like installing 
git-bash). 

Not seeing a bunch of fonts, only these: 

https://github.com/apache/openoffice/tree/trunk/main/more_fonts/fonts




On Saturday, July 25, 2020 06:47 EDT, Bidouille  wrote:
 Thanks but the goal is not to list installed fonts on a system.
But which fonts are provided with OpenOffice.

- Mail original -
> De: "Czesław Wolański" 
> À: dev@openoffice.apache.org
> Envoyé: Vendredi 24 Juillet 2020 22:38:45
> Objet: Re: Fonts list
>
> Hi,
>
> > So you found it thanks.
>
> You're welcome.
> If it weren't for your books on OpenOffice macros, my first steps in
> this
> subject
> would be much more painful. :‑)
>
> Regards,
>
> Czesław Wolański
>
> пт, 24 июл. 2020 г. в 22:18, Andrew Pitonyak :
>
> > yes that sounds like a good place to look I would have checked
> > there and
> > then oome if I couldn't find it, and then I would have looked in my
> > personal macros.
> >
> > So you found it thanks.
> >
> > ⁣Sent from BlueMail ​
> >
> > On Jul 24, 2020, 2:06 PM, at 2:06 PM, "Czesław Wolański" <
> > czeslaw.wolan...@gmail.com> wrote:
> > >Hi,
> > >
> > >>I wrote a macro that creates a list in a document with the fonts
> > >available. No idea where it is, but I can probably find it if you
> > >like.
> > >
> > >@andrew
> > >
> > >"Useful Macro Information For OpenOffice.org"
> > >Chapter 5.4. List Fonts And Other Screen Information (macro
> > >ListFonts)
> > >
> > >Could it perhaps be that the macro you refer to is mentioned in
> > >"Useful
> > >Macro Information For OpenOffice.org"?
> > >Section 5.4.1. "Display supported fonts" provides the following
> > >link:
> > >
> > >http://www.pitonyak.org/AndrewFontMacro.odt
> > >
> > >
> > >Regards,
> > >
> > >Czesław Wolański
> > >
> > >пт, 24 июл. 2020 г. в 19:33, Andrew Pitonyak
> > >:
> > >
> > >> I wrote a macro that creates a list in a document with the fonts
> > >> available. No idea where it is, but I can probably find it if
> > >> you
> > >like.
> > >>
> > >> ⁣Sent from BlueMail ​
> > >>
> > >> On Jul 24, 2020, 10:25 AM, at 10:25 AM, Bidouille
> > >> 
> > >> wrote:
> > >> >Hello devteam
> > >> >
> > >> >OpenOffice provide and install specific fonts
> > >> >I'm looking for this list
> > >> >
> > >> >Help is welcome :-)
> > >> >
> > >>
> > >>-
> > >> >To unsubscribe, e-mail: dev-unsubscr...@openoffice.apache.org
> > >> >For additional commands, e-mail: dev-h...@openoffice.apache.org
> > >>
> >
>

-
To unsubscribe, e-mail: dev-unsubscr...@openoffice.apache.org
For additional commands, e-mail: dev-h...@openoffice.apache.org
 


 

Re: Fonts list

[Andrew Pitonyak]

yes that sounds like a good place to look I would have checked there and then 
oome if I couldn't find it, and then I would have looked in my personal macros.

So you found it thanks.

⁣Sent from BlueMail ​

On Jul 24, 2020, 2:06 PM, at 2:06 PM, "Czesław Wolański" 
 wrote:
>Hi,
>
>>I wrote a macro that creates a list in a document with the fonts
>available. No idea where it is, but I can probably find it if you like.
>
>@andrew
>
>"Useful Macro Information For OpenOffice.org"
>Chapter 5.4. List Fonts And Other Screen Information (macro ListFonts)
>
>Could it perhaps be that the macro you refer to is mentioned in "Useful
>Macro Information For OpenOffice.org"?
>Section 5.4.1. "Display supported fonts" provides the following link:
>
>http://www.pitonyak.org/AndrewFontMacro.odt
>
>
>Regards,
>
>Czesław Wolański
>
>пт, 24 июл. 2020 г. в 19:33, Andrew Pitonyak :
>
>> I wrote a macro that creates a list in a document with the fonts
>> available. No idea where it is, but I can probably find it if you
>like.
>>
>> ⁣Sent from BlueMail ​
>>
>> On Jul 24, 2020, 10:25 AM, at 10:25 AM, Bidouille 
>> wrote:
>> >Hello devteam
>> >
>> >OpenOffice provide and install specific fonts
>> >I'm looking for this list
>> >
>> >Help is welcome :-)
>> >
>>
>>-
>> >To unsubscribe, e-mail: dev-unsubscr...@openoffice.apache.org
>> >For additional commands, e-mail: dev-h...@openoffice.apache.org
>>

Re: Fonts list

[Andrew Pitonyak]

I wrote a macro that creates a list in a document with the fonts available. No 
idea where it is, but I can probably find it if you like.

⁣Sent from BlueMail ​

On Jul 24, 2020, 10:25 AM, at 10:25 AM, Bidouille  wrote:
>Hello devteam
>
>OpenOffice provide and install specific fonts
>I'm looking for this list
>
>Help is welcome :-)
>
>-
>To unsubscribe, e-mail: dev-unsubscr...@openoffice.apache.org
>For additional commands, e-mail: dev-h...@openoffice.apache.org

Re: Transfer of documents

[Andrew Pitonyak]

ODT is the format that OpenOffice and LibreOffice use by default. 

Either will be able to directly read your Word documents. You do not need to 
convert them. 

Sorry, I misunderstood your question. 

On Monday, June 29, 2020 17:01 EDT, CAROL L YORKIEVITZ 
 wrote:
 
I don’t know what ODT files are.
Sent from my iPhone

> On Jun 29, 2020, at 5:00 PM, CAROL L YORKIEVITZ  
> wrote:
>
> I haven’t downloaded Open office. I’m trying to decide if I can just use 
> Open office and transfer or download my Word 2007 documents easily or if I 
> need a Word upgrade.
> Thanks
> Carol
>
> Sent from my iPhone
>
>> On Jun 29, 2020, at 4:40 PM, Andrew Pitonyak  wrote:>>
>> 
>> You should be able to read them directly, are you not able to?
>>
>> Or, do you want to fully convert them to ODT files in some automated way?
>>
>> On Monday, June 29, 2020 14:57 EDT, CAROL L YORKIEVITZ 
>>  wrote:
>> I currently use Word 7. Can I easily convert them to Openoffice?
>> Thanks
>>
>> Sent from my iPhone
>>
>> -
>> To unsubscribe, e-mail: dev-unsubscr...@openoffice.apache.org
>> For additional commands, e-mail: dev-h...@openoffice.apache.org
>>
>>
>>
>>
>>
>>
>>


-
To unsubscribe, e-mail: dev-unsubscr...@openoffice.apache.org
For additional commands, e-mail: dev-h...@openoffice.apache.org
 


 

Re: Transfer of documents

[Andrew Pitonyak]

You should be able to read them directly, are you not able to? 

Or, do you want to fully convert them to ODT files in some automated way? 

On Monday, June 29, 2020 14:57 EDT, CAROL L YORKIEVITZ 
 wrote:
 I currently use Word 7. Can I easily convert them to Openoffice?
Thanks

Sent from my iPhone

-
To unsubscribe, e-mail: dev-unsubscr...@openoffice.apache.org
For additional commands, e-mail: dev-h...@openoffice.apache.org
 


 

Re: Custom XML Part

[Andrew Pitonyak]

I don't know what that means

How do you add the XML, is it visible? Is it generic?

I vaguely remember that you can attach a custom XML strong as a property to 
some embedded objects... I don't remember if I discovered this in OOME.odt or 
if it is in AndrewMacro.odt and I can't check right now

I don't know if it was saved with the document... I just vaguely remember that 
there was something like that... I think you would need to know which object 
you added the data to, but this is all a fuzzy memory...

Let me know if this is what you mean and are unable to find it...




⁣Sent from BlueMail ​

On Feb 15, 2018, 2:01 PM, at 2:01 PM, Rushna Jabi <rushnajabi...@gmail.com> 
wrote:
>Thanks for reply.
>
>Andrew, In Ms Office document we can add Custom Xml Part i.e.
>information
>related to current document.
>we can access also that  information.
>please tell me , Is it possible in OpenOffice and how?
>
>
>
>Regards,
>Rushna jabi
>
>On Mon, Feb 12, 2018 at 7:17 PM, Andrew Pitonyak <and...@pitonyak.org>
>wrote:
>
>> The people on this list are not likely to know about me office
>products.
>> Consider describing the behavior.
>>
>> ⁣Sent from BlueMail ​
>>
>> On Feb 12, 2018, 7:16 AM, at 7:16 AM, Rushna Jabi
><rushnajabi...@gmail.com>
>> wrote:
>> >Hi all,
>> >I am working on OpenOffice plugin but I want to add Custom Xml Part
>in
>> >OpenOffice like Ms-Office.
>> >please tell me it's possible or not in Openoffice.
>> >if it is possible then, How?
>> >
>> >
>> >
>> >
>> >
>> >
>> >
>> >Regards,
>> >Rushna Jabi
>> >Software Engineer
>>

Re: Custom XML Part

[Andrew Pitonyak]

I copied the sender, since I did respond, so he is probably not 
subscribed to the list


I said about the same as you Peter but you said it better...

So, Rushna, be sure to respond to the list and indicate exactly what it 
is you are trying to do since the people on this list are not likely to 
know what "custom XML" means in MS-Office. I cannot even begin to guess.



On 2018-02-15 8:29, Peter Kovacs wrote:

I do not understand what you want to have.
Don't use comparisons like as in Excel. I for my part have no clue
what you want to do.
Probable that's why you did not get an answer.
Can you write it as user story what your plugin should do and then
what part you want to use XML for.

Example:
As a user I want to export my user settings
 The user settings should be written as XML file.

Am 15. Februar 2018 06:11:06 MEZ schrieb Rushna Jabi 
:

please  help?
I didn't get any reply till now...:(

On Mon, Feb 12, 2018 at 5:36 PM, Rushna Jabi 


wrote:


Hi all,
I am working on OpenOffice plugin but I want to add Custom Xml Part

in

OpenOffice like Ms-Office.
please tell me it's possible or not in Openoffice.
if it is possible then, How?







Regards,
Rushna Jabi
Software Engineer



-
To unsubscribe, e-mail: dev-unsubscr...@openoffice.apache.org
For additional commands, e-mail: dev-h...@openoffice.apache.org

Re: Custom XML Part

[Andrew Pitonyak]

The people on this list are not likely to know about me office products. 
Consider describing the behavior.

⁣Sent from BlueMail ​

On Feb 12, 2018, 7:16 AM, at 7:16 AM, Rushna Jabi  
wrote:
>Hi all,
>I am working on OpenOffice plugin but I want to add Custom Xml Part in
>OpenOffice like Ms-Office.
>please tell me it's possible or not in Openoffice.
>if it is possible then, How?
>
>
>
>
>
>
>
>Regards,
>Rushna Jabi
>Software Engineer

Re: Import & export Basic libraries ?

[Andrew Pitonyak]

Sadly, I do not have time to look into this right now, but, I believe 
that I may have some useful examples in one of my documents. I do not 
remember which one. The documents to check (and I do not have local 
copies where I am now) are either:


I would check in this order:

http://www.pitonyak.org/database/
(1) Random DB Ramblins: http://www.pitonyak.org/database/AndrewBase.odt


http://www.pitonyak.org/oo.php
(2) OpenOffice.org macros Explained: 
http://www.pitonyak.org/OOME_3_0.odt

(3) English macro Document: http://www.pitonyak.org/AndrewMacro.odt


In (1), I think that I directly manipulate macros, creating and then 
running them. In (2) I think that I have a section on manipulating 
libraries. (3), well, I just don't remember at the moment what I have in 
there related to macro libraries.




On 2017-10-05 5:00, CHRISTOPHE JOYAU wrote:

Hello,

I'm looking for a way to import Basic Libraries with Open Office 4.X
about Libraries of a component (not about Globalscope Libraries).

I know to export with :

Librairies=BasicLibrairies
For Each Librairie In Librairies()
BasicLibraries.exportLibrary(Librairie.Name,ConvertToUrl(Chem &
"Basic"),com.sun.star.ucb.AuthenticationRequest)
Next

So i get in directory Chem & "Basic" => xba and xlb


I 'd like to do inverse operation and it 's not working if i use
BasicLibraries.CreateLibraryLink(R,ConvertToUrl(Chem & "Basic\" & 
R),False)


With this command i can obtain a new library R in my component but
with an error and it's empty and with a password " " ( it's mad !) .

Could you please endicate the good command to import libraries ?

Thank you for your attention and i hope your answer !
Avec mes salutations,
Christophe Joyau
Pupitreur assistant-Utilisateurs
C entre I nterrégional de S aisie des D onnées
22 bis avenue du 8 mai 1945
95200 Sarcelles
Tel : 09.70.27.18.57
' Ensemble des librairies contenues dans Clas ( il aurait été plus
simple d'utiliser seulement )

Re: future of OpenOffice

[Andrew Pitonyak]

For the average user, the functional differences are irrelevant. More 
specifically, most people use only a fraction of the capabilities. LO 
offered DOCX support before AOO, and that was a difference noticeable to 
most users.


For the hard core devoted follower, there are certainly philosophical 
differences related to code reuse, and people who care about that have 
probably already figured out that difference and chosen a side. For the 
end user, it makes little to no difference. Consider my macro document. 
Should I set the license such that you cannot use the samples unless you 
open your project? That is closer to LO than AOO.


Apart from that, you are left with questions such as, do I find a user 
interface more attractive, a particular feature better supported, or 
reliability on my specific platform. My parents use what I choose to 
install on their computers.


Andrew Pitonyak

Re: [API] Priority Problem with AND and OR

[Andrew Pitonyak]

I was tempted to open a bug against this some years back, but, this is 
the type of change that I can't help but wonder if it is more dangerous 
to affect existing code, or to use rules by new users who are unaware 
that ^ does not follow expected rules, and neither does AND and OR. Same 
is true for bitwise operations.



On 12.10.2015 15:58, Rory O'Farrell wrote:

On Mon, 12 Oct 2015 15:45:16 -0400
Andrew Pitonyak <and...@pitonyak.org> wrote:


Yes, I note this travesty in OOME. There is also a difference in the
way that it handles exponentiation. Standard rules indicate that 
2^3^4

is evaluated as 2^(3^4) rather than (2^3)^4, wihch is what OOo does.


This problem came up recently several times on the en-Forum; we
advised that it is best to use the brackets to define order of
calculation (particularly as so many Calc users are mathematically
inexperienced).  It would nevertheless be good to have the matter
correct in some revision.

Rory O'Farrell

On 12.10.2015 15:40, Mathias Röllig wrote:
> Hello!
>
> I stumbled into a priority problem with the boolean operators AND 
and

> OR. I cannot find any documentation for this.
>
> First mathematical examples.
>
> With
> MsgBox( 3 * 2 ^ 2 )
> you will see, that ^ has a higher priority than *.
> (2 ^ 2) = 4
> 4 * 3 = 12
> With
> MsgBox( (3 * 2) ^ 2 )
> you will get the right result 6 ^ 2 = 36.
>
> With
> MsgBox( 3 + 4 * 3 )
> you will see, that * has a higher priority than +.
> (4 * 3) = 12
> 3 * 12 = 36
> With
> MsgBox( (3 + 4) * 3 )
> you will get the right result 7 * 3 = 21.
>
> Now looking at the same logic with logical operators.
>
> Dim bResult As Boolean
> bResult = TRUE Or FALSE And TRUE
> MsgBox( bResult )
> bResult = TRUE Or TRUE And FALSE
> MsgBox( bResult )
>
> What do you expect?
> For logical operations AND is equivalent to * and OR is equivalent 
to

> +.
> AND should have a higher priority than OR, so I would expect in 
both

> cases (because TRUE Or () = TRUE):
> bResult = TRUE
> But you will get
> TRUE Or FALSE And TRUE = (TRUE Or FALSE) And TRUE = TRUE
> TRUE Or TRUE And FALSE = (TRUE Or TRUE) And FALSE = FALSE
>
> Is there any explanation that AND and OR have (and should have) 
the

> same priority?
>
> Regards, Mathias
>
> 
-

> To unsubscribe, e-mail: dev-unsubscr...@openoffice.apache.org
> For additional commands, e-mail: dev-h...@openoffice.apache.org


-
To unsubscribe, e-mail: dev-unsubscr...@openoffice.apache.org
For additional commands, e-mail: dev-h...@openoffice.apache.org




-
To unsubscribe, e-mail: dev-unsubscr...@openoffice.apache.org
For additional commands, e-mail: dev-h...@openoffice.apache.org

Re: [API] Priority Problem with AND and OR

[Andrew Pitonyak]

Yes, I note this travesty in OOME. There is also a difference in the 
way that it handles exponentiation. Standard rules indicate that 2^3^4 
is evaluated as 2^(3^4) rather than (2^3)^4, wihch is what OOo does.



On 12.10.2015 15:40, Mathias Röllig wrote:

Hello!

I stumbled into a priority problem with the boolean operators AND and
OR. I cannot find any documentation for this.

First mathematical examples.

With
MsgBox( 3 * 2 ^ 2 )
you will see, that ^ has a higher priority than *.
(2 ^ 2) = 4
4 * 3 = 12
With
MsgBox( (3 * 2) ^ 2 )
you will get the right result 6 ^ 2 = 36.

With
MsgBox( 3 + 4 * 3 )
you will see, that * has a higher priority than +.
(4 * 3) = 12
3 * 12 = 36
With
MsgBox( (3 + 4) * 3 )
you will get the right result 7 * 3 = 21.

Now looking at the same logic with logical operators.

Dim bResult As Boolean
bResult = TRUE Or FALSE And TRUE
MsgBox( bResult )
bResult = TRUE Or TRUE And FALSE
MsgBox( bResult )

What do you expect?
For logical operations AND is equivalent to * and OR is equivalent to 
+.

AND should have a higher priority than OR, so I would expect in both
cases (because TRUE Or () = TRUE):
bResult = TRUE
But you will get
TRUE Or FALSE And TRUE = (TRUE Or FALSE) And TRUE = TRUE
TRUE Or TRUE And FALSE = (TRUE Or TRUE) And FALSE = FALSE

Is there any explanation that AND and OR have (and should have) the
same priority?

Regards, Mathias

-
To unsubscribe, e-mail: dev-unsubscr...@openoffice.apache.org
For additional commands, e-mail: dev-h...@openoffice.apache.org


-
To unsubscribe, e-mail: dev-unsubscr...@openoffice.apache.org
For additional commands, e-mail: dev-h...@openoffice.apache.org

Re: macro equivalent of VBA Range()

[Andrew Pitonyak]

On 30.06.2015 14:54, Mark Polczynski wrote:
I am an absolute beginner to OpenOffice macros, but have some 
knowledge of

VBA.  What is the OpenOffce macro equivalent of the VBA statement:

x = Range(Y)

Also, what is the equivalent of:

x = Cells(1,1)

Thanks!

Mark Polczynski



I assume that you posted this to the forum as suggested, but, I did not 
see your question there (it is a better place to answer these questions)


You get cells from the sheet containing them. I am unsure what 
Range(Y) does, but a rough guess is that it is a defined range.


So, if you just want the currently active sheet in a Calc document, you 
can do something like this:


ThisComponent.CurrentController.getActiveSheet()

If you want a specific sheet, you can use

ThisComponent.Sheets.getByIndex(insert sheet index here)
ThisComponent.Sheets.getByName(insert sheet name here)

Now, assume that you want cell A1, you can use

ThisComponent.CurrentController.getActiveSheet().getCellByPosition(0, 
0)


The first 0 means the first column and the second 0 means the first 
row.


You can also use:

getCellByPosition(left, top) Get a cell within the range.
getCellRangeByPosition(left, top, right, bottom) Get a cell range 
within the range.
getCellRangeByName(name) Get a cell range within the range based on its 
name. The string directly references cells using the standard formats 
— such as “B2:D5” or “$B$2” — or defined cell range names.


Hope this helps.

Oh, and you can find some examples here:

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















-
To unsubscribe, e-mail: dev-unsubscr...@openoffice.apache.org
For additional commands, e-mail: dev-h...@openoffice.apache.org

Re: Summary

[Andrew Pitonyak]

You sent an email to a public email list. If you do not like what a recipient 
does with it then you need to figure out how to make that recipient stop. Off 
hand that sounds like an impossible task; ever heard of the Streisand effect? 
You may be able to do this one recipient at a time, but you need to decide how 
much time and money you want to throw at it... But the more you do so the less 
likely it is to be effective.

On Mar 14, 2015 3:21 PM, Grampa Renato, GB renato.gra...@prysmiangroup.com 
wrote:

 Thank you Jan, 

 European laws should protect me from the spread of my emails, differently 
 from US. 

 Clearly I submitted my message in good faith to the recipient assuming that 
 it remained a bilateral correspondence only. 
 I haven't seen indications that the message would have been disseminated to 
 the World in this way, despite the confidentiality note. 

 Nevertheless there must be a tool to discriminate emails from making them 
 public when inappropriate, like in this case. 

 Thank you for any other suggestion you could provide 
 Renato 







 Email sent via mobile service 

 From: jan i [mailto:j...@apache.org] 
 Sent: Saturday, March 14, 2015 07:12 PM 
 To: Grampa Renato, GB 
 Cc: jan i j...@apache.org; dev dev@openoffice.apache.org 
 Subject: Re: Summary 



 On 14 March 2015 at 18:32, Grampa Renato, GB 
 renato.gra...@prysmiangroup.commailto:renato.gra...@prysmiangroup.com 
 wrote: 
 Jan, 
 Thanks for the emails. 
 I’ll not comments the methods and the policies adopted by the owner. 
 I am not sure who you see as owner. 

 Apache has a public policy: 
 http://www.apache.org/foundation/public-archives.html 


 I just would like to find a way to remove my message from the web. 
 Who should I contact? 
 you should contact all mail archive owners who are subscribed to this list 
 (you found one of them, but there are many like e.g. 
 http://www.mail-archive.com/dev@openoffice.apache.org/ ). 

 What’s the owner address? 
 There are NO owner, there are many and none of them are controlled by apache. 
 Apache merely receives your mail and redistributes it according to the 
 subscriber list (which on this list is around 500 addresses). 

 What you need to do is search the web to see where you email appear, check 
 the URL with whois and write to these companies. 

 Please do remember all those who have received your email is intended 
 recipients. 

 I can only advice to be careful when you write to a public mailing address, 
 it is practically impossible to remove a mail once it has being multiplied. 

 Rgds 
 jan i 


 Thanks 
 RG 


 From: jan i [mailto:j...@apache.orgmailto:j...@apache.org] 
 Sent: 14 March 2015 17:38 
 To: dev; Grampa Renato, GB 
 Subject: Summary 

 Hi again 
 Now I have forwarded all mails to you on this thread. 
 As you can see the address you have mailed have many subscribers, who are all 
 indeed intended recipients. 
 If you have a problem with the mail, you need to write to all mail archives 
 (which apache do not control), all personal subscribers (which apache do not 
 control) and ask all these entities to remove your mail. 
 Rgds 
 jan I. 



  


 CONFIDENTIALITY NOTICE 

 This message and its attachments (if any) may contain confidential, 
 proprietary or legally privileged information and it for the use of the 
 intended recipient(s). No confidentiality or privilege is waived or lost by 
 any incorrect transmission. 

 If you are not the intended recipient of this message you are hereby notified 
 that you must not use, disseminate, copy it in any form or take any action in 
 reliance on it. If you have received this message in error, please, delete it 
 (and any copies of it) and kindly inform the sender of this e-mail by 
 replying or going to www.prysmiangroup.comhttp://www.prysmiangroup.com/ on 
 contact us. 

 All liability for viruses is excluded to the fullest extent permitted by law. 

Re: Summary

[Andrew Pitonyak]

Take a look at what wikipedia has to say. It looks like in the EU email 
disclaimers are useless. No idea how accurate that is.

On Mar 14, 2015 3:21 PM, Grampa Renato, GB renato.gra...@prysmiangroup.com 
wrote:

 Thank you Jan, 

 European laws should protect me from the spread of my emails, differently 
 from US. 

 Clearly I submitted my message in good faith to the recipient assuming that 
 it remained a bilateral correspondence only. 
 I haven't seen indications that the message would have been disseminated to 
 the World in this way, despite the confidentiality note. 

 Nevertheless there must be a tool to discriminate emails from making them 
 public when inappropriate, like in this case. 

 Thank you for any other suggestion you could provide 
 Renato 







 Email sent via mobile service 

 From: jan i [mailto:j...@apache.org] 
 Sent: Saturday, March 14, 2015 07:12 PM 
 To: Grampa Renato, GB 
 Cc: jan i j...@apache.org; dev dev@openoffice.apache.org 
 Subject: Re: Summary 



 On 14 March 2015 at 18:32, Grampa Renato, GB 
 renato.gra...@prysmiangroup.commailto:renato.gra...@prysmiangroup.com 
 wrote: 
 Jan, 
 Thanks for the emails. 
 I’ll not comments the methods and the policies adopted by the owner. 
 I am not sure who you see as owner. 

 Apache has a public policy: 
 http://www.apache.org/foundation/public-archives.html 


 I just would like to find a way to remove my message from the web. 
 Who should I contact? 
 you should contact all mail archive owners who are subscribed to this list 
 (you found one of them, but there are many like e.g. 
 http://www.mail-archive.com/dev@openoffice.apache.org/ ). 

 What’s the owner address? 
 There are NO owner, there are many and none of them are controlled by apache. 
 Apache merely receives your mail and redistributes it according to the 
 subscriber list (which on this list is around 500 addresses). 

 What you need to do is search the web to see where you email appear, check 
 the URL with whois and write to these companies. 

 Please do remember all those who have received your email is intended 
 recipients. 

 I can only advice to be careful when you write to a public mailing address, 
 it is practically impossible to remove a mail once it has being multiplied. 

 Rgds 
 jan i 


 Thanks 
 RG 


 From: jan i [mailto:j...@apache.orgmailto:j...@apache.org] 
 Sent: 14 March 2015 17:38 
 To: dev; Grampa Renato, GB 
 Subject: Summary 

 Hi again 
 Now I have forwarded all mails to you on this thread. 
 As you can see the address you have mailed have many subscribers, who are all 
 indeed intended recipients. 
 If you have a problem with the mail, you need to write to all mail archives 
 (which apache do not control), all personal subscribers (which apache do not 
 control) and ask all these entities to remove your mail. 
 Rgds 
 jan I. 



  


 CONFIDENTIALITY NOTICE 

 This message and its attachments (if any) may contain confidential, 
 proprietary or legally privileged information and it for the use of the 
 intended recipient(s). No confidentiality or privilege is waived or lost by 
 any incorrect transmission. 

 If you are not the intended recipient of this message you are hereby notified 
 that you must not use, disseminate, copy it in any form or take any action in 
 reliance on it. If you have received this message in error, please, delete it 
 (and any copies of it) and kindly inform the sender of this e-mail by 
 replying or going to www.prysmiangroup.comhttp://www.prysmiangroup.com/ on 
 contact us. 

 All liability for viruses is excluded to the fullest extent permitted by law. 


-
To unsubscribe, e-mail: dev-unsubscr...@openoffice.apache.org
For additional commands, e-mail: dev-h...@openoffice.apache.org

Re: Need help on bookmark writter

[Andrew Pitonyak]

Of course you can do it... Start by finding each bookmark to see how that is 
done. I don't remember off hand if you can then insert the image at the anchor 
point. You may need to use a dispatch to do it.

Check OOME.odt and AndrewMacro.odt for examples. I can't check either at the 
moment.

On Mar 12, 2015 10:50 AM, purushottam kumar purushottam.ku...@pankanis.com 
wrote:

 Hello Sir, 

 I want to replace the content of a bookmark with an image instead of some 
 text. 

 Is this possible in Openoffice? 

 Please help. 

 Regards, 
 Purushottam 
 9922008483 

Re: Proposal to change or remove a web page that seems to cause unfruitful discussions.

[Andrew Pitonyak]

I saw no confusion in the article and I enjoyed it But it is odd that the 
page exists there of it is an unrelated opinion piece. That said, of it is 
indicating a reason the license fire AOO is desirable, that is different.

On Feb 19, 2015 10:10 AM, jan i j...@apache.org wrote:

 Hi. 

 We have a page http://www.openoffice.org/why/why_compliance.html which 
 seems to be like a red carpet to a number of people. 

 There are of course people who do not like the page because they would like 
 another license to have the headline, they are not my concern (as long as 
 the page we produce are correct). 

 There are also people (myself included) that feel this page can too easily 
 be misread as expressing the view of ASF and AOO. 

 The page has lately been changed and among other a line at the bottom has 
 been added: 
  

 *The Apache Software Foundation does not take a position on, recommend or 
 advise the use or non-use of any particular software license or family of 
 licenses.* 
 Surely that is enough in legal terms indicate that the page is the opinion 
 of somebody not ASF. But for many they see this as the normal disclaimer 
 and being on the bottom many do not even read it. 

 We as a project cannot and should not speak on behalf of ASF, nor should we 
 have web pages that causes longer negative discussions (I cannot refer to 
 the mails on private@ and elsewhere, but only say that lately we talk about 
 a lot of mails). 

 I, as PMC member, do not see the need for a page that causes this kind of 
 discussions, and would prefer to see it removedhowever a statement on 
 top of the page saying something like: 
 This page do not reflect the opinion of ASF or the AOO PMC 
 would at least stop the negative discussions. 


 Thoughts? 

 rgds 
 jan I. 

-
To unsubscribe, e-mail: dev-unsubscr...@openoffice.apache.org
For additional commands, e-mail: dev-h...@openoffice.apache.org

Re: [LAZY CONSENSUS] maintenance of ooo-wiki2-vm.a.o and ooo-forums.a.o

[Andrew Pitonyak]

I have been following as best I can while traveling, and it is not my place to 
say, but I agree

jan i j...@apache.org wrote:

On 28 December 2013 16:19, Andrea Pescetti pesce...@apache.org wrote:

 On 22/12/2013 jan i wrote:

 based on a polite push from a good infra colleague,  I have decided to
 present yet another proposal for maintaining ooo-wiki2-vm.a.o and
 ooo-forums.a.o


 I agree with the proposal, so +1 from me.

 The main value it brings is that we will have a common (and lightweight)
 set of rules that allow us to establish some initial guidelines. This will
 make it easier to include new volunteers later, or promote existing
 volunteers to sysadmin role, or do whatever we agree upon, at due time. But
 we need an initial set of guidelines to work effectively as a team.


thanks for your +1, thats the first of the existing team, I still hope the
rest of the team will join. The intention of the proposal is NOT to exclude
anybody, it (as andrea write very nicely) to make a basis on which we can
build, while securing our servers.





  I suggest myself for sysadm, and jsc, pescetti, arist and imacat for
 vm-team. Of course my suggestion depends on the willingness of the
 mentioned people.


 I'm willing to be part of team as proposed.

thx, your input and help is much valued.

Remember there are 3 days left of this year, if you have something to catch
up on.

rgds
jan I.



 Regards,
   Andrea.

 -
 To unsubscribe, e-mail: dev-unsubscr...@openoffice.apache.org
 For additional commands, e-mail: dev-h...@openoffice.apache.org

Re: Codesnippets: What is it? Who is hosting it? Do we still want it?

[Andrew Pitonyak]

On 15.01.2013 14:19, Rob Weir wrote:

On Tue, Jan 15, 2013 at 2:06 PM, Rony G. Flatscher
rony.flatsc...@wu.ac.at wrote:

Rob,

Am 15.01.2013 um 19:54 schrieb Rob Weir robw...@apache.org:


http://codesnippets.services.openoffice.org/index.xml

I noticed this linked to from another page.  It looks a mess.  But 
the
source does not appear to be in SVN, so I don't see any way to 
clean

it up.

-Rob



The corresponding e-mail of last year (March 11th, 2012), including 
the contact information, attached.




OK.  Thanks.  So it is external and not under our control, though
obviously we could drop the DNS entry if we feel this is abandoned.

I can see how having code snippets would be useful for developers,
But can't we do most of this on the MWiki?


Odd. I had always assumed that it was an official site supported by 
Sun.

Re: Incompatible changes in AOO 4.0 ?

[Andrew Pitonyak]

Thanks, will take a look when iI am near a real computer...

Sent from my Samsung Epic™ 4G

Pedro Giffuni p...@apache.org wrote:

Hi Andrew;


- Messaggio originale -
 Da: Andrew Pitonyak 

 
 If the change is made, a good first step is a spread sheet with test cases.
 
 So you have a proposed list of functions that would be changed?
 

I did just a very small set of changes for asinh, acosh, atanh and a some
internal power functions .. just for testing.

Since there is interest in this I opened a Bugzilla issue with the patch:
https://issues.apache.org/ooo/show_bug.cgi?id=121561


There's also a spreadsheet with some basic tests.
 Would want to compare expected group actual and old to new.
 
 Would want to devise test cases against both common and edge cases. 
 
 Also curios about time impact, does it take more time or less.



The differences are insignificant comparing FreeBSD amd64 (with boost)
vs a VM running Windows XP with Symphony, but I am sure someone
can come up with more creative tests :).

Perhaps someone not necessarily technically oriented, can create
a wiki page with a table of the functions in boost 1.48 that we may want.

Some stuff like GCD and LCM is simply more work than is worth it but
if there is something that we simply don't have already (perhaps some
weird stats distribution) , chances are good we can bring it in for 4.0.

Pedro.

Re: Incompatible changes in AOO 4.0 ?

[Andrew Pitonyak]

Improved accuracy its usually a good thing. I have considered that boost was a 
good choice so that our will not be system dependent.

in other words, i think it is a good idea.

Sent from my Samsung Epic™ 4G

Pedro Giffuni p...@apache.org wrote:



- Messaggio originale -
 Da: Rob Weir 
...
 
  BTW, I am considering doing something drastic there, like replacing all the 
 probability
  distributions with with boost implementations. Would there be any good 
 reason to
  avoid such approach?
 
 
 What is the advantage of changing?
 

Quality: the precision and performance in the boost implementations
is notable. Most of our older implementations are also unmaintained. If
you look at the Gamma implementation, for example, you will notice a
comment that says it is based on the boost implementation. We surely
haven't kept up with the bug fixes or improvements they may have made
since then.

The boost implementations also have the option of specifying math policy,
which is something our current implementations lack.

Quite honestly, I was hesitant to introduce boost stuff in Calc but we
already depend on it for other things so it comes for free and the code 
is admittedly very good (with only some small issues in their PRNG).

 Risk of any change is introducing a bug.  From a user's perspective
 any difference in calculation, even if correct is something that may
 cause them to halt their work until they understand why their complex
 calculation gives an answer that is 0.1% different than AOO 3.4.1.
 

0.1% is a huge number: If the new functions produce 0.1 % more correct

results then I would say it's a bugfix and bug fixes are GREAT.

I have to say that some of the current math functions are in poor shape,
hopefully not 0.1% wrong but still pretty shameful.

We have to verify each and every function we replace but I don't think the
idea is to produce a crappy Spreadsheet that lies, and producing
inaccuracies in cases where we can do much better is pretty much lying.

 So we need both accuracy and release-to-release consistency.  Me may
 improve accuracy and in the process yield results that differ from
 earlier versions, but this needs to be tracked and communicated to
 users carefully, so they understand what happened to their
 spreadsheets.  I don't think we want improvements to be a 
 surprise
 for the user, especially since at that point bugs and improvements are
 indistinguishable to casual examination.
 

Of course, there are Release notes for that: there are no surprises
here. Major release numbers bumps are useful precisely to indicate

such changes.

I would also think we will want to keep the legacy implementations
available in a scaddin. The beauty of opensource is that anyone is free
to lend a hand and do just that.

 If we don't have a solid test suite to determine whether our
 calculations are correct or even detect if our calculations differ
 from release to release then I'm not really in favor of changing the
 code.  But if we wanted to do a rigorous test of OpenOffice, per the
 standard, and fix any bugs or inaccuracies that the test suite
 reveals, then I think we end up with a stronger product, and one where
 we can safely optimize the routines, knowing that the test cases have
 our back.
 

Please feel free to contribute a spreadsheet that calculates the edge
cases. Any contribution of that kind is welcome, and that's why this list
exists.

We do have a serious problem in the current Calc: we are depending on
system libraries for some calculations. This has the disadvantage that the
results will differ if you do your calculation on Windows or in UNIX with
none of them being too good in accuracy. Under it's current shape I
wouldn't recommend a tool like calc for use in serious scientific use.

For the record, some of the math libraries used in some libc implementations
are derived from Netlib's Cephes and even though modern standards require
them, they have been rejected for inclusion in FreeBSD due to their low
quality.

I am pretty sure I know what I am doing here. I have a patch in my box to fix
some of the lower hanging fruit in Calc. You will probably not see any of it
this year, but it will be coming through bugzilla so that you have time to help
review the changes with real code :)..

Pedro.

Re: FYI: Wiki performance.

[Andrew Pitonyak]

Thanks for the work... With iI had the backgroundto do it...

Sent from my Samsung Epic™ 4G

janI j...@apache.org wrote:

Thx for your ideas, that is always welcome !

daniel and gavin are also helping...

thx for your kinds words, it is quite a tough start for me as infra
volunteer :-)

have a nice day
Jan I.


On 27 December 2012 21:59, Dave Fisher dave2w...@comcast.net wrote:

 Hi JanI,

 Thanks for your work here!

 On Dec 27, 2012, at 12:47 PM, janI wrote:

  the Wiki is very slow these days, it is NOT because of spam attack, but
  actually something positive.
 
  We have loads of users, seeking all kind of  information, according to
 the
  access log.
 
  Does anyone have access to our google analytics, I would like to know (if
  possible) on day by day basis 24/dec - end dec, how many unique hits the
  wiki have had.
 
  I am analyzing the VM, httpd, mysql and ATS (of course with infra) to see
  how we get it to perform better.

 I would focus on IO bandwidth in the VM and memory. Is memcached being
 used?

 Would it make sense to move mysql onto its own VM?

 I can't give detailed help, I manage people who manage LAMP stacks.

 Regards,
 Dave

 
  thx in advance for your patience.
  jan I.

Re: [mwiki] Spammers are baaack ...

[Andrew Pitonyak]

On 26.12.2012 05:17, TJ Frazier wrote:

On 12/25/2012 21:51, RGB ES wrote:

2012/12/26 TJ Frazier tjfraz...@cfl.rr.com


I thought that anyone on a dial-up connection got a dynamic IP, but
anyone on a broadband line got a permanent IP. Is this wrong?


Not exactly. I would say semi-permanent

With my cable modem, I may go a few months with the same IP, maybe even 
longer, but I might also change IP a couple of times in one week.


If you drop power to the modem, it is highly probable that a new IP 
will b assigned when you come back up. Or so it seems to me.


Andy

Re: Starting Introduction to Contributing to Apache OpenOffice Module

[Andrew Pitonyak]

Welcome... Any particular rule of interest for you? For example, documentation, 
quality assurance, development, 


Sent from my Samsung Epic™ 4G

SCARLET WILSON loveistrut...@gmail.com wrote:

*hi how is everyone...i would like to be a part of  the open office
project...i know my contribution will one day be beneficial not only for
myself...but for all who have a common goalim hoping to be interacting
with someone soon...*

-- 
SCAR

Re: Fwd: wiki.open office Volunteer Application

[Andrew Pitonyak]

Doreen,

Your email message indicates that you have an account. Is your account 
name Doreen?


I thought that having an account allowed you to edit existing pages, 
but you may not be able to create new pages (Unsure about that).


Please fully logout, restart your web browser, and login. Then, verify 
that you cannot edit content.


If you cannot edit an existing page, please respond to the list and 
include your user name on the WIKI, and perhaps also a link to the page 
you cannot edit.



On 24.12.2012 01:28, 陶然 wrote:

-- Forwarded message --
From: 陶然 doreentr0...@gmail.com
Date: 2012/12/18
Subject: Re: wiki.open office Volunteer Application
To: dev@openoffice.apache.org


Hi,
   Thank you for the account!But I can not edit mwiki after I logged 
in.I
wonder that if I can get more permit to edit wiki?I am very interest 
in the

Symphony Sidebar.

Best regards,
Doreen

2012/12/13 Andrew Douglas Pitonyak and...@pitonyak.org


On 12/12/2012 12:37 AM, 陶然 wrote:


Hello,
I'm a collage student ,and my major is industry design.I'm very 
interested
in wiki open office,so I send you this letter to wonder that may I 
be a

member of volunteers?
I will be very Appreciate if you agree my joining !

Best regards,
Doreen

 Also, if you intend to edit content on the WIKI, respond to this 
email
(be sure to include the mailing list) and indicate the username to 
use for

your account.

Note that you only require an account if you will edit WIKI content.

Re: AOO questions on Google

[Andrew Pitonyak]

No save as for docx is why libre is installed on a few machines i sometimes 
deal with.


Sent from my Samsung Epic™ 4G

F C. Costero fjcc.apa...@gmail.com wrote:

Since there is some interest in this particular topic, here are the 9
questions I categorized as MS Interoperability with the number of positive
votes appended to each in parentheses.
1. I tryed to save my word processor file as a MS Word file  only
extensions listed in the drop down were for text or Open Office, no Word
option.  Help function said I should have had that option in the drop down
under save as. version 3.4.1.
Could you add a converter for format MS .docx as the actual converter for
.doc does not work proper. It mix up text and drawings and make the whole
page a mess. (1)

2. hello,
How can i open openoffice file with microsoft office?
Gr Sam Esman (5)

3. What kind of OOXML support is intended in AOO?
Transitional (MS Word) version or ISO (does someone really implement it?).
(3)

4. If save filter is implemented, don't you fear a weakening of the ODF
then? (6)

5. allow open office to use ms office defaults (5)

6. can i install openoffice when i have microsoft office on my computer (4)

7. OpenOffice, should be able to open properly all 'Word office' files. (9)

8. Is open office compatible with Office 2010? (8)

9. Open Office doesn't handle tables in Word well - for example re-sizing
of columns, keeping table rows together, inserting page breaks within
tables. Could OO development include a goal of fully matching MS Office
functionality for tables? (13)



On Sun, Dec 23, 2012 at 9:28 AM, Drew Jensen drewjensen.in...@gmail.comwrote:

 Hi,

 Long time since I said anything and so how about,
 Happy Holidays, to start.

 Just to say that the #2 doesn't surprise me at all and yes I would strongly
 suspect it has lots to do with OOXML. Don't forget that this does not
 necessarily mean interoperability with MSO it also
 means interchangeability with GDocs as best as I can tell.

 Thanks



 On Sun, Dec 23, 2012 at 11:22 AM, Dennis E. Hamilton orc...@apache.org
 wrote:

  Concerning Microsoft Office interoperability, I suspect the absence of a
  way to save documents in OOXML formats is a detractor from Apache
  OpenOffice 3.4.  There are the usual interchange fidelity issues as well,
  depending on which interchangeable formats are used.
 
   - Dennis
 
  -Original Message-
  From: janI [mailto:j...@apache.org]
  Sent: Sunday, December 23, 2012 02:37
  To: dev@openoffice.apache.org
  Subject: Re: AOO questions on Google
 
  Thanks for the summary !
 
  Personally I asumed that LO would be #1, but I am amazed about #2 (MS
  Office interoperability  and Other formats) I thought that was one of our
  very strong sides. I might be worthwhile to look a bit deeper into that,
  and see if the cause for the questions is in lack of features, lack of
  documentation or someelse, to give a clue of what to do ? Maybe we can do
  something with 4.0.
 
  Jan I.
 
  On 23 December 2012 04:00, F C. Costero fjcc.apa...@gmail.com wrote:
 
  [ ... ]
   MS Office interoperability    54
   Non-English    15
   Other formats    54
  [ ... ]