Re: NOT OKAY

2014-10-25 Thread Larry Gusaas

On 2014-10-24, 11:17 PM Jose R R wrote:

Had not the 'curiosity' to write those words in OO until today:

Re-check:
https://pbs.twimg.com/media/B0xK0sECIAQVakq.png:large

Using default US English spell-checker that comes with 4.1.1
You should update your dictionary. Latest version, as I stated, recognizes singular and plural 
spellings.

English dictionaries for Apache OpenOffice-2014.10.01
http://extensions.openoffice.org/en/projectrelease/english-dictionaries-apache-openoffice-20141001

--
_

Larry I. Gusaas
Moose Jaw, Saskatchewan Canada
Website: http://larry-gusaas.com
"An artist is never ahead of his time but most people are far behind theirs." - 
Edgard Varese



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



Re: NOT OKAY

2014-10-25 Thread Jose R R
Thanks for the link. On the other hand, I seldom write those terms --
but from the perspective of someone who downloads the the latest OO
version, it should be assumed that *all* the default components are
updated for that release. Hence, the indignation from the original
poster is valid -- but now s/he is got your link reference to resolve
her/his issue.

On Sat, Oct 25, 2014 at 2:28 AM, Larry Gusaas  wrote:
> On 2014-10-24, 11:17 PM Jose R R wrote:
>>
>> Had not the 'curiosity' to write those words in OO until today:
>>
>> Re-check:
>> https://pbs.twimg.com/media/B0xK0sECIAQVakq.png:large
>>
>> Using default US English spell-checker that comes with 4.1.1
>
> You should update your dictionary. Latest version, as I stated, recognizes
> singular and plural spellings.
> English dictionaries for Apache OpenOffice-2014.10.01
> http://extensions.openoffice.org/en/projectrelease/english-dictionaries-apache-openoffice-20141001
>
>
> --
> _
>
> Larry I. Gusaas
> Moose Jaw, Saskatchewan Canada
> Website: http://larry-gusaas.com
> "An artist is never ahead of his time but most people are far behind
> theirs." - Edgard Varese
>
>
>
> -
> To unsubscribe, e-mail: dev-unsubscr...@openoffice.apache.org
> For additional commands, e-mail: dev-h...@openoffice.apache.org
>

Best Professional Regards.

-- 
Jose R R
http://www.metztli-it.com
-
NEW Apache OpenOffice 4.1.1! Download for GNU/Linux, Mac OS, Windows.
-
Daylight Saving Time in USA & Canada ends: Sunday, November 02, 2014
-

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



Re: NOT OKAY

2014-10-25 Thread Andrea Pescetti

Jose R R wrote:

from the perspective of someone who downloads the the latest OO
version, it should be assumed that *all* the default components are
updated for that release.


I don't have an opinion on the original post and I didn't verify the 
claim. However, just to clarify dictionary updates vs OpenOffice 
updates: dictionaries are updated every month, while OpenOffice releases 
are less frequent, one every 3-4 months; so when version 4.1.1 was 
released, last August, it bundled the dictionary that was current at 
that time; the next release will bundle the dictionary that will be 
current when we release. In the meantime, dictionary updates are 
published independently and users, with the default settings, are 
notified of the available dictionary updates when they launch OpenOffice.


Regards,
  Andrea.

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



RE: OpenOffice lost again 6000 users (was: Improved OOXML support?)

2014-10-25 Thread Dennis E. Hamilton


-Original Message-
From: Andrew Douglas Pitonyak [mailto:and...@pitonyak.org] 
Sent: Friday, October 24, 2014 22:26
To: dev@openoffice.apache.org
Subject: Re: OpenOffice lost again 6000 users (was: Improved OOXML support?)

Do you know off hand if this is through OLE or some other mechanism?

