Commits

Branch selector

develop

User selector

All users

Datepicker

All time

Commit history

Commits on Jan 5, 2023

• Remove last usage of translation code for evaluation of formula that returned object. The code for evaluation of criteria is slated for replacement and the original cose would throw InvalidCastExce…

  Show description for f32fc32
  jahav

  committed
  f32fc32View commit details

  Copy full SHA for f32fc32

  Browse repository at this point

• Convert XLWorkbook.EvaluateExpr method to XLCellValue. Unlike XLCellValue, it clearly demonstrates possible values of the evaluation.

  jahav

  committed
  3d58cccView commit details

  Copy full SHA for 3d58ccc

  Browse repository at this point

• Convert IXLWorksheet.Evaluate method to XLCellValue. Unlike XLCellValue, it clearly demonstrates possible values of the evaluation.

  jahav

  committed
  2f4245bView commit details

  Copy full SHA for 2f4245b

  Browse repository at this point

• Convert XLWorkbook.Evaluate method to XLCellValue. Unlike XLCellValue, it clearly demonstrates possible values of the evaluation.

  jahav

  committed
  29a33daView commit details

  Copy full SHA for 29a33da

  Browse repository at this point

• Add info about a change of IXLPivotValues manipulating methods to migration guide.

  jahav

  committed
  0df9f69View commit details

  Copy full SHA for 0df9f69

  Browse repository at this point

• Value fields in a pivot table can refer multiple times to a same filed (e.g. sum of a Filed or a average of a field) and therefore PivotValueFieldReference should use CustomName to find the correct…

  Show description for 388354c
  

  0MG-DEN

  authored and

  jahav

  committed
  388354cView commit details

  Copy full SHA for 388354c

  Browse repository at this point

