[Libreoffice-bugs] [Bug 138070] CELL function does not work as described.

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=138070

srdosm at email.cz changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|UNCONFIRMED                 |NEW
     Ever confirmed|0                           |1

--- Comment #3 from srdosm at email.cz ---
Thanks for the message Jerzy,

I can confirm that it depends on that in which cell the CELL () function is
used against the source data. If the reference is horizontal it only works as
in described only if it is used in the same columns, otherwise it returns
#VALUE. If the reference to cells is vertical, it only works if it is in the
same rows, otherwise it returns also #VALUE.

The description of the function, is here
"https://help.libreoffice.org/Calc/Information_Functions#CELL".

I reproduced the bug in versions:

[Version: 7.1.0.0.alpha1+ (x64)
Build ID: 00e5c63c35307faacf76a5e2ca7953c4208244ed
CPU threads: 4; OS: Windows 10.0 Build 18363; UI render: Skia/Raster; VCL: win
Locale: cs-CZ (cs_CZ); UI: en-US
Calc: CL]

[Verze: 4.1.0.1
ID sestavení: 1b3956717a60d6ac35b133d7b0a0f5eb55e9155]

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20201113/aa63c862/attachment-0001.htm>