Macro is a unified workspace for teams: email, chat, docs, tasks, agents, calls, and CRM — @-linked together with shared AI memory.
TypeScript agentaiai-agentsall-in-onecrmcrm-systememaillinearmcpmessagingnotesnotionofficerustslackslack-alternativestartupstartup-toolstypescriptworkspace
import {
cleanup,
fireEvent,
render,
screen,
waitFor,
} from '@solidjs/testing-library';
import { createSignal } from 'solid-js';
import { afterEach, beforeEach, describe, expect, it, vi } from 'vitest';
import {
SpreadsheetSheetTabs,
type SpreadsheetSheetTabsProps,
} from './SpreadsheetSheetTabs';
vi.mock('@core/mobile/mobileWidth', () => ({ isMobileWidth: () => true }));
let animationStyle: HTMLStyleElement;
beforeEach(() => {
vi.spyOn(window, 'scrollTo').mockImplementation(() => {});
Object.defineProperty(HTMLElement.prototype, 'scrollIntoView', {
configurable: true,
value: vi.fn(),
});
animationStyle = document.createElement('style');
animationStyle.textContent = '* { animation-name: none !important; }';
document.head.append(animationStyle);
});
afterEach(() => {
cleanup();
animationStyle.remove();
vi.restoreAllMocks();
});
function tabs(overrides: Partial<SpreadsheetSheetTabsProps> = {}) {
const [active, setActive] = createSignal('budget');
const onSelect = vi.fn((id: string) => setActive(id));
const onAdd = vi.fn();
const onRename = vi.fn();
const onDuplicate = vi.fn();
const onDelete = vi.fn();
const onMove = vi.fn();
const view = render(() => (
<SpreadsheetSheetTabs
sheets={[
{ id: 'budget', name: 'Budget' },
{ id: 'sales', name: 'Sales' },
{ id: 'forecast', name: 'Forecast' },
]}
activeSheetId={active()}
readonly={false}
canAdd={true}
onSelect={onSelect}
onAdd={onAdd}
onRename={onRename}
onDuplicate={onDuplicate}
onDelete={onDelete}
onMove={onMove}
{...overrides}
/>
));
return {
...view,
active,
onSelect,
onAdd,
onRename,
onDuplicate,
onDelete,
onMove,
};
}
/** Lay the tabs out 100px apart, as jsdom has no layout. */
function layOutTabs(view: ReturnType<typeof tabs>) {
for (const [index, tab] of view.getAllByRole('tab').entries())
tab.getBoundingClientRect = () =>
DOMRect.fromRect({ x: index * 100, y: 0, width: 100, height: 30 });
}
/** jsdom has no PointerEvent; a mouse event carries the pointer fields. */
function pointer(
target: Element | Window,
type: 'pointerdown' | 'pointermove' | 'pointerup',
clientX: number,
pointerType: 'mouse' | 'touch' = 'mouse'
) {
const event = new MouseEvent(type, {
bubbles: true,
cancelable: true,
button: 0,
clientX,
});
Object.defineProperties(event, {
pointerId: { value: 1 },
pointerType: { value: pointerType },
});
fireEvent(target, event);
}
function drag(
tab: HTMLElement,
toX: number,
pointerType: 'mouse' | 'touch' = 'mouse'
) {
pointer(tab, 'pointerdown', 150, pointerType);
pointer(window, 'pointermove', toX, pointerType);
pointer(window, 'pointerup', toX, pointerType);
}
describe('spreadsheet sheet tabs', () => {
it('selects sheets with click and roving arrow, Home, and End navigation', () => {
const view = tabs();
const budget = view.getByRole('tab', { name: 'Budget' });
const sales = view.getByRole('tab', { name: 'Sales' });
const forecast = view.getByRole('tab', { name: 'Forecast' });
expect(budget.getAttribute('aria-selected')).toBe('true');
expect(budget.tabIndex).toBe(0);
expect(sales.tabIndex).toBe(-1);
fireEvent.keyDown(budget, { key: 'ArrowRight' });
expect(view.active()).toBe('sales');
expect(document.activeElement).toBe(sales);
expect(sales.tabIndex).toBe(0);
fireEvent.keyDown(sales, { key: 'End' });
expect(document.activeElement).toBe(forecast);
fireEvent.keyDown(forecast, { key: 'ArrowRight' });
expect(document.activeElement).toBe(budget);
fireEvent.keyDown(budget, { key: 'ArrowLeft' });
expect(document.activeElement).toBe(forecast);
fireEvent.keyDown(forecast, { key: 'Home' });
expect(document.activeElement).toBe(budget);
fireEvent.click(sales);
expect(view.active()).toBe('sales');
});
it('drags a tab to the insertion point under the pointer and selects it', () => {
const view = tabs();
layOutTabs(view);
const sales = view.getByRole('tab', { name: 'Sales' });
pointer(sales, 'pointerdown', 150);
pointer(window, 'pointermove', 290);
expect(
document.querySelectorAll('[data-sheet-drop-indicator]')
).toHaveLength(1);
expect(sales.classList.contains('opacity-60')).toBe(true);
pointer(window, 'pointerup', 290);
expect(view.onMove).toHaveBeenCalledWith('sales', 2);
expect(view.active()).toBe('sales');
expect(document.querySelector('[data-sheet-drop-indicator]')).toBeNull();
drag(view.getByRole('tab', { name: 'Sales' }), 10);
expect(view.onMove).toHaveBeenLastCalledWith('sales', 0);
});
it('ignores drops in place, touch presses, and viewers', () => {
const [readonly, setReadonly] = createSignal(false);
const view = tabs({
get readonly() {
return readonly();
},
});
layOutTabs(view);
const sales = view.getByRole('tab', { name: 'Sales' });
drag(sales, 160);
drag(sales, 220);
drag(sales, 290, 'touch');
setReadonly(true);
drag(sales, 290);
expect(view.onMove).not.toHaveBeenCalled();
});
it.each(['readonly', 'preserveEditorFocus'] as const)(
'drops nothing when %s turns on during a drag',
(guard) => {
const [enabled, setEnabled] = createSignal(false);
const view = tabs({
get readonly() {
return guard === 'readonly' && enabled();
},
get preserveEditorFocus() {
return guard === 'preserveEditorFocus' && enabled();
},
});
layOutTabs(view);
pointer(view.getByRole('tab', { name: 'Sales' }), 'pointerdown', 150);
pointer(window, 'pointermove', 290);
setEnabled(true);
pointer(window, 'pointerup', 290);
expect(view.onMove).not.toHaveBeenCalled();
expect(view.onSelect).not.toHaveBeenCalled();
expect(document.querySelector('[data-sheet-drop-indicator]')).toBeNull();
}
);
it.each([
['Move left', 'budget'],
['Move right', 'forecast'],
] as const)(
'%s from the tab menu moves the right-clicked sheet',
async (label, edge) => {
const view = tabs();
fireEvent.contextMenu(view.getByRole('tab', { name: 'Sales' }));
fireEvent.keyDown(await screen.findByRole('menuitem', { name: label }), {
key: 'Enter',
});
await waitFor(() =>
expect(view.onMove).toHaveBeenCalledWith(
'sales',
label === 'Move left' ? 0 : 2
)
);
view.onMove.mockClear();
fireEvent.contextMenu(
view.getByRole('tab', {
name: edge === 'budget' ? 'Budget' : 'Forecast',
})
);
const item = await screen.findByRole('menuitem', { name: label });
await waitFor(() =>
expect(item.getAttribute('aria-disabled')).toBe('true')
);
}
);
it('moves the active sheet from the sheet actions menu', async () => {
const view = tabs();
fireEvent.keyDown(
view.getByRole('button', { name: 'Sheet actions for Budget' }),
{ key: 'ArrowDown' }
);
expect(
(await screen.findByRole('menuitem', { name: 'Move left' })).getAttribute(
'aria-disabled'
)
).toBe('true');
fireEvent.keyDown(screen.getByRole('menuitem', { name: 'Move right' }), {
key: 'Enter',
});
expect(view.onMove).toHaveBeenCalledWith('budget', 1);
});
it('opens rename for the double-clicked tab and prevents viewer renames', () => {
const [readonly, setReadonly] = createSignal(false);
const view = tabs({
get readonly() {
return readonly();
},
});
fireEvent.dblClick(view.getByRole('tab', { name: 'Sales' }));
expect(view.onRename).toHaveBeenCalledWith('sales');
setReadonly(true);
fireEvent.dblClick(view.getByRole('tab', { name: 'Budget' }));
expect(view.onRename).toHaveBeenCalledTimes(1);
});
it.each(['Rename', 'Duplicate', 'Delete'] as const)(
'targets the right-clicked inactive sheet for %s after closing its menu',
async (label) => {
const action = vi.fn();
const view = tabs({
onRename: action,
onDuplicate: action,
onDelete: action,
});
const target = view.getByRole('tab', { name: 'Sales' });
expect(
fireEvent.contextMenu(target, { clientX: 120, clientY: 200 })
).toBe(false);
const item = await screen.findByRole('menuitem', { name: label });
expect(view.active()).toBe('sales');
fireEvent.keyDown(item, { key: 'Enter' });
await waitFor(() => expect(action).toHaveBeenCalledWith('sales'));
}
);
it('keeps context actions disabled for viewers', async () => {
const view = tabs({ readonly: true });
fireEvent.contextMenu(view.getByRole('tab', { name: 'Sales' }));
for (const name of ['Rename', 'Duplicate', 'Delete']) {
const item = await screen.findByRole('menuitem', { name });
expect(item.getAttribute('aria-disabled')).toBe('true');
}
expect(view.onRename).not.toHaveBeenCalled();
expect(view.onDuplicate).not.toHaveBeenCalled();
expect(view.onDelete).not.toHaveBeenCalled();
});
it('adds sheets and leaves selection enabled for viewers', () => {
const view = tabs({ readonly: true });
expect(
view.getByRole('button', { name: 'Add sheet' }).hasAttribute('disabled')
).toBe(true);
expect(
view
.getByRole('button', { name: 'Sheet actions for Budget' })
.hasAttribute('disabled')
).toBe(true);
fireEvent.click(view.getByRole('tab', { name: 'Sales' }));
expect(view.onSelect).toHaveBeenCalledWith('sales');
expect(view.onAdd).not.toHaveBeenCalled();
});
it('invokes the add callback for an editable workbook', () => {
const view = tabs();
fireEvent.click(view.getByRole('button', { name: 'Add sheet' }));
expect(view.onAdd).toHaveBeenCalledOnce();
});
it('makes adding rows available through the sheet menu after it closes', async () => {
const onAddRows = vi.fn();
const view = tabs({ onAddRows, addRowsLabel: 'Add 100 rows' });
fireEvent.keyDown(
view.getByRole('button', { name: 'Sheet actions for Budget' }),
{ key: 'ArrowDown' }
);
const item = await screen.findByRole('menuitem', { name: 'Add 100 rows' });
fireEvent.keyDown(item, { key: 'Enter' });
expect(onAddRows).not.toHaveBeenCalled();
await waitFor(() => expect(onAddRows).toHaveBeenCalledOnce());
});
it('does not add rows if editing permission changes while the menu is open', async () => {
const [readonly, setReadonly] = createSignal(false);
const onAddRows = vi.fn();
const view = tabs({
onAddRows,
get readonly() {
return readonly();
},
});
fireEvent.keyDown(
view.getByRole('button', { name: 'Sheet actions for Budget' }),
{ key: 'ArrowDown' }
);
const item = await screen.findByRole('menuitem', { name: 'Add rows' });
setReadonly(true);
expect(item.getAttribute('aria-disabled')).toBe('true');
fireEvent.keyDown(item, { key: 'Enter' });
expect(onAddRows).not.toHaveBeenCalled();
});
it.each(['Rename', 'Duplicate', 'Delete'] as const)(
'defers %s until its menu closes so dialogs retain focus',
async (label) => {
const dialogInput = document.createElement('input');
document.body.append(dialogInput);
const action = vi.fn(() => dialogInput.focus());
try {
const view = tabs({
onRename: action,
onDuplicate: action,
onDelete: action,
});
fireEvent.keyDown(
view.getByRole('button', { name: 'Sheet actions for Budget' }),
{ key: 'ArrowDown' }
);
const item = await screen.findByRole('menuitem', { name: label });
item.focus();
fireEvent.keyDown(item, { key: 'Enter' });
expect(action).not.toHaveBeenCalled();
await waitFor(() => expect(action).toHaveBeenCalledWith('budget'));
expect(document.activeElement).toBe(dialogInput);
} finally {
dialogInput.remove();
}
}
);
it('prevents deleting the last sheet and duplicating beyond the sheet limit', async () => {
const view = tabs({
sheets: [{ id: 'budget', name: 'Budget' }],
canAdd: false,
});
expect(
view.getByRole('button', { name: 'Add sheet' }).hasAttribute('disabled')
).toBe(true);
fireEvent.keyDown(
view.getByRole('button', { name: 'Sheet actions for Budget' }),
{ key: 'ArrowDown' }
);
for (const name of ['Duplicate', 'Delete']) {
const item = await screen.findByRole('menuitem', { name });
expect(item.getAttribute('aria-disabled')).toBe('true');
fireEvent.keyDown(item, { key: 'Enter' });
}
expect(view.onDuplicate).not.toHaveBeenCalled();
expect(view.onDelete).not.toHaveBeenCalled();
});
});