Hi, i have a problem with a *.sxc file on import in oo 3.0.1 and 3.x
the formula =WENN(ISTNV(SVERWEIS(D9;Feiertage;2;0));"";SVERWEIS(D9;Feiertage;2;0)) will display "Err:504" - same file will open with oo 2.4.2 without any problems ... replacing the named range "Feiertage" with the cell range "$x.$D$230:$E$245" in oo 1.15 before lets oo 3.x import without the error ... =WENN(ISTNV(SVERWEIS(D9;$x.$D$230:$E$245;2;0));"";SVERWEIS(D9;$x.$D$230:$E$245;2;0)) any hints what wrong here ??? Oliver -- GnuPG key 0xCFD04A45: 8822 057F 4956 46D3 352C 1A06 4E2C AB40 CFD0 4A45
signature.asc
Description: OpenPGP digital signature
