Issue 3178 - IBAN Validation should be supported in speadsheets (IBAN = International Bank Account Number)
Summary: IBAN Validation should be supported in speadsheets (IBAN = International Bank...
Status: CONFIRMED
Alias: None
Product: Calc
Classification: Application
Component: editing (show other issues)
Version: 605
Hardware: All All
: P3 Trivial with 4 votes (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL: http://www.ecbs.org/iban.htm
Keywords: rfe_eval_ok, third_party_support
: 3177 (view as issue list)
Depends on:
Blocks:
 
Reported: 2002-02-23 13:16 UTC by burnus
Modified: 2013-08-07 15:12 UTC (History)
1 user (show)

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

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

Note You need to log in before you can comment on or make changes to this issue.
Description burnus 2002-02-23 13:16:01 UTC 
The International Bank Account Number (IBAN, ISO 13616:1997) becomes more and
more popular. It looks like
 DE44 1001 0000 0123 4567 8910
(1)(2) (---3--) (-----4-------)

(1) ISO 3166 two-letter country code
(2) Checksum (modulo 97)
(3) Bank identifier (in Germany (BLZ) 8 characters)
(4) The account number (in Germany 10 characters)
The IBAN is up to 35 characters long.

Since the IBAN contains a checksum, it would be nice if the spreadsheed whould
allow to check whether an entered IBAN is valid.
The IBAN is used in twenty (European) countries and will replace (in the
longterm) the domestic account number.
Comment 1 burnus 2002-02-23 13:25:34 UTC 
The implementational details can be found in
http://www.ecbs.org/Download/EBS204_V3.PDF pages 12 to 14
Comment 2 frank 2002-02-25 08:37:52 UTC 
*** Issue 3177 has been marked as a duplicate of this issue. ***
Comment 3 frank 2002-02-25 08:38:37 UTC 
Hi Falko,

it's up to you.

Frank
Comment 4 falko.tesch 2003-09-29 10:52:18 UTC 
The International Bank Account Number (IBAN, ISO 13616:1997) becomes
more and more popular. It looks like
 DE44 1001 0000 0123 4567 8910
(1)(2) (---3--) (-----4-------)

(1) ISO 3166 two-letter country code
(2) Checksum (modulo 97)
(3) Bank identifier (in Germany (BLZ) 8 characters)
(4) The account number (in Germany 10 characters)
The IBAN is up to 35 characters long.

Since the IBAN contains a checksum, it would be nice if the
spreadsheed whould allow to check whether an entered IBAN is valid.
The IBAN is used in twenty (European) countries and will replace (in
the longterm) the domestic account number.
Comment 5 falko.tesch 2003-09-29 10:53:01 UTC 
started
Comment 6 erwin.tenhumberg 2004-09-30 14:29:34 UTC 
enhanced summary, set keywords and reassigned issue according to RFE process
Comment 7 ace_dent 2008-05-16 00:37:59 UTC 
OpenOffice.org Issue Tracker - Feedback Request.

The Issue you raised is currently assigned to 'Requirements' pending review, but
has not been updated within the last 3 years. Please consider re-testing with
one of the latest versions of OOo, as the problem(s) may have already been
addressed. Either use the recent stable version:
http://download.openoffice.org/index.html
or consider trying the new OOo 3 BETA (still in testing):
http://download.openoffice.org/3.0beta/
 
Please report back the outcome so this Issue may be Closed or Progressed as
necessary - otherwise it may be Resolved as Invalid in the future. You may also
wish to search for (and note) any duplicates of this Issue that may have
advanced further by checking the Issue Tracker:
http://www.openoffice.org/issues/query.cgi
 
Many thanks,
Andrew
 
Cleaning-up and Closing old Issues as part of:
~ The Grand Bug Squash, pre v3 ~
http://marketing.openoffice.org/3.0/announcementbeta.html