Issue 18854 - Trouble in retrieving data from calc into serial letter
Summary: Trouble in retrieving data from calc into serial letter
Status: CLOSED NOT_AN_OOO_ISSUE
Alias: None
Product: Writer
Classification: Application
Component: code (show other issues)
Version: OOo 1.1 RC3
Hardware: PC Windows 2000
: P3 Trivial with 2 votes (vote)
Target Milestone: ---
Assignee: jack.warchold
QA Contact: issues@sw
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2003-08-30 23:38 UTC by Unknown
Modified: 2003-09-22 12:23 UTC (History)
1 user (show)

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

Attachments
Sample text and calc table to show the bug - check line 49/entry 48 (14.27 KB, application/octet-stream)
2003-09-18 18:14 UTC, Unknown 		no flags Details
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 Unknown 2003-08-30 23:38:59 UTC 
A serial letter based on an address list in calc contains a field to select the 
zip code from the appropriate column in the calc table. This works for all 
entries that only contain a number in that column. Any zip code that starts 
with a letter (for international mailing) is shown properly in the calc table 
but transfers and prints as a 0. 

The data field in the writer document contains no special formatting or any 
restrictions that I would be aware of. Definitely none have been specified by 
me. 

While this may seem a trivial error, this behaviour (in addition to other 
serial letter troubles) effectively prohibits an effective use of OOo in my  
office (or the office of the Alzheimer Society Paderborn for that matter) since 
crosschecking every address costs too much time. 

Cheers from Germany


Stephan Körting
Comment 1 jack.warchold 2003-09-09 17:54:55 UTC 
jw: reassigned to jw
Comment 2 jack.warchold 2003-09-09 17:56:06 UTC 
can you please attach the documents ?

if it has confidential data just replace all letters with x
Comment 3 Unknown 2003-09-18 18:14:00 UTC 
Created attachment 9457 [details]
Sample text and calc table to show the bug - check line 49/entry 48
Comment 4 Unknown 2003-09-18 18:16:31 UTC 
Hi there,

as requested I attached a simple sample derived from my buggy 
document. Please check line 49 (in the Writer data view it's entry 
48). Writer shows the column "Postleitzahl" as empty while calc shows 
the correct zip code "F-75017". 

Cheers from Germany! 


Stephan Körting
Comment 5 jack.warchold 2003-09-22 12:23:36 UTC 
ok that depends on the two different formattypes you choose. you have 
to set whole column to Text-format. in your spreadsheet the format is 
mixed between text (the codes with a letter) and number (the nonletter 
codes). 
after changing the column-format to text, i had to rewrite all the 
entrys to see it right in the datasourceview this might be really a 
bug.

after rewriting all the "Postleitzahlen" as textformat and save the 
file and reopen the dataview all entrys are visible.

i hope i can give you a short workarround in some hours. so that you 
do not have to rewrite all your entrys in the Postleitzahl column

set this to invalid
Comment 6 jack.warchold 2003-09-22 12:23:58 UTC 
invalid -> closed