2022-01-25 Performance plan

Mer som dette

SPS 170

Ved mohd fadhil baharudin

Types of Business forms and businesses

Ved Habib Malik - Rick Hansen SS (2542)

Advanced Operations Management - S2

Ved T K

Political Influences on Tourism

Ved Kenneth Park

2022-01-25 Performance plan

Cool stuff

Culture

Cell buttons

Dyanimc array formulas and spilling

List operator

Let for global variables declaration

Components

Async custom formula

Batching and Queue

Analysis

Reducing

Execution

Services

Pre-fetch

SQLite

Using another layer on top

Indexing

Steps

Reprendre tests d'origine

load dictionary in-memory

Change blocks / experiments

Demonstrate SpreadJS needs to work on their side

Experiments

Spreadjs event ?

Use sync functions

Way to retrieve row and cell

How to deal with dependencies

Acceptable that the UI freeze

Bypass workflow

direct call to dictionary

Replace SQLite with flat file / dictionary

Keep workflow

Paths

see example of server call

getDirtyCells & Cells status

doNotRecalculateAfterLoad

useful functions

sheet.setArray & sheet.setFormulaArray

sheet.setValue

sheet.getCell

isBranch

findTestArgument

findBranchArgument

Can we get a reference to dependent and precedents formulas (other cells or inline)

getPrecedents and getDependents

Is there a way to find the address of a cell / parent caller

isContextSensitive property in sync functions

POC in react

Sample in javascript

check isContextSensitive here

events when formula is refreshing ?

UserFormulaEntered

not when moved

not when refreshed

When a new formula is inserted

Edit

EditStarting

EditEnding

EditEnded

EditChange

Subtopic

Not triggered by formula reference

When we edit the cell content manually

OnKeyPress

Drag-copy / move event

DragMerging

DragMerged

DragFillBlockCompleted

DragFillBlock

Copy or increment

DragDropBlockCompleted

DragDropBlock

Move cells

Range changes

Cell Data Changes

When the data in a cell changes

Check context and events usage here

Other system than SQLite

Multi-threading

Caching

Smart & statistics

SpreadJS engine

Async formula perf