Issue 128241 - 48/5000 Inserting table brings error message #REF!
Summary: 48/5000 Inserting table brings error message #REF!
Status: UNCONFIRMED
Alias: None
Product: Writer
Classification: Application
Component: editing (show other issues)
Version: 4.1.7
Hardware: Mac macOS 10.12
: P5 (lowest) Normal (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords: needmoreinfo
Depends on:
Blocks:
 
Reported: 2019-12-15 22:32 UTC by spinne
Modified: 2019-12-17 18:11 UTC (History)
0 users

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

Attachments
Table 1 (94.22 KB, application/vnd.oasis.opendocument.spreadsheet)
2019-12-17 17:51 UTC, spinne 		no flags Details
Table 2 (55.76 KB, application/vnd.oasis.opendocument.spreadsheet)
2019-12-17 17:53 UTC, spinne 		no flags Details
Writer document (277.59 KB, application/vnd.oasis.opendocument.text)
2019-12-17 18:09 UTC, spinne 		no flags Details
Table 1 (108.62 KB, application/vnd.oasis.opendocument.spreadsheet)
2019-12-17 18:10 UTC, spinne 		no flags Details
Table 2 (58.83 KB, application/vnd.oasis.opendocument.spreadsheet)
2019-12-17 18:10 UTC, spinne 		no flags Details
Show Obsolete (2) 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 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