You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@openoffice.apache.org by bu...@apache.org on 2014/02/21 08:43:13 UTC
[Bug 124281] New: Implement Calendar-Date-Filters for Month,
Quarter, Week and similar
https://issues.apache.org/ooo/show_bug.cgi?id=124281
Bug ID: 124281
Issue Type: FEATURE
Summary: Implement Calendar-Date-Filters for Month, Quarter,
Week and similar
Product: Calc
Version: OOo 3.4 Beta
Hardware: All
URL: https://forum.openoffice.org/en/forum/viewtopic.php?f=
9&t=66840
OS: All
Status: CONFIRMED
Severity: minor
Priority: P4
Component: editing
Assignee: issues@openoffice.apache.org
Reporter: rainerbielefeld_ooo_qa@bielefeldundbuss.de
CC: issues@openoffice.apache.org
I read this requist as "Cannot use filter for a month from birthdate" in
OpenOffice Community Forum.
Example:
Currently some chin ups are necessary to filter a column containing calendar
dates for Months. May be you have a Table with birth dates (celebrities
1.1.1930 until today) and now want to find out what will have birthday next
month "March". Most simple way would be to apply a filter for "Month=March" to
the column with the birth days, but such a filter currently is not available.
You need an extra column with function "=MONTH(birthdate)", and on that one you
can apply a filter "=3"
Excel offers a more elegant soulution:
<https://forum.openoffice.org/en/forum/download/file.php?id=18800&mode=view>
--
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.
You are watching all bug changes.
[Bug 124281] Implement Calendar-Date-Filters for Month, Quarter,
Week and similar
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=124281
Rainer Bielefeld <ra...@bielefeldundbuss.de> changed:
What |Removed |Added
----------------------------------------------------------------------------
CC| |rainerbielefeld_ooo_qa@biel
| |efeldundbuss.de
Version|OOo 3.4 Beta |OOo 3.3 or older
See Also| |https://bugs.freedesktop.or
| |g/show_bug.cgi?id=63708
--- Comment #1 from Rainer Bielefeld <ra...@bielefeldundbuss.de> ---
Similar to "LibO#63708 - FILTER: need filter view like ms excel 2007 in
libreoffice calc "
--
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.
You are watching all bug changes.