Issue 112152 - Improper display of attached FIFA 2010 electronic wall paper
Summary: Improper display of attached FIFA 2010 electronic wall paper
Status: CONFIRMED
Alias: None
Product: Calc
Classification: Application
Component: open-import (show other issues)
Version: OOO320m18
Hardware: PC Windows XP
: P3 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords: needhelp, oooqa
Depends on:
Blocks:
 
Reported: 2010-06-06 05:32 UTC by sesh1989
Modified: 2013-07-06 20:01 UTC (History)
3 users (show)

See Also:
Issue Type: FEATURE
Latest Confirmation in: ---
Developer Difficulty: ---


Attachments
FIFA electronic score sheet in excel form (62.55 KB, application/octet-stream)
2010-06-06 05:37 UTC, sesh1989
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description sesh1989 2010-06-06 05:32:41 UTC
When the excel file is extracted from the attached CAB file and viewed using
version 3.2.1, several fields show ERR# while it is properly displayed in all
the Microsoft Office products starting from 2003
Comment 1 sesh1989 2010-06-06 05:37:27 UTC
Created attachment 69824 [details]
FIFA electronic score sheet in excel form
Comment 2 Rainer Bielefeld 2010-06-06 09:12:17 UTC
I also see "Err:508" with "Ooo 3.1.1 WIN XP DE[OOO310m19 (Build 9420)]"
The problem is detected correctly, formula in 'Knockout Stage.G26' is wrong:
=iferror(SVERWEIS(1;GroupA[#All],2,FALSE),"1A"))) has too many closing brackets

I can't decide whether that's an import problem (Formula wrong) or whether EXCEL
simply corrects the wrong formula.
Comment 3 ooo 2010-06-08 15:15:05 UTC
However, IFERROR() is not implemented, see issue 92677, and I've no idea what
the expression GroupA[#All] might be.
Comment 4 Edwin Sharp 2013-07-06 20:01:33 UTC
Function IFERROR doesn't exist in AOO -> FEATURE.