The provided spreadsheet doesn't work properly on 18.104.22.168 and 22.214.171.124 versions.
However it works fine on 126.96.36.199.
Steps to Reproduce:
1.Just open the spreadsheet.
2.In each month, the cell for the days greater than the last day of the month should be empty.
When opened with versions 188.8.131.52 and 184.108.40.206 some cells after the last day of each month, show a value when in fact they should be empty.
The result seen when open the spreadsheet with 220.127.116.11.
User Profile Reset: No
OpenGL enabled: Yes
Get spreadsheet from here: _https://files.fm/u/3xgx46h4
User-Agent: Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:57.0) Gecko/20100101 Firefox/57.0
Could you provide a test file, so we can test ?
If so, change the status field back to unconfirmed.
Created attachment 138921 [details]
I've included an url in my 1st report, but here you have the file.
I can confirm with Version: 18.104.22.168.alpha0+
Build ID: 88f6ffeb9e0c0b942c2b0bc9d60af7bb7a6caaf8
CPU threads: 4; OS: Linux 4.4; UI render: default; VCL: gtk3;
Build ID: a4d4fbeb623013f6377b30711ceedb38ea4b49f8
CPU Threads: 4; OS Version: Windows 6.2; UI Render: GL;
TinderBox: Win-x86@62-merge-TDF, Branch:libreoffice-5-2, Time: 2016-12-24_14:43:55
Locale: nl-NL (nl_NL); Calc: CL
but not in
Build ID: 5e3e00a007d9b3b6efb6797a8b8e57b51ab1f737
CPU Threads: 4; OS Version: Windows 6.2; UI Render: default;
Locale: en-US (nl_NL)
Windows is also affected -> Setting to Hardware ALL
I did look to another perpetual calendar and i found that the latest 10 cells of the month did have another formulae: as a example this one
so in your test file in cells b10 to h11: also for the other month's; there is the need of another formulae and the problem will be gone
also you change your cf for column AC and AD: "AC5:AD38" this will do the formatting and remove the others
This seems to have begun at the below commit.
Adding Cc: to XXXX ; Could you possibly take a look at this one if it's bug or not? Thanks
da7753060ea125a2bdf21e7af87367142ae59467 is the first bad commit
Author: Norbert Thiebaud <email@example.com>
Date: Sat Apr 2 21:31:18 2016 -0700
author Markus Mohrhard <firstname.lastname@example.org> 2016-02-03 20:28:40 +0100
committer Eike Rathke <email@example.com> 2016-03-31 16:13:52 +0000
commit 2c728b0ae7f52691b1a3d5ab555225f5e8ac95a5 (patch)
parent eaced256be7e5c2ebcea01d14b2f521629e22848 (diff)
tdf#93300, handle hard formatting with cond format correct
** Please read this message in its entirety before responding **
To make sure we're focusing on the bugs that affect our users today, LibreOffice QA is asking bug reporters and confirmers to retest open, confirmed bugs which have not been touched for over a year.
There have been thousands of bug fixes and commits since anyone checked on this bug report. During that time, it's possible that the bug has been fixed, or the details of the problem have changed. We'd really appreciate your help in getting confirmation that the bug is still present.
If you have time, please do the following:
Test to see if the bug is still present with the latest version of LibreOffice from https://www.libreoffice.org/download/
If the bug is present, please leave a comment that includes the information from Help - About LibreOffice.
If the bug is NOT present, please set the bug's Status field to RESOLVED-WORKSFORME and leave a comment that includes the information from Help - About LibreOffice.
Please DO NOT
Update the version field
Reply via email (please reply directly on the bug tracker)
Set the bug's Status field to RESOLVED - FIXED (this status has a particular meaning that is not
appropriate in this case)
If you want to do more to help you can test to see if your issue is a REGRESSION. To do so:
1. Download and install oldest version of LibreOffice (usually 3.3 unless your bug pertains to a feature added after 3.3) from http://downloadarchive.documentfoundation.org/libreoffice/old/
2. Test your bug
3. Leave a comment with your results.
4a. If the bug was present with 3.3 - set version to 'inherited from OOo';
4b. If the bug was not present in 3.3 - add 'regression' to keyword
Feel free to come ask questions or to say hello in our QA chat: https://kiwiirc.com/nextclient/irc.freenode.net/#libreoffice-qa
Thank you for helping us make LibreOffice even better for everyone!
LO 6.3+ behaves as described.
FWIS, cell B11 applies style cf24 with user-defined format [>0]"";[<0]"";"" while direct format is date "D".
What I don't get is why cell B11 shows direct format and C11 not.
*** This bug has been marked as a duplicate of bug 117715 ***