I have been handed a docx files with something embedded inside that 
prevents viewing because I do not happen to have that particular 
application installed on my computer.


   Without looking at the docx file, I have no idea.  Usually OLE objects
   still provide viewing without the OLE "host" application. An alternative 
   metafile rendition of the object's presentation is typically incorporated 
   in the DOCX (or DOC) just so that viewing is possible.  The same thing is 
   done with ODF when OLE objects are used (at least by OpenOffice.org apps).  
   Are you attempting to view the document in Microsoft Office or in Apache 
   OpenOffice?  

   I see that I should have been more nuanced about "ridiculous practice."
   I meant for malicious purposes.  Of course, there are thoughtless practices 
   where uses expect that anything that works for them will work for recipients
   of their document files. I recall folks who would email Microsoft Publisher 
   documents to lists of users with no idea that recipients could not read those
   attachments. The rise of PDF has repaired that particular situation, but many
   creators of DOCX files can fall into the same "works-for-me" pitfall.  I 
   still get TIFF attachments from Macintosh users and it is a pain to arrange 
   to view them (not all of TIFFs many options being handled by all TIFF 
viewers).
   Of course, if a document depends on installed extensions, we have the same
   problems in interchange among Office users and OpenOffice users.

   As you know, there are many more cases of naïve use that impede
   collaboration via editable forms of documents.  Simply having 
   styles used consistently is a problem for some meticulous document
   creators.

   What I find missing in the current document-interchange situation is the
   availability of enforceable templates that deny the use of features not
   provided for in a template-controlled profile.  This would stamp out a
   variety of evils, but there is a downside too, since it takes power 
   users to create them and fend of "why can't I ... ?" questions.


On 10/25/2014 12:50 AM, Dennis E. Hamilton wrote:
> To be clear, I can put a complete Word Document (as a binary blob) inside of 
> an ODF Text document too.  I just don't know if that particular avenue is 
> what was taken as a smoking gun about OOXML or not.  I can put a complete ODF 
> Text document (as a binary blob) inside of an OOXML .docx too.
>
> The fact that this is possible is no blemish on either of the ODF and OOXML 
> specifications.  It is not something anyone makes ridiculous practice of.
>
>   - Dennis

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


-
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: OpenOffice lost again 6000 users (was: Improved OOXML support?)

2014-10-25 Thread Dennis E. Hamilton

-Original Message-
From: Andrew Douglas Pitonyak [mailto:and...@pitonyak.org] 
Sent: Friday, October 24, 2014 22:23
To: dev@openoffice.apache.org
Subject: Re: OpenOffice lost again 6000 users (was: Improved OOXML support?)


On 10/24/2014 08:50 PM, Dennis E. Hamilton wrote:
>  below.
> -Original Message-
> From: Andrew Douglas Pitonyak [mailto:and...@pitonyak.org]
> Sent: Friday, October 24, 2014 17:27
> To: dev@openoffice.apache.org
> Subject: Spam (9.566):Re: OpenOffice lost again 6000 users (was: Improved 
> OOXML support?)
>
>
> On 10/24/2014 11:42 AM, Dennis E. Hamilton wrote:
>>  below.
>>
>> -Original Message-
>> From: Andrew Douglas Pitonyak [mailto:and...@pitonyak.org]
>> Sent: Friday, October 24, 2014 06:18
>> To: dev@openoffice.apache.org
>> Subject: Re: OpenOffice lost again 6000 users (was: Improved OOXML support?)
>>
>>
> [ ... ]
>> I am not overly informed on this, but, I think that the primary
>> complaint was that the OOXML ISO standard supports storing proprietary
>> binary blobs that are not part of the standard as aprt of the document.
>>
>   [ ... ]
> More specifically, I was under the impression that you could include a
> binary blob of say a doc file.
>
> 
> More specifically, can you point me to an authoritative source
> For this claim?
>   I don't want to take a search of the OOXML specification
> without some specific details.
> 
>

Well, there was a time that I spent many hours worrying about exactly 
what was in the standard. I had downloaded a bunch of files and spent 
time reading them and following the discussion. If you want 
authoritative documents, you can find them places such as here:

http://www.iso.org/iso/iso_catalogue/catalogue_tc/catalogue_detail.htm?csnumber=51463
http://standards.iso.org/ittf/PubliclyAvailableStandards/index.html 
(search for 29500)
http://msdn.microsoft.com/en-us/library/office/gg607163%28v=office.14%29.aspx#IIOXML_H2

But I don't think that is what you are asking... I think that you are 
asking either:

Am I able to point you to a more authoritative source that says that 
people were concerned that the standard allowed embedding arbitrary MSO 
binary stuff into OOXML files?

or

Are there concerns well founded?

