syidaxgrid
홈 가격 내 정보
SYIDAX / DATA GRID

수식 계산 PRO

셀 수식과 워크북 연결로 계산을 자동화합니다.

시작하기
수식 계산샘플 주문 데이터
120 rows
Grid를 불러오는 중입니다…
최근 결과

개발자가 정한 수량 × 단가만 필요하면 위 표의 valueGetter로 충분합니다. 사용자가 셀 참조 수식을 입력해야 한다면 수식 기능을 사용합니다.

코드 보기
현재 미리보기

사용 가이드

#

사용자가 스프레드시트처럼 수식을 입력하고 다른 셀의 값으로 결과를 계산해야 할 때 사용합니다.

앱에서 연결하는 순서

  1. 계산 방식 선택

    개발자가 정한 수량 × 단가만 필요하면 위 표의 valueGetter로 충분합니다. 사용자가 셀 참조 수식을 입력해야 한다면 수식 기능을 사용합니다.

  2. 수식 입력 열 준비

    앱에서 formulas를 켜고 =로 시작하는 문자열을 받을 수 있는 셀을 준비하세요. 수식에서 참조할 열과 행의 배치도 정합니다.

  3. 참조 값 변경하기

    앱에서 수식을 입력하고 참조 대상 셀의 값을 바꾸세요. 계산 결과와 formulaEvaluated 또는 formulaError 이벤트를 확인합니다.

확인할 결과

앱에서 입력한 수식이 계산되고 참조한 데이터 변화에 맞춰 결과가 갱신됩니다.

현재 합계 열은 valueGetter로 계산합니다. 숫자 편집기인 수량 셀에 수식을 넣는 예제가 아니며, 워크북 연동은 별도 구성이 필요합니다.

알아두면 쉬운 용어

A1 방식
열 문자와 행 번호로 셀을 가리키는 표현입니다.
formulas
=로 시작하는 셀 수식을 계산하도록 켜는 설정입니다.

제품에 이 기능을 적용하려면 Pro 런타임과 유효한 라이선스가 필요합니다.

API reference

#

