R04.07.01.04 · 任务小类

跨办公应用的链接与嵌入对象

Linked & embedded objects across office apps

Keep charts, tables and objects linked between workbooks, documents and decks and update them correctly.

20 条本项目编写的提案 · 分类 v1.1 · 新增基准运行 0 次。下方验证方式与部分得分规则是设计，不是执行结果。

典型应用: Excel · Word · PowerPoint
小类 GUI 需求标签: G2 · GUI 必要

任务提案 · 20

展开查看完整原文与建议检查方式；两种界面均保留提案英文原文。

R04.07.01.04-T01 Paste-link an Excel summary table into a Word report

原始指令

Copy range Summary!B3:F12 from input/q3_model.xlsx and paste it into input/q3_report.docx under heading 'Financial summary' as a linked object (Paste Special › Paste Link, formatted text) so it updates when the workbook changes. Save both files in place.

平台: win · Windows mac · macOS
应用: Excel · Word
交互表面: desk · 桌面 GUI
GUI 需求 · 任务设定: G2 · GUI 必要
GUI 需求 · 普通权限: CL · CLI 足够
交互原语: multi · 跨应用 click · 指向与点击
工作产物: WP01 · 文档
条件: multiapp · 多应用
提案难度: 2 / 5

建议验证方式

docx has a LINK field (Excel.Sheet.12) whose source path is q3_model.xlsx and item Summary!R3C2:R12C6, placed under the heading; grader edits 3 workbook cells, runs Word COM UpdateLinks and checks the table text changes accordingly. VBA, COM and AppleScript automation are disabled and the VM has no Python, so link and object edits must happen in the apps.

建议部分得分

40% LINK field with right source/range; 20% placement; 40% updates after source change.

R04.07.01.04-T02 Paste a linked Excel chart into a PowerPoint slide

原始指令

Copy chart 'RevenueTrend' from input/kpis.xlsx and paste it onto slide 4 of input/monthly_review.pptx keeping source formatting and linking the data, sized to the content placeholder area. Save both files in place.

平台: win · Windows mac · macOS
应用: Excel · PowerPoint
交互表面: desk · 桌面 GUI
GUI 需求 · 任务设定: G2 · GUI 必要
GUI 需求 · 普通权限: CL · CLI 足够
交互原语: multi · 跨应用 click · 指向与点击 geom · 精确几何
工作产物: WP03 · 视觉排版
条件: multiapp · 多应用
提案难度: 2 / 5

建议验证方式

Slide 4 chart part has externalData with r:id pointing to kpis.xlsx (TargetMode External) and autoUpdate settings; series refs match the source chart; frame within placeholder bounds; grader changes data and refreshes via COM: chart cache updates. VBA, COM and AppleScript automation are disabled and the VM has no Python, so link and object edits must happen in the apps.

建议部分得分

45% linked chart with right source; 20% formatting kept; 15% size; 20% refresh works.

R04.07.01.04-T03 Repoint six Word links after the source workbook moved

原始指令

input/board_memo.docx has 6 links (tables and charts) to a workbook at an old network path. The workbook now lives at input/data/board_figures_v2.xlsx. Using Edit Links to Files, change all 6 sources to the new file, update them, and keep each link's range and formatting.

平台: win · Windows mac · macOS
应用: Word · Excel
交互表面: desk · 桌面 GUI
GUI 需求 · 任务设定: G2 · GUI 必要
GUI 需求 · 普通权限: CL · CLI 足够
交互原语: click · 指向与点击 nav · 平移 / 缩放 / 滚动
工作产物: WP01 · 文档
条件: multiapp · 多应用 hidden · 隐藏 / 过期状态
提案难度: 3 / 5

建议验证方式

All 6 LINK fields/externalData targets point to board_figures_v2.xlsx with item ranges unchanged; values after update equal the new workbook; no reference to the old path anywhere in the package (grep of XML). VBA, COM and AppleScript automation are disabled and the VM has no Python, so link and object edits must happen in the apps.

建议部分得分

50% links repointed (pro-rata over 6); 30% values updated; 20% ranges/formatting preserved.

R04.07.01.04-T04 Embed an editable Excel worksheet object showing one range in Word

