Conditions for Cells Subject to Processing
This manual is in pilot operation.
|
Not all cells within a linked region are subject to data fetching/reflection processes. Only cells meeting the following conditions are subject to data fetching/reflection processes.
Conditions for Cells Subject to Data Fetching Process
【Condition A-1】The cell is included within a linked region.
【Condition A-2】If the linked region is a "Data Region," it must be specified as either "Fetch" or "Fetch and Reflect."
【Condition A-3】All row keys and column keys must be specified for the cell.
【Condition A-4】The cell must not have an (Excel) formula set.
Condition A-3 allows for blank columns and rows within the linked region. Additionally, you can place rows or columns, such as comment rows, where you do not want the content to be altered by the data fetching process.
Condition A-4 allows for displaying data in the linked region based on calculations performed in Excel using fetched data.
Conditions for Cells Subject to Data Reflection Process
【Condition B-1】The cell is included within a linked region.
【Condition B-2】The linked region is a "Data Region" and is specified as either "Reflect" or "Fetch and Reflect."
【Condition B-3】All row keys and column keys must be specified for the cell.
Note that there is no corresponding condition to 【Condition A-4】above. That is, values calculated in Excel using formulas can be reflected back to the fusion_place ledger within the data region cells subject to reflection processes. This feature allows for complex calculations such as allocations to be performed in Excel while managing data centrally in fusion_place.
Additionally, both data fetching and data reflection are subject to Ledger Access Control. Please be aware.