[ale] A Real Sad Loss for Open Source in the Atlanta Area

Greg Freemyer greg.freemyer at gmail.com
Thu Oct 14 16:49:17 EDT 2010


Here's a simple one.

In Excel 2007 I can go through a list of items and highlight them with
different background cell colors to represent different categories.

Then I can use the filter feature to display only rows of specific
background cell colors.  Or I can sort them by background cell color.

I'm pretty sure neither of those can be done in OO.

fyi, I actually use that feature fairly often.  I do so by creating a
spreadsheet with thousands of rows, sending it to a client and have them
categorize the data by highlighting them appropriate colors.  Then when I
get the spreadsheet back I sort them by color and break apart the data into
different tabs.

Obviously there are other ways to do this, but that is how we do it and is
one simple example of a missing feature.  I suspect there are hundreds
more.  You may be surprised how functional Excel is.

Greg

On Thu, Oct 14, 2010 at 4:08 PM, Sparr <sparr0 at gmail.com> wrote:

> So then load Excel and OOCalc on the same machine, load the document
> in both, and put her at the keyboard. Tell her to do the thing in
> Excel that doesn't work in OO. Come on people, this is troubleshooting
> 101.
>
> On Thu, Oct 14, 2010 at 3:59 PM, Chris Fowler
> <cfowler at outpostsentinel.com> wrote:
> > On Thu, 2010-10-14 at 15:35 -0400, Michael B. Trausch wrote:
> >> So, I'm going to ask, _what_ is it that it doesn't support?  If there
> >> is
> >> something that it legitimately doesn't support, have you filed any bug
> >> report or asked someone who understands the issue to document and file
> >> one?  If not, why not?
> >
> > I will load up one of her spread sheets at test it.  I do not know
> > enough of Excel to know what does not work.  She just tells me "it does
> > not work".
>
> _______________________________________________
> Ale mailing list
> Ale at ale.org
> http://mail.ale.org/mailman/listinfo/ale
> See JOBS, ANNOUNCE and SCHOOLS lists at
> http://mail.ale.org/mailman/listinfo
>



-- 
Greg Freemyer
Head of EDD Tape Extraction and Processing team
Litigation Triage Solutions Specialist
http://www.linkedin.com/in/gregfreemyer
CNN/TruTV Aired Forensic Imaging Demo -

http://insession.blogs.cnn.com/2010/03/23/how-computer-evidence-gets-retrieved/

The Norcross Group
The Intersection of Evidence & Technology
http://www.norcrossgroup.com
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mail.ale.org/pipermail/ale/attachments/20101014/af7faac7/attachment.html 


More information about the Ale mailing list