原始指令

In input/proposal.docx section 4, insert an embedded (not linked) Excel worksheet object containing the pricing table from input/pricing.xlsx 'Quote'!A1:E14 with its formulas, cropped so only that range shows. Recipients must be able to double-click and edit it without the source file.

平台: win · Windows mac · macOS
应用: Word · Excel
交互表面: desk · 桌面 GUI
GUI 需求 · 任务设定: G2 · GUI 必要
GUI 需求 · 普通权限: CL · CLI 足够
交互原语: multi · 跨应用 click · 指向与点击 geom · 精确几何
工作产物: WP01 · 文档
条件: multiapp · 多应用
提案难度: 3 / 5

建议验证方式

docx has an embedded package (Excel.Sheet.12 OLE object) in section 4; embedded workbook contains the range with formulas (openpyxl data_only=False); visible area (oleObject extent/ProgID visible range) equals A1:E14; no external link. VBA, COM and AppleScript automation are disabled and the VM has no Python, so link and object edits must happen in the apps.

建议部分得分

40% embedded object present; 30% formulas inside; 20% visible range; 10% no link.

R04.07.01.04-T05 Refresh eight linked charts and break links on two

原始指令

input/sales_deck.pptx has 8 charts linked to input/sales_data.xlsx. Paste October data into the workbook's 'Monthly' table (from input/october.csv), refresh all 8 charts in PowerPoint, then break the link on the charts on slides 7 and 8 so they keep October values as standalone embedded charts.

平台: win · Windows mac · macOS
应用: PowerPoint · Excel
交互表面: desk · 桌面 GUI
GUI 需求 · 任务设定: G2 · GUI 必要
GUI 需求 · 普通权限: CL · CLI 足够
交互原语: multi · 跨应用 click · 指向与点击
工作产物: WP03 · 视觉排版
条件: multiapp · 多应用
提案难度: 3 / 5

建议验证方式

Workbook table includes October; 8 chart caches contain October values; slides 7–8 charts have no external link but embedded workbooks with October data; slides 1–6 charts still linked. VBA, COM and AppleScript automation are disabled and the VM has no Python, so link and object edits must happen in the apps.

建议部分得分

20% source updated; 40% charts refreshed; 30% two links broken correctly; 10% others still linked.

R04.07.01.04-T06 Link ten inline numbers in report sentences to workbook cells

原始指令

input/annual_letter.docx has 10 numbers inside sentences highlighted yellow. Replace each with a paste-linked value (unformatted text) from the cell named in input/number_map.csv in input/annual_model.xlsx so the sentence keeps its formatting, then remove the highlights.

平台: win · Windows mac · macOS
应用: Word · Excel
交互表面: desk · 桌面 GUI
GUI 需求 · 任务设定: G2 · GUI 必要
GUI 需求 · 普通权限: CL · CLI 足够
交互原语: multi · 跨应用 click · 指向与点击 type · 文字与表单
工作产物: WP01 · 文档
条件: multiapp · 多应用
提案难度: 3 / 5

建议验证方式

10 LINK fields with \t (text) switch pointing to the mapped cells, in place of the highlighted numbers; surrounding run formatting intact; highlights removed; grader changes the cells, updates links, and checks text updates. VBA, COM and AppleScript automation are disabled and the VM has no Python, so link and object edits must happen in the apps.

建议部分得分

50% ten links correct (pro-rata); 20% formatting intact; 10% highlights removed; 20% update test.

R04.07.01.04-T07 Link a Calc range into a Writer document in LibreOffice

原始指令

In LibreOffice, insert range Budget!A1:D20 of input/budget.ods into input/grant_narrative.odt section 'Budget' as a linked object (DDE link via Paste Special) so changes in Calc flow into Writer after Edit › Links › Update. Save both.

平台: lin · Linux mac · macOS win · Windows
应用: LibreOffice
交互表面: desk · 桌面 GUI
GUI 需求 · 任务设定: G2 · GUI 必要
GUI 需求 · 普通权限: CL · CLI 足够
交互原语: multi · 跨应用 click · 指向与点击
工作产物: WP01 · 文档
条件: multiapp · 多应用
提案难度: 3 / 5

