15.0.0

[IMP] First release

14.0.2

[FIX] font_size_editor: add props definition

Before this revision, props were not defined on FontSizeEditor
component. This caused a warning in the console when using the
component.

Task-id 3196333

closes odoo/o-spreadsheet#2084

Signed-off-by: Rémi Rahir (rar) <[email protected]>

2.0.0

Breaking changes

• Plugins: remove workbook argument of the constructor.
• History:
  • updateState and updateLocalState have been both replaced by update.
  • updateCell and updateSheet have been both removed.
• Model: workbook no longer exist.
• Core:
  • activeSheet has been moved from workbook to core plugin.
  • sheets has been moved from workbook to core plugin.
  • visibleSheets has been moved from workbook to core plugin.
• Merge:
  • merges has been moved from workbook.sheets to merge plugin.
  • mergeCellMap has been moved from workbook.sheets to merge plugin.
• Getters:
  getActiveSheet now return the full activeSheet, not only the id (getActiveSheetId can now be used for that)
  getNumberCols and getNumberRows have been removed.
• Commands:
  • All sheet arguments have been renamed to sheetId
  • DUPLICATE_SHEET:
    • sheet has been renamed to sheetIdFrom
    • id has been renamed to sheetIdTo
  • ACTIVATE_SHEET:
    • from has been renamed to sheetIdFrom
    • to has been renamed to sheetIdTo
  • CREATE_SHEET:
    • id has been renamed to sheetId
  • SET_VALUE has been removed
  • parameter cols of RESIZE_COLUMNS is renamed to columns (6c4add1)
• BasePlugin is now split in CorePlugin and UIPlugin (d3a142c)
• Getters are now split in CoreGetters and Getters (beab412)

New features

• find and replace
• top-bar: allow to edit a cell from the top bar
• components: add formula assistant

New Commands

• ChangeComposerSelectionCommand
• ReplaceComposerSelectionCommand
• SetBorderCommand
• UpdateCellPositionCommand
• UpdateSearchCommand
• RefreshSearchCommand
• ClearSearchCommand
• SelectSearchPreviousCommand
• SelectSearchNextCommand
• ReplaceSearchCommand
• ReplaceAllSearchCommand

New Getters

• getActiveSheetId
• getCellByXc
• getCellPosition
• getCells
• getCellValue
• getChartDefinition
• getComposerSelection
• getCurrentSelectedMatchIndex
• getEvaluationSheets
• getFormulaCellContent
• getMerge
• getMerges
• getRangeFromSheetXC
• getRangeString
• getRulesByCell
• getSearchMatches
• getSheet
• getTokenAtCursor
• getVisibleSheets
• isInSameMerge
• isSelectingForComposer

Removed Getters

• getActiveCell
• getActiveCols
• getActiveRows
• getNumberCols
• getNumberRows
• getTextWidth

Improvements

• edition, composer: Move state to plugin
• composer: Make composer independent from the grid
• types: introduce UID type
• *: remove workbook state
• compiler: allow meta parameters
• new functions for formulas: ROW, ROWS, COLMUMN, COLUMNS, HLOOKUP, + some statistical functions
• grid: scroll horizontally with shift key
• *: save formula normalized
• history: Type check history updates
• core: Correctly type sheets
• core, autofill: small simplifications
• *: split core into core and remove position from cell
• commands: remove "SET_VALUE" command
• grid manipulation: use UPDATE_CELL_POSITION to move cells
• plugins: split BasePlugin into CorePLugin and UIPlugiun
• getters: split core and UI getters
• functions: Define multiple repeatable args
• functions: remove some optional flags
• fast loading of sheets
• Range: create a range plugins
• Range: implement transient ranges
• topbar: Add shortcut info in menus
• Grid: Add shortcut for bold/italic
• formatting: remove borders from cells
• formatting: move styles and format to cell
• cell: denormalize styles
• CF: Colorscale with midvalue and errors
• CF: Colorscale with Number and Percentage
• CF: Colorscale with Formulas
• CF: Colorscale with Percentile

Fixes

