Issue 128241

Summary: 48/5000 Inserting table brings error message #REF!
Product: Writer Reporter: spinne
Component: editingAssignee: AOO issues mailing list <issues>
Status: UNCONFIRMED --- QA Contact:
Severity: Normal    
Priority: P5 (lowest) Keywords: needmoreinfo
Version: 4.1.7   
Target Milestone: ---   
Hardware: Mac   
OS: macOS 10.12   
Issue Type: DEFECT Latest Confirmation in: ---
Developer Difficulty: ---
Attachments:
Description Flags
Table 1
none
Table 2
none
Writer document
none
Table 1
none
Table 2 none

Description spinne 2019-12-15 22:32:58 UTC 
I have 2 tables, the second gets its data from the first. If I try to insert the data from the second table into a Writer document (which works, I insert the data from the first into the Writer document), I get the error message #REF! , The reference is then changed from the original "='file:///Users/spinne/Dropbox allgemein/Dropbox/Firma/Kundenabrechnungen/Material Jobs.ods'#$Phillers.A6" to "='file:///Users/spinne/Documents/'#$Phillers.A6 "changed. The reference is then no longer correct.
Unfortunately I could not find a solution to this problem, nor does it seem to have been described so far.
I hope you understood me, my english is not good, so I used the google translator.

Thank you for your work.
Comment 1 Marcus 2019-12-16 23:08:30 UTC 
Can you please add both documents as attachments? Otherwise it's hard to reproduce the problem. If they contain confidential content you can of course anonymize them first, but please make sure that the problem is still existing. Thanks
Comment 2 spinne 2019-12-17 17:51:38 UTC 
Created attachment 86785 [details]
Table 1
Comment 3 spinne 2019-12-17 17:53:04 UTC 
Created attachment 86786 [details]
Table 2
Comment 4 spinne 2019-12-17 18:09:53 UTC 
Created attachment 86787 [details]
Writer document
Comment 5 spinne 2019-12-17 18:10:26 UTC 
Created attachment 86788 [details]
Table 1
Comment 6 spinne 2019-12-17 18:10:46 UTC 
Created attachment 86789 [details]
Table 2
Comment 7 spinne 2019-12-17 18:11:35 UTC 
(In reply to Marcus from comment #1)
> Can you please add both documents as attachments? Otherwise it's hard to
> reproduce the problem. If they contain confidential content you can of
> course anonymize them first, but please make sure that the problem is still
> existing. Thanks

Done. Thanks