建议验证方式

ODT content has a DDE connection (text:dde-connection-decl) to budget.ods with the right range; grader edits 2 cells via UNO, triggers link update, and checks the table text changes. Macros, UNO and the soffice CLI are disabled for the agent.

建议部分得分

45% DDE link with right range; 20% placement; 35% update works.

R04.07.01.04-T08 Insert a theme-matched linked chart into Word and update it

原始指令

Copy chart 'Headcount' from input/hr_dash.xlsx into input/hr_report.docx using 'Use Destination Theme & Link Data'. Then, in Excel, add the 2026-Q3 column to the chart's source range so the chart includes it, and update the Word chart so it shows 7 quarters.

平台: win · Windows mac · macOS
应用: Word · Excel
交互表面: desk · 桌面 GUI
GUI 需求 · 任务设定: G2 · GUI 必要
GUI 需求 · 普通权限: G2 · GUI 必要
交互原语: multi · 跨应用 click · 指向与点击
工作产物: WP01 · 文档
条件: multiapp · 多应用
提案难度: 3 / 5

建议验证方式

Word chart part has external link to hr_dash.xlsx; series use destination theme colors (schemeClr accents); chart cache has 7 categories incl. 2026-Q3 with values equal the workbook. VBA, COM and AppleScript automation are disabled and the VM has no Python, so link and object edits must happen in the apps.

建议部分得分

35% linked with destination theme; 30% source range extended; 35% Word chart updated.

R04.07.01.04-T09 Embed an editable PowerPoint org-chart slide inside a Word document

原始指令

Embed slide 3 (org chart) of input/team_overview.pptx into input/handbook.docx page 2 as an editable PowerPoint slide object, then edit the embedded slide in place to change 'Team Lead (vacant)' to 'Team Lead: Priya Rao'. The original .pptx must stay unchanged.

平台: win · Windows mac · macOS
应用: Word · PowerPoint
交互表面: desk · 桌面 GUI
GUI 需求 · 任务设定: G2 · GUI 必要
GUI 需求 · 普通权限: CL · CLI 足够
交互原语: multi · 跨应用 click · 指向与点击 type · 文字与表单
工作产物: WP01 · 文档
条件: multiapp · 多应用
提案难度: 3 / 5

建议验证方式

docx has an embedded PowerPoint.Slide.12 package whose single slide matches slide 3 with the edited text; preview image (EMF) shows the new text (OCR); original pptx hash unchanged. VBA, COM and AppleScript automation are disabled and the VM has no Python, so link and object edits must happen in the apps.

建议部分得分

40% embedded slide object; 35% in-place edit in package; 15% preview updated; 10% original untouched.

R04.07.01.04-T10 Roll a monthly report pack forward to new workbook copies

原始指令

input/sept_pack/report.docx has 12 links to 3 workbooks in input/sept_pack/. Create input/oct_pack/ with copies of all 4 files, repoint every link in the October report to the October workbooks (not September), paste October data from input/oct_data/ into those workbooks, update all links and change the report month text.

平台: win · Windows mac · macOS
应用: Word · Excel
交互表面: desk · 桌面 GUI
GUI 需求 · 任务设定: G2 · GUI 必要
GUI 需求 · 普通权限: CL · CLI 足够
交互原语: multi · 跨应用 nav · 平移 / 缩放 / 滚动 click · 指向与点击
工作产物: WP09 · 文件与文件夹
条件: multiapp · 多应用 hidden · 隐藏 / 过期状态 long · 长流程
提案难度: 5 / 5

建议验证方式

oct_pack report: 12 links target oct_pack workbooks; zero references to sept_pack paths; linked values equal October data; September files unchanged (hashes); month text updated. VBA, COM and AppleScript automation are disabled and the VM has no Python, so link and object edits must happen in the apps.

建议部分得分

15% folder copied; 40% links repointed; 25% October data flows through; 20% September untouched and month text updated.

R04.07.01.04-T11 Relink five broken chart links after a SharePoint migration

原始指令

In input/ops_review.pptx, 5 linked charts show 'linked file not available' because they pointed to SharePoint URLs. Relink each to the matching workbook in input/local_data/ (by chart title), update them, and keep each chart's size, position and formatting.

