GridSpace

using GridSpace.Core;
using GridSpace.Formulas;

var book = new Workbook();
var sheet = book.ActiveSheet;
sheet.Set("A1", "21");
sheet.Set("A2", "=A1*2");
sheet.Set("B1", "=SEQUENCE(3)");                 // spills into B1:B3

var calc = new CalculationEngine(book);
calc.Register("DOUBLE", args => args[0].TryNumber(out var n) ? CalcValue.Num(n * 2) : CalcValue.Error("#VALUE!"));

Console.WriteLine(NumberFormatter.Format(calc.Evaluate(sheet, "A2"), "0.00"));   // 42.00
Console.WriteLine(calc.EvaluateFormula(sheet, "=DOUBLE(A1)+SUM(B1#)"));          // 48
Console.WriteLine(calc.GetSpill(sheet, CellAddress.Parse("B1"))?.Range);          // B1:B3
Console.WriteLine(FormulaReferences.Translate("=A1*$B$2", rows: 1, columns: 0)); // =A2*$B$2

using GridSpace.Core;
using GridSpace.Editing;
using GridSpace.Formulas;

var session = new SpreadsheetSession(new Workbook { Title = "Example" });
session.SetInput("21", new CellAddress(0, 0));
session.SetInput("=A1*2", new CellAddress(0, 1));
Console.WriteLine(session.Calculation.Evaluate(session.Sheet, "B1")); // 42

session.SetConditionalFormat(new ConditionalFormatRule
{
    Range = "A1:B1",
    Kind = ConditionalFormatKind.CellValue,
    Comparison = CellComparison.GreaterThan,
    Operand = "30",
    Style = new DifferentialStyle { Background = "#C6EFCE", Bold = true }
});
var rules = new ConditionalFormattingEngine(session.Calculation);
var address = new CellAddress(0, 1);
var displayed = rules.Evaluate(session.Sheet, address,
    session.Calculation.Evaluate(session.Sheet, address));
Console.WriteLine(displayed.Style.Background); // #C6EFCE

session.InsertRows(0, 2); // References and modeled metadata follow the insertion.
session.Undo();

using GridSpace.Core;
using GridSpace.Editing;
using GridSpace.IO;

ImportResult imported = WorkbookFiles.Import("sales.xlsx", File.ReadAllBytes("sales.xlsx"));
foreach (var warning in imported.Warnings) Console.WriteLine(warning);

var session = new SpreadsheetSession(imported.Workbook);
session.SetInput("=SUM(B2:B13)", CellAddress.Parse("B14"));

File.WriteAllBytes("sales-out.xlsx", XlsxWorkbook.Write(session.Book));
File.WriteAllBytes("sales.csv", WorkbookFiles.Csv(session.Book));        // active sheet, calculated values
File.WriteAllBytes("sales.gridspace", WorkbookFiles.Native(session.Book));

using GridSpace.Core;
using GridSpace.Layout;

var sheet = new Worksheet { FrozenRows = 1, FrozenColumns = 1 };
sheet.ColumnWidths[0] = 160;
sheet.HiddenRows.Add(4);

var viewport = new GridViewport { Width = 1280, Height = 720, Zoom = 1.25 };
viewport.Refresh(sheet);                       // rebuild axis indexes from sizes/hidden/frozen state
viewport.ScrollTo(0, 2_000);
foreach (GridPane pane in viewport.Panes())
    Console.WriteLine($"rows {pane.FirstRow}-{pane.LastRow}, columns {pane.FirstColumn}-{pane.LastColumn}");

GridHit hit = viewport.HitTest(300, 200);      // Cell, ColumnHeader, RowHeader or Corner
GridRect bounds = viewport.CellBounds(new CellAddress(hit.Row, hit.Column));

using GridSpace.Editing;
using GridSpace.Layout;
using GridSpace.Skia;
using SkiaSharp;

var session = new SpreadsheetSession(SampleWorkbook.Create());
using var renderer = new SpreadsheetRenderer();
renderer.Fonts.Register("Carlito", regular, bold, italic, boldItalic, "Arial", "Calibri"); // font file bytes

var viewport = new GridViewport { Width = 1200, Height = 800 };
viewport.Refresh(session.Sheet);

using var surface = SKSurface.Create(new SKImageInfo(1200, 800));
renderer.Render(surface.Canvas, session, viewport);
using var png = surface.Snapshot().Encode(SKEncodedImageFormat.Png, 100);
File.WriteAllBytes("sheet.png", png.ToArray());

using GridSpace.Controls;
using GridSpace.Editing;
using Microsoft.UI.Xaml;
using Microsoft.UI.Xaml.Controls;

var session = new SpreadsheetSession(SampleWorkbook.Create());
var sheetView = new SpreadsheetGrid { Session = session };

var ribbon = new RibbonControl();
ribbon.SetTabs([new RibbonTab("Home", [new RibbonGroup("Font", [new RibbonCommand("bold", "Bold", OfficeIconKind.Bold)])])]);
ribbon.CommandRequested += id =>
{
    if (id != "bold") return;
    var bold = !session.SelectedStyle.Bold;
    session.ApplyStyle(style => style with { Bold = bold });
};

var root = new Grid { RowDefinitions = { new RowDefinition { Height = GridLength.Auto }, new RowDefinition() } };
Grid.SetRow(sheetView, 1);
root.Children.Add(ribbon);
root.Children.Add(sheetView);
window.Content = root;
window.Closed += (_, _) => sheetView.Dispose();

using GridSpace.Core;
using GridSpace.Editing;
using GridSpace.IO;
using GridSpace.Workbench;

IWorkbookStorage storage = new MyWorkbookStorage(); // OpenAsync, SaveAsync, Read/WriteRecoveryAsync
var recovery = await storage.ReadRecoveryAsync();
var book = string.IsNullOrWhiteSpace(recovery) ? SampleWorkbook.Create() : Workbook.FromJson(recovery);

var workbench = new SpreadsheetWorkbench(new SpreadsheetSession(book), storage);
workbench.Surface.Renderer.Fonts.Register("Carlito", regular, bold, italic, boldItalic, "Arial", "Calibri", "Aptos");
window.Content = workbench;
window.Closed += (_, _) => workbench.Dispose();