Bug 65606 - Bug in evaluating WEEKNUM
Summary: Bug in evaluating WEEKNUM
Status: RESOLVED FIXED
Alias: None
Product: POI
Classification: Unclassified
Component: SS Common (show other bugs)
Version: 5.0.0-FINAL
Hardware: PC All
: P2 normal (vote)
Target Milestone: ---
Assignee: POI Developers List
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2021-09-30 11:21 UTC by Axel Richter
Modified: 2021-10-08 15:36 UTC (History)
0 users


Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Axel Richter 2021-09-30 11:21:06 UTC 
If [return_type] is omitted then ist always evaluates to #VALUE error. But even if you set [return_type] then it evaluates not always correct.

See https://stackoverflow.com/questions/69388863/formula-cell-does-not-get-evaluated-until-formula-is-focussed-and-confirmed-in-e/69390917?noredirect=1#69388863 for a complete example to reproduce the issue.
Comment 1 PJ Fanning 2021-10-03 13:20:27 UTC 
I've added a few commits to try to improve things - main one is r1893852