平台: win · Windows mac · macOS
应用: PowerPoint · Excel
交互表面: desk · 桌面 GUI
GUI 需求 · 任务设定: G2 · GUI 必要
GUI 需求 · 普通权限: CL · CLI 足够
交互原语: click · 指向与点击 nav · 平移 / 缩放 / 滚动 multi · 跨应用
工作产物: WP03 · 视觉排版
条件: multiapp · 多应用 hidden · 隐藏 / 过期状态
提案难度: 4 / 5

建议验证方式

5 chart externalData targets are local files matching by title; caches equal those workbooks; graphicFrame xfrm unchanged (±0.01 in); no SharePoint URLs remain in rels. VBA, COM and AppleScript automation are disabled and the VM has no Python, so link and object edits must happen in the apps.

建议部分得分

50% charts relinked correctly; 25% values updated; 15% geometry kept; 10% no old URLs.

R04.07.01.04-T12 Make a linked Word table follow a named range that grows

原始指令

input/inventory_report.docx links to Stock!A1:F40 in input/inventory.xlsx, but rows are added monthly. Define a dynamic named range 'StockTable' in the workbook covering the table's current rows, change the Word link to use that name, keep \* MERGEFORMAT formatting, and update.

平台: win · Windows
应用: Word · Excel
交互表面: desk · 桌面 GUI
GUI 需求 · 任务设定: G2 · GUI 必要
GUI 需求 · 普通权限: CL · CLI 足够
交互原语: multi · 跨应用 type · 文字与表单 click · 指向与点击
工作产物: WP01 · 文档
条件: multiapp · 多应用
提案难度: 3 / 5

建议验证方式

Workbook defined name StockTable with dynamic formula; Word LINK field item = 'StockTable' with \* MERGEFORMAT; grader appends 5 rows, updates link via COM: Word table has 45 data rows with right values. VBA is disabled and the agent VM has no COM host or Python, so link and object edits must happen in the apps.

建议部分得分

30% dynamic name; 35% link uses name; 15% formatting switch; 20% grows correctly.

R04.07.01.04-T13 Finalize a document by breaking links but keeping editable charts

原始指令

Prepare input/final_report.docx for external release: break every link to workbooks (tables become static, charts keep embedded data so recipients can still edit them), remove file paths from document properties and field codes, and save output/final_report_external.docx. Values must stay as currently displayed.

平台: win · Windows mac · macOS
应用: Word · Excel
交互表面: desk · 桌面 GUI
GUI 需求 · 任务设定: G2 · GUI 必要
GUI 需求 · 普通权限: CL · CLI 足够
交互原语: click · 指向与点击 nav · 平移 / 缩放 / 滚动
工作产物: WP01 · 文档
条件: multiapp · 多应用
提案难度: 4 / 5

建议验证方式

No LINK fields or External relationships remain; chart parts have embedded workbooks with current values; table text equals pre-break values; no local paths in docProps or XML (regex for drive letters/'/Users/'). VBA, COM and AppleScript automation are disabled and the VM has no Python, so link and object edits must happen in the apps.

建议部分得分

35% links broken; 30% charts editable with data; 20% values unchanged; 15% paths scrubbed.

R04.07.01.04-T14 Build a fully linked model-to-deck-and-report chain

原始指令

From input/plan_model.xlsx build output/plan_deck.pptx (6 linked charts per input/deck_spec.md) and output/plan_memo.docx (4 linked tables and 8 inline linked numbers per input/memo_spec.md), all paths relative to output/. The grader will change model inputs and press Update Links; every object must follow.

平台: win · Windows
应用: Excel · PowerPoint · Word
交互表面: desk · 桌面 GUI
GUI 需求 · 任务设定: G2 · GUI 必要
GUI 需求 · 普通权限: CL · CLI 足够
交互原语: multi · 跨应用 click · 指向与点击 geom · 精确几何
工作产物: WP03 · 视觉排版
条件: multiapp · 多应用 long · 长流程
提案难度: 5 / 5

建议验证方式