• IXLPivotValues will use CustomName instead of SourceName for interacting with the pivot values, because there can be multiple value fields for the same source name (e.g. avg and sum of the same sou…

  Show description for 9e350eb
  

  0MG-DEN

  authored and

  jahav

  committed
  9e350ebView commit details

  Copy full SHA for 9e350eb

  Browse repository at this point

Commits on Jan 3, 2023

• Improve doctext for First|Last cells used functions

  

  igitur

  authored and

  jahav

  committed
  78391cdView commit details

  Copy full SHA for 78391cd

  Browse repository at this point

• Remove empty <returns></returns> in doctext

  

  igitur

  authored and

  jahav

  committed
  33408f7View commit details

  Copy full SHA for 33408f7

  Browse repository at this point

• Remove obsolete methods

  

  igitur

  authored and

  jahav

  committed
  a58c3e7View commit details

  Copy full SHA for a58c3e7

  Browse repository at this point

Commits on Jan 2, 2023

• Document possible solutions of a missing font.

  jahav

  committed
  5daaac8View commit details

  Copy full SHA for 5daaac8

  Browse repository at this point

• Fix text-to-number conversion test that relied on current time.

  jahav

  committed
  3e63f9bView commit details

  Copy full SHA for 3e63f9b

  Browse repository at this point

Commits on Dec 22, 2022

• Document built-in and custom number format usage.

  jahav

  committed
  a0b0bb2View commit details

  Copy full SHA for a0b0bb2

  Browse repository at this point

• Fix +1 bug, where first style number was 165 instead of 164, if there was a built-in style reference with a number from 0..163 (without format code, because it is built-in number format)

  jahav

  committed
  4563b2bView commit details

  Copy full SHA for 4563b2b

  Browse repository at this point

• Adding custom formats to a template that already contained the custom number formats could fail, if the number format ids in the template weren't sequential.

  jahav

  committed
  09a0917View commit details

  Copy full SHA for 09a0917

  Browse repository at this point

Commits on Dec 21, 2022

• Improve logical functions test names and test expressivness.

  jahav

  committed
  79f85eaView commit details

  Copy full SHA for 79f85ea

  Browse repository at this point

• Reimplement IFERROR to fit into the new CalcEngine.

  jahav

  committed
  a4019eaView commit details

  Copy full SHA for a4019ea

  Browse repository at this point

• Reimplement IF to be more compliant with Excel.

  jahav

  committed
  bafe60fView commit details

  Copy full SHA for bafe60f

  Browse repository at this point

• Sort logical functions in alphabetical order.

  jahav

  committed
  0d46e0cView commit details

  Copy full SHA for 0d46e0c

  Browse repository at this point

• Reimplement the OR and AND functions to be compliant with an Excel.

  jahav

  committed
  ca04245View commit details

  Copy full SHA for ca04245

  Browse repository at this point

• Update TRUE(),FALSE() and NOT() methods to use new signature. Fix a bug in coercion to boolean, it should also accept blank and return original error, if it was an error.

  jahav

  committed
  86e41ecView commit details

  Copy full SHA for 86e41ec

  Browse repository at this point

Commits on Dec 20, 2022

• Test that vlookup can also search in arrays, not only references.

  jahav

  committed
  3f11a8fView commit details

  Copy full SHA for 3f11a8f

  Browse repository at this point

• Add support for array literal in the formula parser. CalcEngine is only partially prepared to deal with the arrays, but it can at least pass array argument to functions.

  jahav

  committed
  b1ba8bcView commit details

  Copy full SHA for b1ba8bc

  Browse repository at this point

Commits on Dec 18, 2022

• 3/3 Saving SharedStringTable through streaming: Save memory during saving by streaming shared string table instead of saving DOM tree and save whole DOM.

  jahav

  committed
  377de7fView commit details

  Copy full SHA for 377de7f

  Browse repository at this point

• 2/3 Saving SharedStringTable through streaming: Write shared string table through OpenXmlWriter instead of auto-save by attached DOM to the part. The DOM is still fully created though, so no decrea…

  Show description for 8a4637e
  jahav

  committed
  8a4637eView commit details

  Copy full SHA for 8a4637e

  Browse repository at this point

• 1/3 Saving SharedStringTable through streaming: Move the code for writing shared string table to a separate writer. Part of a move to 2 phase saving and DOM-less saving though streaming of elements.

  jahav

  committed
  748ac84View commit details

  Copy full SHA for 748ac84

  Browse repository at this point

• 9/9 Saving SheeData through streaming: Remove orphan deletion that hydrates whole Worksheet after it has been saved through streaming by accessing the worksheetPart.Worksheet property (that propert…

  Show description for dc77aa7
  jahav

  committed
  dc77aa7View commit details

  Copy full SHA for dc77aa7

  Browse repository at this point

• 8/9 Saving SheeData through streaming: Decrease memory usage during SheetData saving. Save SheetData by saving each row instead of creating whole DOM for all rows and saving everything in the the e…

  Show description for ee5cdf7
  jahav

  committed
  ee5cdf7View commit details

  Copy full SHA for ee5cdf7

  Browse repository at this point

• 7/9 Saving SheeData through streaming: Moves SheetData writing from from DOM synchronization part to stream part. SheetData is still written through DOM, this only moves code to reasonable place.

  jahav

  committed
  a51cfd4View commit details

  Copy full SHA for a51cfd4

  Browse repository at this point

• 6/9 Saving SheeData through streaming: Change the saving of a worksheet from "read attached DOM, modify DOM, will be auto-saved to part" to "read detached DOM, stream DOM to part." SampleSparklines…

  Show description for b1b71ac
  jahav

  committed
  b1b71acView commit details

  Copy full SHA for b1b71ac

  Browse repository at this point

• 5/9 Saving SheeData through streaming: Move methods for saving the worksheet from XLWorkbook to WorksheetPartWriter. Methods are just copied, no change in code (except PopulatedRichTextElements and…

  Show description for 6ce830d
  jahav

  committed
  6ce830dView commit details

  Copy full SHA for 6ce830d

  Browse repository at this point

• 4/9 Saving SheeData through streaming: Start the move of saving logic to 2-phase save. Move generation of table definition parts from worksheet generation. It will allow us a better separation of w…

  Show description for 9c1afec
  jahav

  committed
  9c1afecView commit details

  Copy full SHA for 9c1afec

  Browse repository at this point

• 3/9 Saving SheeData through streaming: Remove XLWorksheet.LegacyDrawingIsNew property. It was a property that only transfered data during saving, but if you saved twice, it would be kept set from p…

  Show description for 8ee0fd1
  jahav

  committed
  8ee0fd1View commit details

  Copy full SHA for 8ee0fd1

  Browse repository at this point

• 2/9 Saving SheeData through streaming: The RelId generator should have all existing values before it starts assigning a new RelIds to new parts (old parts should have lower id than new ones).

  jahav

  committed
  e4b0b8fView commit details

  Copy full SHA for e4b0b8f

  Browse repository at this point

• 1/9 Saving SheeData through streaming: Don't access worksheet element through worksheet, a step toward completely DOM synchronization without a worksheetPart.

  jahav

  committed
  4b9234dView commit details

  Copy full SHA for 4b9234d

  Browse repository at this point