나머지 속성5
Attribute / Property타입 / 기본값설명
PRO
boolean기본값 falseEnable in-cell spreadsheet formulas. When `true`, a cell whose value is a string starting with `=` (e.g. `=SUM(A1:A3)`) is evaluated by the formula engine and the computed result is displayed. References are A1-style over `columnDefs` order (A = first column) × `rowData` order (row 1 = first row). Defaults to `false` — no behaviour change for grids that don't opt in.
PRO
showFormulas		boolean기본값 falseShow the formula text (`=…`) instead of the computed value in formula cells — the equivalent of Excel's "Show Formulas" (Ctrl+`). Useful for inspecting and verifying a sheet. Only meaningful when is `true`.
PRO
formulaBar		boolean기본값 falseshow an Excel-style formula bar above the grid. It displays the active cell's raw content (the formula text for a formula cell) and edits it: Enter commits (and recalculates dependents), Escape reverts. Only meaningful with in the columnDefs API.
PRO
workbookId		string기본값 undefinedworkbook identity used for cross-grid formula coordination. `workbook-id` and must be supplied together while is enabled. Workbook ids are case-sensitive.
PRO
sheetName		string기본값 undefinedcase-insensitive sheet identity inside . Changing only this property renames the live registration without changing its numeric identity.
이벤트5
이벤트detail 타입설명
PRO
GridFormulaEvaluatedDetailFires when a formula cell is committed (only when `formulas` is enabled).
PRO
GridFormulaErrorDetailFires alongside `formulaEvaluated` when the committed result is an error token.
PRO
GridWorkbookBindingChangedDetaila workbook sheet registration connected, renamed, or disconnected.
PRO
GridWorkbookBindingErrorDetaila rejected workbook/sheet input; the last valid binding is retained.
PRO
SyGridWorkbookPropagationDetailone event per affected SHEET per transaction: the generation/hash stamp riding the repaint. Fires from method, commit and enrollment contexts (never from render), so no parked-event flush is needed — the Phase F `componentDidRender` idiom applies to render-path emissions only.
메서드11
메서드 / 인수반환 타입설명
PRO
Promise<GridWorkbookBinding | null>Current validated workbook/sheet registration, or null when opted out.
PRO
Promise<GridWorkbookBinding | null>Dispose and recreate the current registration using the public properties.
PRO
Promise<boolean>Explicitly leave the current workbook without changing public properties.
PRO
Promise<SyGridWorkbookPropagationState>the enrollment report: identity, the generation clock, this sheet's hub-registered cross-sheet formula cells, every registration REFUSAL (a refused cell keeps painting its engine-local value and will NOT propagate — this report is the truth surface for that divergence), and the last publication stamp.
PRO
Promise<SyGridWorkbookFlushReport>drain every scheduled workbook edit NOW . Commits auto-flush, so this usually answers `empty`; it exists for deterministic driving (tests, batch hosts). One generation per transaction .
PRO
Promise<SyGridWorkbookSnapshotReport>the sheet's last-published universe: generation, snapshot hash and every published cell (display-projected, with the canonical hash-alphabet text beside it so a consumer can re-derive the hash independently). `unpublished` before the first transaction — the published universe is the cells the hub has routed, NOT every grid cell.
PRO
Promise<SyGridWorkbookIntegrityReport>the cycle verdict over the live hub: whole-hub verdict counts, THIS sheet's non-acyclic cells, and the count of cells currently publishing `#CYCLE!` under the policy. Note the honest paint divergence: a cycle-member cell's own PAINT is the engine-local value while its PUBLICATION is `#CYCLE!` (PH-CYCLE-PAINT-01) — importing grids paint the published `#CYCLE!`.
PRO
input: SyGridSpillApplyInput		Promise<SyGridSpillApplyResult>land a dynamic-array formula under the collision policy: a spill lands WHOLE or not at all. The anchor text is written through `applyTransaction` (the grid's single write authority, so undo/audit/cellValueChanged all ride it) with a facade-minted grid-wide mutation id (PH-UNDO-01); the engine half lands through the model. Coordinates are SHEET coordinates (definition/data order — formulas are display-independent). `landed-blocked` = occupied-only collisions: the anchor paints `#SPILL!` through the existing formula error path until the occupant leaves. Covered cells beyond the data rectangle compute but do not paint (PH-SPILL-COVER-01, reported in `unpaintedCells`). Refused on the dual (WASM-serving) engine lane — PH-SPILL-01, `engine-lane-unsupported`.
PRO
target: SyGridSpillTarget		Promise<SyGridSpillClearResult>retire a landed spill anchor: the anchor data cell clears through the single write authority (minting its own mutation id) and the whole coverage heals through the model.
PRO
mutationId: GridMutationId		Promise<SyGridSpillUndoResult>undo one spill transaction by its mutation id: the anchor's previous data content restores through the single write authority and the engine half retires/re-lands deterministically. An entry is consumed by its undo; grid-level `undo` reaches the same data half through the transaction it recorded.
PRO
Promise<SyGridSpillReport>the spill-state report over the live engine: every anchor's range (dims, status, per-range hash, engine-truth covered values), the loud overlap report, and the whole-model state hash. The refresh that answers it also HEALS coverage deltas . Refused on the dual lane (PH-SPILL-01).
ColumnDef1
ColumnDef타입 / 필수 여부설명
PRO
string선택calculated column: a row-template formula (`'=B*C'`) evaluated by the formula engine for EVERY row. Bare column letters anchor to the row (`B` → `B3` on row 3); whole-column ranges (`SUM(D:D)`) and function names pass through. Requires the grid's `formulas` prop; the column is read-only (like a `valueGetter` column) and sorts/filters by its computed values.
GridTab 이동 Enter 열기