Let me start by stating that my intent was to clarify their concerns. At 
this point I hardly care if their concerns are accurate and I have no 
desire to justify them or defend them. Why? Because I am just too busy 
to care about it. If I bang my head against the wall and take a stiff 
drink, I have vague recollections of an xlink attribute that may end up 
referencing a binary version of the document, which, as an end result, 
means that supporting OOXML implies that you also support all previous 
MSO document formats. I am unable without more study than I am willing 
to undertake to remember if that is all linked using OLE or something 
else. I only say this because I suspect that it is likely related to 
OLE, but I don't really remember anyone saying as much.

I don't like that OOXML relies so heavily on embedding OLE objects (I 
think that you can do this sort of thing using ODF as well).


I have all of the standards.  My question is more about what 
specifically in the OOXML specification was the source of alarm.  
For example, if it is about the OPC section, that doesn't matter - 
OPC is a generic container, just like the ODF package is a generic 
container.  If it is about a specific provision of WordProcessing 
ML, or Spreadsheet ML, I am curious whether it is beyond the obvious 
ones, like use of OLE objects in both specifications.

I am not concerned about those who took alarm but about the reality 
of the provision was that was used as evidence that OOXML was unworthy
(without noticing that ODF has all of the same trap doors when viewed 
from the same cynical perspective).

It is not OOXML that relies on OLE so heavily as it is users of Microsoft
Office and their employment of OLE as a means of incorporating useful 
formatted/active content into their documents in a manner that allows
editing and repurposing.  That this may not be useful in a given inter-
change situation is the usual problem.  It is no different for OOXML 
than for DOC and XLS, of course.  ODF documents derived from .DOC and
.DOCX files will carry the same embedded content, and on Windows at 
least, users can use Apache OpenOffice to create exactly the same
problem.



Back when I was blowing hours trying to read through the standard (and 
yeah, I wasted probably even more time reading the ODF standard), I was 
struck by how poorly the behavior was defined for the spreadsheet 
portion. I remember, at the time, thinking that it was even worse than 
the original ODF stuff, which has been fully hammered out at this point. 
Perhaps this has been solved for OOXML as well by now, but I am surly 
not going to read that stuff again unless a reall

Re: OpenOffice lost again 6000 users (was: Improved OOXML support?)

2014-10-25 Thread Jörg Schmidt

> From: Jürgen Schmidt [mailto:jogischm...@gmail.com] 

> I believe a decision like the one in Berlin is always political
> motivated. See for example the upcoming discussion about the 
> same topic
> in Munich after changes in the administration.

You're absolutely right, but what can we do about it? 

I know reactions of the OOo community to the former situation in Freiburg, and 
there were no optimal arguments. 

I think the key would be to get involved in politically motivated questions 
those companies in the public debate, which are sponsors and supporters of AOO.

Why Companies? 
Because companies better understand the needs of business customers.



Jörg


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



ODF Plugfest #10, London, 2014-12-08/09

2014-10-25 Thread Dennis E. Hamilton
.

An opportunity for the primary implementers of ODF to get together, explore 
some test cases, and provide a little advocacy for what the local civil 
administration authorities can count on.


 -- Dennis E. Hamilton
dennis.hamil...@acm.org+1-206-779-9430
https://keybase.io/orcmid  PGP F96E 89FF D456 628A
X.509 certs used and requested for signed e-mail




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



review requested: [Issue 118191] Red is not red enough : [Attachment 84109] suggestion of a fix, to render the colors as defined in HTML

2014-10-25 Thread bugzilla
Regina Henschel  has asked  for review:
Issue 118191: Red is not red enough
https://issues.apache.org/ooo/show_bug.cgi?id=118191

Attachment 84109: suggestion of a fix, to render the colors as defined in HTML
https://issues.apache.org/ooo/attachment.cgi?id=84109&action=edit

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



Re: Access to the list of Autofilter

2014-10-25 Thread Vladislav Stevanovic
>This is the mailing list of the developers (not macro coders).
>Register on the support forum:
> https://forum.openoffice.org/en/forum/ucp.php?mode=register

Andreas you're right, I am sorry about that.

>Filter criteria are limited to 8 criteria.
Is it capability for Autofilter?

> No macros can not access the auto-filter list.
I am not happy for that. Thanks for information.

Andrew, thanks for your respons.

Regards,
Wlada



2014-10-25 6:26 GMT+02:00 Andrew Douglas Pitonyak :

