2022-01-25 Performance plan

Plus de détails

María Concepción Pomar Rosselló: Semantic Field of Fairy Tales

par María Concepción Pomar Rosselló

Error Analysis

par ADA LUCIA ASENCIO RIVERA

Calculus - Taylor and Maclaurin Series

par Michael Collins

Human Standstill

par Alexander Refsum Jensenius

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