| Author |
 Topic  |
|
|
dominik.mierzwa
Poland
150 Posts |
 Posted - 07/13/2026 : 05:14:52 AM
|
Origin Ver. and Service Release (Select Help-->About Origin): 2026b PRO
Operating System: W2011 Pro
Within a single workbook (source_book), I created a new worksheet (data-1_sheet) and copied (Copy->Paste Link) some of the data from another worksheet (source_sheet) in the same workbook into it. Then I created a copy of the data--1_sheet workbook (Duplicate->data-2_sheet). I moved the copy, data-2_sheet, to a new workbook (end_book). Unfortunately, some of the links stopped working properly, and the cell address is displayed instead of the value (See below). When there are 3 correct rows (copies) of data in a column, I can “extend the formula” to the "repair" incorrect rows. But in some cases, the problem starts as early as the first row, and this method doesn’t work... Is there any way to refresh these links?
Kind regards,
Dominik |
|
|
ChaoC
USA
244 Posts |
|
|
dominik.mierzwa
Poland
150 Posts |
Posted - 07/14/2026 : 01:33:05 AM
|
Hi Chao,
I solve the problem by adding the book name to the cell:// adres, for example:
cell://[Book13]wAppend!A[2]
instead of:
cell://wAppend!A[2]
Interestingly, when I did this in the first row (the connection issue started in row 1), Origin automatically updated the remaining addresses and inserted the book name in all cells below. When the problem occurred in the middle of a column (rows 14, 15, etc.), inserting the book name into the first incorrect row did not change the others. BUT when I extended (filled down) the formula from the corrected cell to the remaining incorrect ones below, Origin naturally inserted the correct reference to a single cell (they all had the same value), and when I pressed “Undo” (Ctrl+Z), the program sort of updated the references so that each cell now had the workbook name and pointed to the correct reference... a self-correcting problem ;-) I’ll try to reproduce this again and post a video.
I’ll test the mirror function soon and let you know.
Kind regards,
Dominik |
 |
|
|
dominik.mierzwa
Poland
150 Posts |
Posted - 07/14/2026 : 05:50:02 AM
|
I was able to reproduce this error. However, since I was working with random data (not a real-world case), the error only appeared in the last row. I tried removing some data from individual columns to see if that would make a difference, but it had no effect, and the error still appeared in the last row.
BTW
How can the size of an image inserted into a post be controlled? The property [img height=xxx width=xxx] does not work.
Kind regards,
Dominik |
Edited by - dominik.mierzwa on 07/14/2026 06:23:52 AM |
|
|
|
ChaoC
USA
244 Posts |
Posted - 07/14/2026 : 11:00:09 AM
|
Hello,
Thanks for the example. I was able to reproduce and have submitted a report. Tracking is ORG-33942.
You can change image size like this:
[img=720x480]
Best,
Chao |
|
|
| |
Topic |
|
|
|
Problem with linked data