Den 2011-03-09 19:29:38 skrev Andy Graybeal <andy.grayb...@casanueva.com>:
Hello,
My organization is trying to move from MS Office to OpenOffice (or it
might be read, I'm trying to convince everyone to move from MS Office to
OpenOffice in an effort to move our business to use only open source
software).
We're using OpenOffice 3.2.0 on Ubuntu 10.04.
One of my co-workers regularly uses Excel's (2003, if I remember
correctly) Autofilter feature, and she has a different experience with
OpenOffice's Autofilter.
Here are the steps taken in Excel:
* Select a row
* We go to: Data -> Filter -> Auto Filter
* Dropdown boxes appear for every column
* We select an item from the dropdown box; this lists only the items
that have been filtered, and it gives her the chance to make a subtotal
in one of the empty row below the filter results.
Here are the steps taken in OpenOffice:
* Select a row
* We go to: Data -> Filter -> Auto Filter, it informs and asks us that
"The range does not contain column headers. Do you want the first line
to be a column header?" We select "Yes" from the dialog box.
* Dropdown boxes appear for every column
* We make a selection from a dropdown box; this lists the filtered
items and other information. She doesn't get the chance to make a
subtotal in an empty row below the filter results.
Can you help us approach the situation? Should we be doing things
differently? What is a column header and would assigning this help us?
Thanks,
Andy
”…it gives her the chance to make a subtotal…”
Since I don't have Excel I would probably need to know exactly HOW this
happens, to be able to answer the question. Is she asked in a dialogue box
or what?
Anyway, subtotals are usually calculated with the SUBTOTAL() function, so
she can always put it in a cell manually.
--
Kind regards
Johnny Rosenberg
--
------------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscr...@openoffice.org
For additional commands, e-mail: sy...@openoffice.org with Subject: help