Skip to content

armgit / macro

Public Imported from GitHub
0

Macro is a unified workspace for teams: email, chat, docs, tasks, agents, calls, and CRM — @-linked together with shared AI memory.

4.8 KB
Raw Blame
import { readFileSync } from 'node:fs';
import { LoroCounter, LoroDoc, LoroMap, LoroText } from 'loro-crdt';
import { afterEach, describe, expect, it } from 'vitest';
import { validateSpreadsheetDocument } from './document-validation';

const docs: LoroDoc[] = [];
function workbook() {
  const doc = new LoroDoc();
  docs.push(doc);
  doc.import(
    readFileSync(
      new URL(
        '../../../static_assets/spreadsheet-golden.1.bin',
        import.meta.url
      )
    )
  );
  return doc;
}
afterEach(() => {
  for (const doc of docs.splice(0)) doc.free();
});

describe('spreadsheet document validation outside sync', () => {
  it('accepts native snapshots and imported financial styles and metadata', () => {
    const doc = workbook();
    for (const [root, value] of [
      ['spreadsheetNumberFormats', '#,##0.00;[Red](#,##0.00);"—"'],
      ['spreadsheetFontNames', 'Calibri'],
      ['spreadsheetBorderBottomStyles', 'double'],
      ['spreadsheetBorderBottomColors', '#123456'],
      ['spreadsheetIndent', 250],
    ])
      doc.getMap(root).set('A1', value);
    doc
      .getMap('spreadsheetImages')
      .set('0123456789abcdef', 'data:image/png;base64,iVBORw0KGgo=');
    doc.getMap('spreadsheetSheetMetadata').set(
      'sheet1',
      JSON.stringify({
        drawings: [
          {
            id: 'logo',
            type: 'image',
            image: '0123456789abcdef',
            from: { row: 0, column: 0, x: 0, y: 0 },
            width: 120,
            height: 40,
          },
        ],
        merges: ['A1:C1'],
        rowHeights: { 0: 32 },
        hiddenRows: [5],
        hiddenColumns: [5],
        freeze: { rows: 3, columns: 1 },
        definedNames: [{ name: 'Rate', formula: '0.1', local: true }],
      })
    );
    expect(() => validateSpreadsheetDocument(doc)).not.toThrow();
  });

  it.each([
    ['root', 'content', 'bad'],
    ['spreadsheetUnknown', 'A1', 'bad'],
    ['spreadsheetValues', 'XFE1', 'bad'],
    ['spreadsheetValues', 'A100001', 'bad'],
    ['spreadsheetValues', 'A1', 'x'.repeat(10_001)],
    ['spreadsheetValues', 'bad!sheet!A1', 'bad'],
    ['spreadsheetFontSize', 'A1', 'large'],
    ['spreadsheetIndent', 'A1', 251],
    ['spreadsheetIndent', 'A1', 1.5],
    ['spreadsheetFormats', 'A1', 'unsupported'],
    ['spreadsheetSheetNames', 'sheet1', ' Untrimmed '],
    ['spreadsheetSheetOrder', 'bad!id', 1],
    [
      'spreadsheetSheetRetentions',
      'sheet1!peer',
      '{"name":"Sheet1","order":0,"revision":-1}',
    ],
    ['spreadsheetColumnWidths', '0', 641],
    ['spreadsheetRowAdditions', 'peer', 100_001],
    ['spreadsheetColumnAdditions', 'peer', 16_385],
    ['spreadsheetColumnWidths', '16384', 100],
    ['spreadsheetMeta', 'formatVersion', 2],
    // Only raster images are stored; SVG can carry scripts.
    [
      'spreadsheetImages',
      '0123456789abcdef',
      'data:image/svg+xml;base64,PHN2Zy8+',
    ],
    ['spreadsheetImages', 'logo', 'data:image/png;base64,iVBORw0KGgo='],
  ])('rejects invalid %s entries', (root, key, value) => {
    const doc = workbook();
    doc.getMap(root as string).set(key as string, value);
    expect(() => validateSpreadsheetDocument(doc)).toThrow(
      'native spreadsheet maps'
    );
  });

  it.each([
    '{"merges":["A1:XFE1"]}',
    '{"merges":["A1:A100001"]}',
    '{"rowHeights":{"100000":32}}',
    '{"hiddenColumns":[16384]}',
    '{"freeze":{"rows":100001,"columns":1}}',
    '{"arrayFormulas":{"A1":"B1:B3"}}',
    '{"definedNames":[{"name":"Rate","formula":false}]}',
    '{"unexpected":true}',
  ])('rejects invalid workbook metadata %s', (metadata) => {
    const doc = workbook();
    doc.getMap('spreadsheetSheetMetadata').set('sheet1', metadata);
    expect(() => validateSpreadsheetDocument(doc)).toThrow();
  });

  it('rejects nested containers even when their deep values look like valid scalars', () => {
    const text = workbook();
    text
      .getMap('spreadsheetValues')
      .setContainer('A1', new LoroText())
      .insert(0, 'looks valid');
    expect(text.toJSON().spreadsheetValues).toEqual({ A1: 'looks valid' });
    expect(() => validateSpreadsheetDocument(text)).toThrow();
    const counter = workbook();
    counter
      .getMap('spreadsheetFontSize')
      .setContainer('A1', new LoroCounter())
      .increment(10);
    expect(() => validateSpreadsheetDocument(counter)).toThrow();
    const map = workbook();
    map.getMap('spreadsheetValues').setContainer('A1', new LoroMap());
    expect(() => validateSpreadsheetDocument(map)).toThrow();
  });

  it('rejects other content types and wrong root container types', () => {
    const markdown = new LoroDoc();
    docs.push(markdown);
    markdown.getText('root').insert(0, 'markdown');
    expect(() => validateSpreadsheetDocument(markdown)).toThrow();
    const doc = workbook();
    doc.getText('spreadsheetValues').insert(0, 'not a map');
    expect(() => validateSpreadsheetDocument(doc)).toThrow();
  });
});