Mailing-List: contact ooo-dev-help@incubator.apache.org; run by ezmlm
Precedence: bulk
Reply-To: ooo-dev@incubator.apache.org
Received-SPF: pass (athena.apache.org: domain of dave2wave@comcast.net
 designates 76.96.27.227 as permitted sender)
Subject: Re: Yes. You can do this with OpenOffice. (MysteryGuitarMan video
 with OpenOffice Mac)
Mime-Version: 1.0 (Apple Message framework v1084)
Content-Type: text/plain; charset=us-ascii
From: Dave Fisher <dave2wave@comcast.net>
In-Reply-To: 
 <CAP-ksojGBU-XUZ8iwf5_OchqNPaZapqKarkQcyvkiOxjDMEAVw@mail.gmail.com>
Date: Fri, 10 Aug 2012 11:29:23 -0700
Cc: ooo-dev@incubator.apache.org,
 Paolo Mantovani <p_manto@libero.it>
Content-Transfer-Encoding: quoted-printable
Message-Id: <E8C63491-CF13-4D26-98F3-BEC934D3AABC@comcast.net>
References: 
 <CAP-ksohAGD_iu0RQ+Sm8yG3LPJNLY+y32_9T66ZVAgn=_Xi=wA@mail.gmail.com>
 <5024B5D8.10308@apache.org>
 <CAP-ksojGBU-XUZ8iwf5_OchqNPaZapqKarkQcyvkiOxjDMEAVw@mail.gmail.com>
To: ooo-users@incubator.apache.org


On Aug 10, 2012, at 7:05 AM, Rob Weir wrote:

> On Fri, Aug 10, 2012 at 3:18 AM, Andrea Pescetti <pescetti@apache.org> =
wrote:
>> (answering below so that Paolo gets all context; he is not subscribed =
so CC
>> him if relevant)
>>=20
>>=20
>> On 10/08/2012 Rob Weir wrote:
>>>=20
>>> If you don't know this guy's work you should really check it out.  =
He
>>> has over 2 million YouTube subscribers.  It is hard to describe, but
>>> I'd say it is 1/3 one-man band, 1/3 stop motion animation, 1/3 green
>>> screen work.  And 100% fun.
>>>=20
>>> https://www.youtube.com/user/MysteryGuitarMan
>>>=20
>>> His latest video is called "Stop-Motion Excel".  But if you look
>>> closely you see that he is actually using OpenOffice for the Mac:
>>>=20
>>> https://www.youtube.com/watch?v=3DFq9EV2fYF2E
>>>=20
>>> And here is the "behind the scenes" video that explains how he did =
it:
>>>=20
>>> http://www.youtube.com/watch?v=3D6PCTinsZ7dM
>>>=20
>>> This is a fun video and good for showing friends and family what you
>>> are working on.  Let's try to get the world out, via the social
>>> networking site, both project's and personal.   And if you want to =
add
>>> a comment to the YouTube post pointing out that this is OpenOffice =
and
>>> it can be downloaded for free from www.openoffice.org, then great!
>>> This is a good way to introduce the product to more users.
>>>=20
>>> Bonus points for adapting an old ASCII Art algorithm to generate a
>>> spreadsheet from a photo.  If anyone can do that I'll interview them
>>> for a blog post and show of their work.
>>>=20
>>> Regards,
>>>=20
>>> -Rob
>>=20
>>=20
>> Paolo Mantovani, an expert of OpenOffice macros and an OpenOffice.org
>> Conference speaker, published his "Macro and Rock&Roll" series back =
in 2008.
>> See for example
>> http://ooomacros.blogspot.it/2008/12/macro-e-rock-3_14.html
>> and the embedded AC/DC video there. It looks like he might be the man =
you
>> are looking for.
>>=20
>=20
> That's totally insane!  Great work.
>=20
> It makes me think that there could be some value in thinking "outside
> of the box" and rethinking multimedia in the context of a spreadsheet.
>=20
> For example, today the only data type a cell can contain is a number
> and a string.  Boolean and date as well, but they are just special
> kinds of numbers.
>=20
> What if we had an intrinsic data type for an image?  Or a sound clip?
> And functions that could operate on these data types.
>=20
> For example, if an image is added to a cell (via edit menu, or paste
> or drag & drop) then it can operate like a normal data type for many
> operations.
>=20
> So if there is an image in cell A1 and another in B1, then the formula
> =3D(A1+B1)/2 would yield an image that average the two.  Diffing =
images,
> scaling them, etc., have natural interpretations.
>=20
> You could even have new spreadsheet functions that operate directly on
> image data, e.g., sharpen, blur, FFT, deconvolution, etc.
>=20
> You could imagine the same with a data type for audio.

Why limit this to images and audio? Have spreadsheets store object =
references. The objects can be xml constructs. Objects implement some =
set of operators and common functions while the stubs for others =
automatically return an error.

You could return custom objects from special functions and it would be =
cool if those were drawing objects attached to the cell or range.

=3DMyHighQualityLogChart(A1,B1,C1:1000,D1:1000)

If the object type is not available on the machine then the cell is =
automatically protected. This becomes a great way to send results to =
clients.


>=20
> So this gets more similar to a Mathematica type experience, where you
> can have calculations that mix standard numerical operations, but also
> interact with multimedia, both as a source and a destination for data.
> For example, you can take a range of data, calculated based on other
> formula, and "render" it as a sound or an image.
>=20
> It is an opportunity.  Spreadsheets have not really enhance their
> basic computational model since Visicalc.

Very intriguing. People love to use spreadsheets to define business =
processes and trade analytic models.

Regards,
Dave


>=20
> -Rob
>=20
>=20
>> Regards,
>>  Andrea.
>=20
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: ooo-users-unsubscribe@incubator.apache.org
> For additional commands, e-mail: ooo-users-help@incubator.apache.org
>=20