Object inventory equals spec (types, source ranges); grader changes 5 inputs, recalcs, updates links in both files via COM; every chart cache, table and inline number equals the new model outputs. VBA is disabled and the agent VM has no COM host or Python, so link and object edits must happen in the apps.

建议部分得分

30% deck charts; 30% memo tables; 20% inline numbers; 20% end-to-end update test.

R04.07.01.04-T15 Make a linked report package work after moving to a Mac

原始指令

input/win_package/ holds report.docx linked to 2 workbooks via Windows paths (C:\Reports\…). On macOS, repoint every link to the copies in the same folder, update them, and verify all values refresh; save so the package works from its current location.

平台: mac · macOS
应用: Word · Excel
交互表面: desk · 桌面 GUI
GUI 需求 · 任务设定: G2 · GUI 必要
GUI 需求 · 普通权限: CL · CLI 足够
交互原语: click · 指向与点击 nav · 平移 / 缩放 / 滚动
工作产物: WP09 · 文件与文件夹
条件: multiapp · 多应用 hidden · 隐藏 / 过期状态
提案难度: 4 / 5

建议验证方式

All link targets resolve to files inside the package folder (POSIX paths); no 'C:\' targets remain; grader edits values on a Mac runner, updates links via AppleScript-driven Word: values follow. VBA and osascript/JXA are disabled and the VM has no Python, so link and object edits must happen in Word and Excel.

建议部分得分

50% links repointed; 20% no Windows paths; 30% refresh works.

R04.07.01.04-T16 Audit and modernize 23 embedded objects in a 90-page manual

原始指令

input/legacy_manual.docx (90 pages) has 23 embedded objects: Excel sheets, charts, PowerPoint slides, a PDF and 6 legacy Equation 3.0 objects. Convert the equations to native Word equations, update the 4 embedded Excel tables with input/new_specs.xlsx values, and list all objects (page, type, action) in output/object_inventory.csv.

平台: win · Windows
应用: Word · Excel
交互表面: desk · 桌面 GUI
GUI 需求 · 任务设定: G2 · GUI 必要
GUI 需求 · 普通权限: G2 · GUI 必要
交互原语: click · 指向与点击 nav · 平移 / 缩放 / 滚动 multi · 跨应用
工作产物: WP01 · 文档
条件: multiapp · 多应用 long · 长流程
提案难度: 5 / 5

建议验证方式

No Equation.3 OLE objects; 6 OMML equations whose math equals originals; 4 embedded workbooks contain new values and their previews show them (OCR); inventory precision/recall vs 23 objects. VBA is disabled and the agent VM has no COM host or Python, so link and object edits must happen in the apps.

建议部分得分

35% equations converted; 30% embedded tables updated; 35% inventory.

R04.07.01.04-T17 Control pair of T03: rewrite link targets in the DOCX package by script

原始指令

Control pair of T03. From the terminal, rewrite the 6 external link targets and LINK field paths in input/board_memo.docx to input/data/board_figures_v2.xlsx by editing the package XML, and confirm with a script that no old paths remain. Cached values need not refresh.

平台: mac · macOS win · Windows lin · Linux
应用: Python · lxml
交互表面: term · 终端
GUI 需求 · 任务设定: CL · CLI 足够
GUI 需求 · 普通权限: CL · CLI 足够
交互原语: code · 代码与命令
工作产物: WP01 · 文档
条件: 未声明
提案难度: 2 / 5

建议验证方式

Same path checks as T03 (6 targets, no old path); value refresh not required, highlighting what only the app can do; compared with T03.

建议部分得分

70% six targets rewritten; 30% no old paths remain.

R04.07.01.04-T18 Chain Excel linked pictures into a PowerPoint dashboard slide

原始指令

In input/dash.xlsx create a linked picture (camera) of 'Calc'!B2:H9 on sheet 'Dashboard', then paste that dashboard region into slide 2 of input/exec_brief.pptx as a linked picture so updates to 'Calc' propagate to both. Save both.

平台: win · Windows
应用: Excel · PowerPoint
交互表面: desk · 桌面 GUI
GUI 需求 · 任务设定: G2 · GUI 必要
GUI 需求 · 普通权限: G2 · GUI 必要
交互原语: multi · 跨应用 click · 指向与点击 geom · 精确几何
工作产物: WP03 · 视觉排版
条件: multiapp · 多应用
提案难度: 4 / 5