• components: Selection input style with multiple ranges
• when a menu has a scrollbar, scrolling in the menu with the mouse wheel does scroll the grid anymore
• allow empty autofill that is cancelled to disapear
• tests: Correctly mock clientWidth and clientHeight
• conditonnal_format: color scale with a value of 0
• composer: Autocomplete does not resize composer
• highlight: remove highlight with sheet reference
• conditional_format: display of conditional_format doesn't display bold or strike
• border: adapt borders when merging/unmerging
• style: keep style when unmerging
• composer: Fix lower composer border
• style: handle sheet argument
• import: correctly import styles on merges
• highlight: correctly render highlight
• formatting: handle sheetId in AUTORESIZE commands
• chart: Correctly import chart figures
• function: VLOOKUP in undefined cells
• composer: move cursor inside parentheses
• conditional_format: correctly handle undo/redo
• edition: correctly set the selecting mode
• history: create empty structure on redo
• CF: Apply style on non-existing cell
• CF: support merges
• CF: Unify translations
• Composer : Edit a cell with a style
• GridComposer: composer stays in sheet
• composer: moment when selection begins
• composer: add a selection indicator
• composer: UNKNOWN token & formula assistant

1.0.1

This release includes minor fixes. No breaking changes.

b327b5b [FIX] composer: move cursor inside parentheses
87d097c [FIX] chart: Correctly import chart figures
9d84062 [FIX] composer: assign width with pixels
48a3ae9 [FIX] function: VLOOKUP in undefined cells
b8229bb [FIX] Update owl to version 1.0.13
af557d2 [REF] *: run prettier
386c1be [FIX] highlight: correctly render highlight
fb195f3 [FIX] menus: add missing separator on latest 'insert' item
72132d9 [FIX] formulas, functions: correct typos
7a31642 [IMP] config: Compile Typescript to ES2019
c664497 [FIX] highlight: es compatibility
e15c2c7 [FIX] conditional_formatting_test: unskip working test
f0e23ef [FIX] style: keep style when unmerging
b282cd5 [FIX] border: adapt borders when merging/unmerging
721ed88 [FIX] conditional_format: display of conditional_format doesn't display bold or strike
1b9cdd9 [FIX] highlight: remove highlight with sheet reference
43aa132 [FIX] conditonal_format: color scale with a value of 0
26e3f02 [FIX] tests: Correctly mock clientWidth and clientHeight
43219aa [FIX] menu: stop wheel event propagation
e5e5246 [FIX] autofill: remove the tooltip when the autofill is cancelled
297f8fc [FIX] components: Selection input style with multiple ranges

v1.0.0

Improvements

• evaluation: Don't evaluate out of bounds ranges
• chart: some small options adjustments

Fixes

• grid: correctly update viewport after sheet switching
• grid: Set focus when sheet changed
• avoid memory leak
• merge: autofill a merge outside the grid
• autofill: autofill outside the grid
• menu: fix sub-menu position on small screen
• chart: async formula in label support

v0.8.0

Improvements

• expose:
  • isIdle as a getter
  • formatDecimal
  • sheet dimensions
• cell_menu_registry: reorganise items
• components: Set maximum ranges in selection input
• side_panel: Generalize control panel style
• figures: Type figure data
• Charts - rudimentary support to create charts (lines, bar and pie) by carefully selecting the data series, the labels and entering the title.

Fixes

• core: Trim sheet names and case insensitive check
• composer: support sheet with space
• sheets: use DELETE_SHEET_CONFIRMATION to delete a sheet
• clipboard: paste from os to outside of sheet

v0.7.0

Breaking changes

• autofill: allow to use a custom component to render the tooltip
  • getLastValue is now replaced by getAutofillTooltip
  • The function apply of a AutofillModifierImplementation should now return a Tooltip, an object with two attributes:
    • component (optional, a custom owl Component)
      • If empty, it use a default component with simply render the content as a string
    • props props that are given to the component

Improvements

• grid, menu: small design/color changes
• helpers: Support sheet reference in toZone
• core: we can now:
  • rename a sheet
  • delete a sheet
  • move a sheet
  • duplicate a sheet
• core: bottom_bar: add sheet context menu
  • A new event can now be triggered by Spreadsheet: edit-text. This event should ask an input to the user and call a given callback with the input
• history: do not historize standalone ACTIVATE_SHEET command
• autofill: allow to use a custom component to render the tooltip

Fixes

• composer: Don't process keyup events after edition is done

0.6.2

Fix

Fix evaluation loop when async formulas are in error
Fix range adaptation

0.6.1

Improvements

• Use other colors palette
• Number representation performance
• Tokenizer performance

Fixes

• Correctly update cross sheet range references

v0.6.0

v0.6.0

Improvements

• {col, row}_registry: reorder items
• compiler: cache compiled functions (according to structure)
• figures: add resizing feature to figures
• misc: Expose debug elements
• compiler: allow lazy parameters
• functions: add functions to evaluate errors

Fixes

• numbers: fix formatting in another language
• CF/Autofill: Make CF work when Autofilling
• merge: Use correct sheet to update merge style.
• figures/composer: display composer above figures
• core: Correctly update range when all rows are removed