Bug 124412 - Conditional formatting screen always shows 'Date is today' as conditional when inserting date conditional UI
Summary: Conditional formatting screen always shows 'Date is today' as conditional whe...
Status: ASSIGNED
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
4.4.7.2 release
Hardware: All All
: medium trivial
Assignee: Andreas Heinisch
URL:
Whiteboard:
Keywords: topicUI
Depends on:
Blocks: Conditional-Formatting-Editing
  Show dependency treegraph
 
Reported: 2019-03-28 23:17 UTC by matjojo
Modified: 2021-11-29 15:40 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:


Attachments
conditional format date (10.00 KB, application/vnd.oasis.opendocument.spreadsheet)
2019-03-30 14:50 UTC, Oliver Brinzing
Details

Note You need to log in before you can comment on or make changes to this bug.
Description matjojo 2019-03-28 23:17:42 UTC
Description:
Making conditions based on date always show as 'Date is today' even if the condition is not 'Date is today'.

See here: https://i.imgur.com/DLok4qV.png
And here you see condition 2 isn't really Date is today: https://i.imgur.com/aXzUHDI.png

Steps to Reproduce:
1. select a tile
2. Right mouse button on the selection, open conditional formatting
3. Create a formatting rule based on the 'Date is' version
4. Make a rule based on anything
5. Make a rule based on anything that is not 'Date is today'
6. Select the bottom condition


Actual Results:
See that the top condition now says: 'Condition # Date is today'

Expected Results:
See that the top condition now says: 'Condition # Actual condition'


Reproducible: Always


User Profile Reset: No



Additional Info:
Comment 1 Oliver Brinzing 2019-03-30 14:49:35 UTC
reproducible with:

Version: 4.4.7.2
Build-ID: f3153a8b245191196a4b6b9abd1d0da16eead600
Gebietsschema: de_DE
Comment 2 Oliver Brinzing 2019-03-30 14:50:03 UTC
Created attachment 150412 [details]
conditional format date
Comment 3 QA Administrators 2021-04-16 03:56:13 UTC Comment hidden (obsolete)
Comment 4 matjojo 2021-04-16 09:42:46 UTC
Bug is still present.
Version info from help:

Version: 7.1.2.2 (x64) / LibreOffice Community
Build ID: 8a45595d069ef5570103caea1b71cc9d82b2aae4
CPU threads: 12; OS: Windows 10.0 Build 19042; UI render: Skia/Raster; VCL: win
Locale: en-US (en_NL); UI: en-GB
Calc: threaded

Steps to reproduce:
1. select a tile
2. Click Format
3. Click Conditional
4. Click Manage
5. Click Add
6. Select condition type: "Date is"
7. Select condition: anything but "Today"
8. Click Add

Actual Results:
See that the top condition now says: 'Condition 1     Date is today'

Expected Results:
See that the top condition now says: 'Condition 1     Actual condition'