> On 10/24/2014 07:06 PM, Vladislav Stevanovic wrote:
>
>> Hello,
>>
>> Is it possible with code in Basic to access to the list of Autofilter data
>> in Calc? Reason: filtering with basic is limited maximum with 3
>> criteria...
>> Because I need more then 3 criteria I want with basic code  to use
>> filtering capability of Autofilter.
>>
>> Thanks in advance,
>> Wlada
>>
>>  First, Andreas is correct, you should post these types of questions to
> the forum not the Dev list.
>
> Second, I wrote a document called "Calc As A Simple Database" that is now
> part of the official LibreOffice documentation that has a macro called
> AddNewDatabaseRange that sets a range to use an autofilter.
>
> If you look at OOME, available from my web site, I also demonstrate how to
> create and use regular filters using macros. I expect that this is also in
> the aforementioned document.
>
> Sub AddNewDatabaseRange()
>   Dim oRange 'DatabaseRange object.
>   Dim oAddr  'Cell address range for the database range.
>   Dim oSheet 'First sheet, which will contain the range.
>   Dim oDoc   'Reference ThisComponent with a shorter name.
>
>   oDoc = ThisComponent
>   If NOT oDoc.DatabaseRanges.hasByName("MyName") Then
> oSheet = ThisComponent.getSheets().getByIndex(0)
> oRange = oSheet.getCellRangeByName("A1:F10")
> oAddr = oRange.getRangeAddress()
> oDoc.DatabaseRanges.addNewByName("MyName", oAddr)
>   End If
>   oRange = oDoc.DatabaseRanges.getByName("MyName")
>   oRange.AutoFilter = True
> End Sub
>
> --
> Andrew Pitonyak
> My Macro Document: http://www.pitonyak.org/AndrewMacro.odt
> Info:  http://www.pitonyak.org/oo.php
>
>


Re: Access to the list of Autofilter

2014-10-25 Thread Andreas Säger
Am 25.10.2014 um 20:36 schrieb Vladislav Stevanovic:

>> Filter criteria are limited to 8 criteria.
> Is it capability for Autofilter?
> 

There is no auto filter. There is only one filter for a range and the
GUI provides 3 methods (drop down, dialog, cell range) to set up this
filter. Your macro would be the 4th method then.
OpenOffice has a database component. Databases are designed to do what
so many people try so desperately to do on calculator sheets.

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



Re: NOT OKAY

2014-10-25 Thread Jose R R
On Sat, Oct 25, 2014 at 7:55 AM, Andrea Pescetti  wrote:
> Jose R R wrote:
>>
>> from the perspective of someone who downloads the the latest OO
>> version, it should be assumed that *all* the default components are
>> updated for that release.
>
>
> I don't have an opinion on the original post and I didn't verify the claim.

Indeed, the person may be a spammer who will sell performance
enhancing supplements ;-) On the other hand, those terms are also used
in the medical or health profession and... why not? A writer of XXX
movies may be using OO for his/her scripts. And etc., etc.

> However, just to clarify dictionary updates vs OpenOffice updates:
> dictionaries are updated every month, while OpenOffice releases are less
> frequent, one every 3-4 months; so when version 4.1.1 was released, last
> August, it bundled the dictionary that was current at that time;

That's the one that I verified those fe/male anatomical words against.

> the next
> release will bundle the dictionary that will be current when we release. In
> the meantime, dictionary updates are published independently and users, with
> the default settings, are notified of the available dictionary updates when
> they launch OpenOffice.

Of course, I've seen that notification multiple times as I start OO
4.1.1. Nevertheless, I am also aware of impersonator/injector programs
from US' NSA and UK's GCHQ (as well as third parties like FinFisher)
and thus I'm not in a hurry to "click" on the notification and be
taken to who knows where.

Reiterating, I had not had 'curiosity' to write those words until the
original poster in this thread complained (s/he's been provided a
relevant link to solve her/his issue, by now).

On my part, I am fine with my current default US English dictionary ;-)

Thanks for your gracious explanation, Andrea.


Best Professional Regards.

-- 
Jose R R
http://www.metztli-it.com
-
NEW Apache OpenOffice 4.1.1! Download for GNU/Linux, Mac OS, Windows.
-
Daylight Saving Time in USA & Canada ends: Sunday, November 02, 2014
-

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