建议验证方式

Excel drawing has a picture with formula ='Calc'!$B$2:$H$9; slide 2 has a linked picture/OLE link to dash.xlsx Dashboard range; grader changes Calc cells and updates: rendered slide region shows new values (OCR). VBA is disabled and the agent VM has no COM host or Python, so link and object edits must happen in the apps.

建议部分得分

35% Excel linked picture; 35% PowerPoint link; 30% propagation test.

R04.07.01.04-T19 Attach a linked Word file and an embedded PDF icon in a workbook

原始指令

In input/project_tracker.xlsx sheet 'Docs', insert input/scope.docx as a linked object displayed as an icon in cell C4, and embed input/contract.pdf (not linked) as an icon in C6 with caption 'Contract'. Saving the workbook must keep the PDF inside it.

平台: win · Windows
应用: Excel · Word
交互表面: desk · 桌面 GUI
GUI 需求 · 任务设定: G2 · GUI 必要
GUI 需求 · 普通权限: CL · CLI 足够
交互原语: click · 指向与点击 geom · 精确几何
工作产物: WP02 · 记录 / 表格
条件: multiapp · 多应用
提案难度: 3 / 5

建议验证方式

Workbook has 2 oleObjects: one linked (oleLink to scope.docx, DVASPECT_ICON) anchored at C4, one embedded package whose bytes hash-equal contract.pdf anchored at C6 with icon label 'Contract'. VBA is disabled and the agent VM has no COM host or Python, so link and object edits must happen in the apps.

建议部分得分

45% linked Word icon; 45% embedded PDF; 10% anchors.

R04.07.01.04-T20 Update nine embedded (unlinked) charts from a new data workbook

原始指令

The 9 charts in input/investor_deck.pptx are embedded, not linked. Using each chart's Edit Data, replace their data with Q3 values from input/q3_data.xlsx (sheet per chart), extend ranges where a new category was added, and keep chart formatting. Do not convert them to linked charts.

平台: win · Windows mac · macOS
应用: PowerPoint · Excel
交互表面: desk · 桌面 GUI
GUI 需求 · 任务设定: G2 · GUI 必要
GUI 需求 · 普通权限: CL · CLI 足够
交互原语: multi · 跨应用 click · 指向与点击 type · 文字与表单
工作产物: WP03 · 视觉排版
条件: multiapp · 多应用 long · 长流程
提案难度: 4 / 5

建议验证方式

Each chart's embedded workbook and cache equal q3_data values; category count updated where needed; no external links; chart formatting XML (spPr, colors) unchanged. VBA, COM and AppleScript automation are disabled and the VM has no Python, so link and object edits must happen in the apps.

建议部分得分

60% charts updated (pro-rata over 9); 20% ranges extended; 10% formatting kept; 10% still embedded.

已有研究映射

以下沿用研究目录中的基准与小类映射，不是逐题标注、执行记录或产品背书。

OSUniverse

跨办公应用的链接与嵌入对象

任务提案 · 20

原始指令

建议验证方式

建议部分得分

原始指令

建议验证方式

建议部分得分

原始指令

建议验证方式

建议部分得分

原始指令

建议验证方式

建议部分得分

原始指令

建议验证方式

建议部分得分

原始指令

建议验证方式

建议部分得分

原始指令

建议验证方式

建议部分得分

原始指令

建议验证方式

建议部分得分

原始指令

建议验证方式

建议部分得分

原始指令

建议验证方式

建议部分得分

原始指令

建议验证方式

建议部分得分

原始指令

建议验证方式

建议部分得分

原始指令

建议验证方式

建议部分得分

原始指令

建议验证方式

建议部分得分

原始指令

建议验证方式

建议部分得分

原始指令

建议验证方式

建议部分得分

原始指令

建议验证方式

建议部分得分

原始指令

建议验证方式

建议部分得分

原始指令

建议验证方式

建议部分得分

原始指令

建议验证方式

建议部分得分

已有研究映射

同工作流族的小类