Return-Path: 
 <ooo-dev-return-24285-apmail-incubator-ooo-dev-archive=incubator.apache.org@incubator.apache.org>
X-Original-To: apmail-incubator-ooo-dev-archive@minotaur.apache.org
Delivered-To: apmail-incubator-ooo-dev-archive@minotaur.apache.org
Received: from mail.apache.org (hermes.apache.org [140.211.11.3])
	by minotaur.apache.org (Postfix) with SMTP id 85BF6D0C9
	for <apmail-incubator-ooo-dev-archive@minotaur.apache.org>;
 Sat, 11 Aug 2012 16:47:44 +0000 (UTC)
Received: (qmail 65513 invoked by uid 500); 11 Aug 2012 16:47:44 -0000
Delivered-To: apmail-incubator-ooo-dev-archive@incubator.apache.org
Received: (qmail 65437 invoked by uid 500); 11 Aug 2012 16:47:44 -0000
Mailing-List: contact ooo-dev-help@incubator.apache.org; run by ezmlm
Precedence: bulk
List-Help: <mailto:ooo-dev-help@incubator.apache.org>
List-Unsubscribe: <mailto:ooo-dev-unsubscribe@incubator.apache.org>
List-Post: <mailto:ooo-dev@incubator.apache.org>
List-Id: <ooo-dev.incubator.apache.org>
Reply-To: ooo-dev@incubator.apache.org
Delivered-To: mailing list ooo-dev@incubator.apache.org
Received: (qmail 65427 invoked by uid 99); 11 Aug 2012 16:47:44 -0000
Received: from minotaur.apache.org (HELO minotaur.apache.org) (140.211.11.9)
    by apache.org (qpsmtpd/0.29) with ESMTP; Sat, 11 Aug 2012 16:47:44 +0000
Received: from localhost (HELO mail-vb0-f47.google.com) (127.0.0.1)
  (smtp-auth username robweir, mechanism plain)
  by minotaur.apache.org (qpsmtpd/0.29) with ESMTP;
 Sat, 11 Aug 2012 16:47:43 +0000
Received: by vbbfr13 with SMTP id fr13so2429613vbb.6
        for <multiple recipients>; Sat, 11 Aug 2012 09:47:42 -0700 (PDT)
MIME-Version: 1.0
Received: by 10.52.94.35 with SMTP id cz3mr4582637vdb.100.1344703662411; Sat,
 11 Aug 2012 09:47:42 -0700 (PDT)
Received: by 10.220.31.137 with HTTP; Sat, 11 Aug 2012 09:47:42 -0700 (PDT)
In-Reply-To: 
 <CAP-ksoh5Na2ifF2K_M6_3cFO_vSA0unrcttF33LQ2akCaSoS+g@mail.gmail.com>
References: 
 <CAP-ksohAGD_iu0RQ+Sm8yG3LPJNLY+y32_9T66ZVAgn=_Xi=wA@mail.gmail.com>
	<k040lj$er0$1@dough.gmane.org>
	<CAP-ksoh5Na2ifF2K_M6_3cFO_vSA0unrcttF33LQ2akCaSoS+g@mail.gmail.com>
Date: Sat, 11 Aug 2012 12:47:42 -0400
Message-ID: 
 <CAP-ksohb9OT9YD95+AMhZjzKdKS3OFR0B8bdTwR1NOJi3VF81Q@mail.gmail.com>
Subject: Re: Yes. You can do this with OpenOffice. (MysteryGuitarMan video
 with OpenOffice Mac)
From: Rob Weir <robweir@apache.org>
To: ooo-dev@incubator.apache.org, ooo-users@incubator.apache.org
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: quoted-printable

On Fri, Aug 10, 2012 at 6:39 PM, Rob Weir <robweir@apache.org> wrote:
> On Fri, Aug 10, 2012 at 6:06 PM, Andreas S=C3=A4ger <villeroy@t-online.de=
> wrote:
>> Am 10.08.2012 02:24, Rob Weir wrote:
>>>
>>>
>>> And here is the "behind the scenes" video that explains how he did it:
>>>
>>> http://www.youtube.com/watch?v=3D6PCTinsZ7dM
>>>
>>
>> Having a video converter which creates the coarse pixel frames, all you =
need
>> is one matrix of color values per frame and script to dump them into the
>> Calc document.
>>
>> Matrix of 16 colors calculated from 32x32 random values:
>>>
>>> http://www.mediafire.com/file/zfw69gddrcwacoc/PixelMatrix.ods
>>
>
> Cool.  How would we get the pixel level numeric data into the
> spreadsheet initially?  I assume there is nothing in the macro
> language that can parse image data at that level. So we'd need to call
> out to a helper library?
>
> Also, one other nice time to have -- not strictly necessary, but would
> improve the results -- picking an optimal color palette that best
> matches the colors in the original image.  There are some standard
> algorithms for this:  http://en.wikipedia.org/wiki/Color_quantization
>

Is there any interest in making a more formal contest out of this?

I don't know what we can offer the winner other then eternal fame and
glory, but a contest could look like this:

1) Goal is to using OpenOffice Calc to automate conversion of a given
image into cell-based artwork, using background colors.  Variable
character data in cells may also be used (optional) as an
anti-aliasing technique.

2) Code would need to be based on AOO Calc 3.4.0, using
macros/scripts.  Calls to external non script code would be permitted
only for the initial extraction of pixel data from the image.  All
code would need to be made available for the judges to review.

3) Some images would be provided in advance.  Others images would be
unknown to the contestants and would be run only after the code was
submitted.

4) Judges would score all submissions based on rendering quality,
speed and technical elegance.

If there is interest, I can work with a subset of interested parties
to define this further.  We'd do that in private, and of course those
who define the contest or judge it would be ineligible for
participating int he contest.

If something like this could be done, do we think there would be any intere=
st?

-Rob









> -Rob
>
>>
>>