Issue 18854

Summary:

Trouble in retrieving data from calc into serial letter

Product:

Writer

Reporter:

Unknown <non-migrated>

Component:

code

Assignee:

jack.warchold

Status:

CLOSED NOT_AN_OOO_ISSUE

QA Contact:

issues@sw <issues>

Severity:

Trivial

Priority:

CC:

issues

Version:

OOo 1.1 RC3

Target Milestone:

---

Hardware:

OS:

Windows 2000

Issue Type:

DEFECT

Latest Confirmation in:

---

Developer Difficulty:

---

Attachments:

Description	Flags
Sample text and calc table to show the bug - check line 49/entry 48	none

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