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...@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.
