https://bz.apache.org/bugzilla/show_bug.cgi?id=61472

--- Comment #6 from Dominik Stadler <dominik.stad...@gmx.at> ---
The problem happens because the first cell is a string-value via TEXT(...), but
the second cell reads it as time for the HOUR() function, which Excel seems to
somehow manage, but Apache POI does not. 

You might be able to change the first cell to be only "NOW()" and use
formatting to get the desired format display, while still keeping the
date-value as formula-result.

-- 
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscr...@poi.apache.org
For additional commands, e-mail: dev-h...@poi.apache.org

Reply via email to