botui/ui/suite/sheet/sheet.html

<link rel="stylesheet" href="sheet/sheet.css" />

<div class="sheet-app" id="sheet-app">
    <div class="sheet-toolbar">
        <div class="toolbar-left">
            <input type="text" class="sheet-name-input" id="sheetName" value="Untitled Spreadsheet"
                spellcheck="false" />
        </div>
        <div class="toolbar-center">
            <div class="toolbar-group">
                <button class="btn-icon" id="undoBtn" title="Undo (Ctrl+Z)">
                    <svg width="16" height="16" viewBox="0 0 24 24" fill="none" stroke="currentColor" stroke-width="2">
                        <path d="M3 7v6h6"></path>
                        <path d="M21 17a9 9 0 0 0-9-9 9 9 0 0 0-6 2.3L3 13"></path>
                    </svg>
                </button>
                <button class="btn-icon" id="redoBtn" title="Redo (Ctrl+Y)">
                    <svg width="16" height="16" viewBox="0 0 24 24" fill="none" stroke="currentColor" stroke-width="2">
                        <path d="M21 7v6h-6"></path>
                        <path d="M3 17a9 9 0 0 1 9-9 9 9 0 0 1 6 2.3L21 13"></path>
                    </svg>
                </button>
            </div>
            <span class="toolbar-divider"></span>
            <div class="toolbar-group">
                <button class="btn-icon" id="printPreviewBtn" title="Print Preview">
                    <svg width="16" height="16" viewBox="0 0 24 24" fill="none" stroke="currentColor" stroke-width="2">
                        <polyline points="6 9 6 2 18 2 18 9"></polyline>
                        <path d="M6 18H4a2 2 0 0 1-2-2v-5a2 2 0 0 1 2-2h16a2 2 0 0 1 2 2v5a2 2 0 0 1-2 2h-2"></path>
                        <rect x="6" y="14" width="12" height="8"></rect>
                    </svg>
                </button>
                <button class="btn-icon" id="findReplaceBtn" title="Find & Replace (Ctrl+H)">
                    <svg width="16" height="16" viewBox="0 0 24 24" fill="none" stroke="currentColor" stroke-width="2">
                        <circle cx="11" cy="11" r="8"></circle>
                        <line x1="21" y1="21" x2="16.65" y2="16.65"></line>
                    </svg>
                </button>
            </div>
            <span class="toolbar-divider"></span>
            <div class="toolbar-group">
                <select class="toolbar-select font-family" id="fontFamily" title="Font">
                    <option value="Arial">Arial</option>
                    <option value="Helvetica">Helvetica</option>
                    <option value="Times New Roman">Times</option>
                    <option value="Courier New">Courier</option>
                    <option value="Georgia">Georgia</option>
                    <option value="Verdana">Verdana</option>
                </select>
                <select class="toolbar-select font-size" id="fontSize" title="Size">
                    <option value="8">8</option>
                    <option value="9">9</option>
                    <option value="10">10</option>
                    <option value="11" selected>11</option>
                    <option value="12">12</option>
                    <option value="14">14</option>
                    <option value="16">16</option>
                    <option value="18">18</option>
                    <option value="24">24</option>
                    <option value="36">36</option>
                </select>
            </div>
            <span class="toolbar-divider"></span>
            <div class="toolbar-group format-group">
                <button class="btn-icon" id="boldBtn" title="Bold (Ctrl+B)">
                    <strong>B</strong>
                </button>
                <button class="btn-icon" id="italicBtn" title="Italic (Ctrl+I)">
                    <em>I</em>
                </button>
                <button class="btn-icon" id="underlineBtn" title="Underline (Ctrl+U)">
                    <u>U</u>
                </button>
                <button class="btn-icon" id="strikeBtn" title="Strikethrough">
                    <s>S</s>
                </button>
            </div>
            <span class="toolbar-divider"></span>
            <div class="toolbar-group">
                <button class="btn-icon color-btn" id="textColorBtn" title="Text Color">
                    <span class="color-letter">A</span>
                    <span class="color-indicator" id="textColorIndicator"></span>
                    <input type="color" class="color-input" id="textColorInput" value="#000000" />
                </button>
                <button class="btn-icon color-btn" id="bgColorBtn" title="Fill Color">
                    <svg width="16" height="16" viewBox="0 0 24 24" fill="currentColor">
                        <rect x="3" y="3" width="18" height="18" rx="2" fill="none" stroke="currentColor"
                            stroke-width="2" />
                    </svg>
                    <span class="color-indicator bg-indicator" id="bgColorIndicator"></span>
                    <input type="color" class="color-input" id="bgColorInput" value="#ffffff" />
                </button>
            </div>
            <span class="toolbar-divider"></span>
            <div class="toolbar-group">
                <button class="btn-icon" id="alignLeftBtn" title="Align Left">
                    <svg width="16" height="16" viewBox="0 0 24 24" fill="none" stroke="currentColor" stroke-width="2">
                        <line x1="3" y1="6" x2="21" y2="6"></line>
                        <line x1="3" y1="12" x2="15" y2="12"></line>
                        <line x1="3" y1="18" x2="18" y2="18"></line>
                    </svg>
                </button>
                <button class="btn-icon" id="alignCenterBtn" title="Align Center">
                    <svg width="16" height="16" viewBox="0 0 24 24" fill="none" stroke="currentColor" stroke-width="2">
                        <line x1="3" y1="6" x2="21" y2="6"></line>
                        <line x1="6" y1="12" x2="18" y2="12"></line>
                        <line x1="4" y1="18" x2="20" y2="18"></line>
                    </svg>
                </button>
                <button class="btn-icon" id="alignRightBtn" title="Align Right">
                    <svg width="16" height="16" viewBox="0 0 24 24" fill="none" stroke="currentColor" stroke-width="2">
                        <line x1="3" y1="6" x2="21" y2="6"></line>
                        <line x1="9" y1="12" x2="21" y2="12"></line>
                        <line x1="6" y1="18" x2="21" y2="18"></line>
                    </svg>
                </button>
            </div>
            <span class="toolbar-divider"></span>
            <div class="toolbar-group">
                <select class="toolbar-select number-format" id="numberFormat" title="Number Format">
                    <option value="general">General</option>
                    <option value="number">Number (1,234.56)</option>
                    <option value="currency">Currency ($1,234.56)</option>
                    <option value="accounting">Accounting</option>
                    <option value="percent">Percent (12.34%)</option>
                    <option value="scientific">Scientific (1.23E+03)</option>
                    <option value="date_short">Date (1/15/2024)</option>
                    <option value="date_long">Date (January 15, 2024)</option>
                    <option value="time">Time (3:45 PM)</option>
                    <option value="datetime">Date & Time</option>
                    <option value="fraction">Fraction (1/4)</option>
                    <option value="text">Text</option>
                    <option value="custom">Custom...</option>
                </select>
                <button class="btn-icon" id="decreaseDecimalBtn" title="Decrease Decimal">
                    <svg width="16" height="16" viewBox="0 0 24 24" fill="none" stroke="currentColor" stroke-width="2">
                        <text x="2" y="16" font-size="10" fill="currentColor">
                            .0
                        </text>
                        <path d="M18 8l-4 4 4 4"></path>
                    </svg>
                </button>
                <button class="btn-icon" id="increaseDecimalBtn" title="Increase Decimal">
                    <svg width="16" height="16" viewBox="0 0 24 24" fill="none" stroke="currentColor" stroke-width="2">
                        <text x="2" y="16" font-size="10" fill="currentColor">
                            .00
                        </text>
                        <path d="M14 8l4 4-4 4"></path>
                    </svg>
                </button>
            </div>
            <span class="toolbar-divider"></span>
            <div class="toolbar-group">
                <button class="btn-icon" id="mergeCellsBtn" title="Merge Cells">
                    <svg width="16" height="16" viewBox="0 0 24 24" fill="none" stroke="currentColor" stroke-width="2">
                        <rect x="3" y="3" width="18" height="18" rx="2"></rect>
                        <line x1="12" y1="3" x2="12" y2="21"></line>
                        <path d="M9 12h6M9 12l2-2M9 12l2 2M15 12l-2-2M15 12l-2 2"></path>
                    </svg>
                </button>
                <button class="btn-icon" id="conditionalFormatBtn" title="Conditional Formatting">
                    <svg width="16" height="16" viewBox="0 0 24 24" fill="none" stroke="currentColor" stroke-width="2">
                        <rect x="3" y="3" width="7" height="7" fill="#4CAF50"></rect>
                        <rect x="14" y="3" width="7" height="7" fill="#FFC107"></rect>
                        <rect x="3" y="14" width="7" height="7" fill="#F44336"></rect>
                        <rect x="14" y="14" width="7" height="7" fill="#2196F3"></rect>
                    </svg>
                </button>
                <button class="btn-icon" id="dataValidationBtn" title="Data Validation">
                    <svg width="16" height="16" viewBox="0 0 24 24" fill="none" stroke="currentColor" stroke-width="2">
                        <path d="M9 11l3 3L22 4"></path>
                        <path d="M21 12v7a2 2 0 0 1-2 2H5a2 2 0 0 1-2-2V5a2 2 0 0 1 2-2h11"></path>
                    </svg>
                </button>
            </div>
            <span class="toolbar-divider"></span>
            <div class="toolbar-group">
                <button class="btn-icon" id="insertChartBtn" title="Insert Chart">
                    <svg width="16" height="16" viewBox="0 0 24 24" fill="none" stroke="currentColor" stroke-width="2">
                        <rect x="3" y="12" width="4" height="9"></rect>
                        <rect x="10" y="6" width="4" height="15"></rect>
                        <rect x="17" y="3" width="4" height="18"></rect>
                    </svg>
                </button>
                <button class="btn-icon" id="insertImageBtn" title="Insert Image">
                    <svg width="16" height="16" viewBox="0 0 24 24" fill="none" stroke="currentColor" stroke-width="2">
                        <rect x="3" y="3" width="18" height="18" rx="2" ry="2"></rect>
                        <circle cx="8.5" cy="8.5" r="1.5"></circle>
                        <polyline points="21 15 16 10 5 21"></polyline>
                    </svg>
                </button>
                <button class="btn-icon" id="filterBtn" title="Filter">
                    <svg width="16" height="16" viewBox="0 0 24 24" fill="none" stroke="currentColor" stroke-width="2">
                        <polygon points="22 3 2 3 10 12.46 10 19 14 21 14 12.46 22 3"></polygon>
                    </svg>
                </button>
                <button class="btn-icon" id="sortAscBtn" title="Sort A→Z">
                    <svg width="16" height="16" viewBox="0 0 24 24" fill="none" stroke="currentColor" stroke-width="2">
                        <path d="M11 5h10M11 9h7M11 13h4"></path>
                        <path d="M3 17l3 3 3-3M6 18V4"></path>
                    </svg>
                </button>
                <button class="btn-icon" id="sortDescBtn" title="Sort Z→A">
                    <svg width="16" height="16" viewBox="0 0 24 24" fill="none" stroke="currentColor" stroke-width="2">
                        <path d="M11 5h4M11 9h7M11 13h10"></path>
                        <path d="M3 7l3-3 3 3M6 6v12"></path>
                    </svg>
                </button>
            </div>
        </div>
        <div class="toolbar-right">
            <div class="collaborators" id="collaborators"></div>
            <button class="btn-primary" id="shareBtn">
                <svg width="16" height="16" viewBox="0 0 24 24" fill="none" stroke="currentColor" stroke-width="2">
                    <circle cx="18" cy="5" r="3"></circle>
                    <circle cx="6" cy="12" r="3"></circle>
                    <circle cx="18" cy="19" r="3"></circle>
                    <line x1="8.59" y1="13.51" x2="15.42" y2="17.49"></line>
                    <line x1="15.41" y1="6.51" x2="8.59" y2="10.49"></line>
                </svg>
                <span>Share</span>
            </button>

        </div>
    </div>

    <div class="sheet-main">
        <div class="sheet-content">
            <div class="formula-bar">
                <div class="cell-address" id="cellAddress">A1</div>
                <span class="formula-icon">fx</span>
                <input type="text" class="formula-input" id="formulaInput" placeholder="Enter value or formula..." />
            </div>

            <div class="sheet-grid-container" id="gridContainer">
                <div class="sheet-grid" id="sheetGrid">
                    <div class="grid-corner"></div>
                    <div class="column-headers" id="columnHeaders"></div>
                    <div class="row-headers" id="rowHeaders"></div>
                    <div class="cells-container" id="cellsContainer">
                        <div class="cells" id="cells"></div>
                        <div class="selection-box" id="selectionBox"></div>
                        <div class="copy-box hidden" id="copyBox"></div>
                        <div class="autofill-handle" id="autofillHandle"></div>
                        <div class="cursor-indicators" id="cursorIndicators"></div>
                        <div class="charts-container" id="chartsContainer"></div>
                        <div class="images-container" id="imagesContainer"></div>
                    </div>
                </div>
            </div>

            <div class="sheet-tabs-container">
                <div class="sheet-tabs" id="worksheetTabs">
                    <div class="sheet-tab active" data-index="0">
                        <span>Sheet1</span>
                        <button class="tab-menu-btn">▼</button>
                    </div>
                </div>
                <button class="btn-add-sheet" id="addSheetBtn" title="Add Sheet">
                    <svg width="14" height="14" viewBox="0 0 24 24" fill="none" stroke="currentColor" stroke-width="2">
                        <line x1="12" y1="5" x2="12" y2="19"></line>
                        <line x1="5" y1="12" x2="19" y2="12"></line>
                    </svg>
                </button>
            </div>

            <div class="sheet-status-bar">
                <div class="status-left">
                    <span id="selectionInfo">Ready</span>
                </div>
                <div class="status-center">
                    <span id="calculationResult"></span>
                </div>
                <div class="status-right">
                    <span id="saveStatus">Saved</span>
                    <div class="zoom-control">
                        <button class="btn-zoom" id="zoomOutBtn">−</button>
                        <span id="zoomLevel">100%</span>
                        <button class="btn-zoom" id="zoomInBtn">+</button>
                    </div>
                </div>
            </div>
        </div>


    </div>
</div>

<div class="context-menu hidden" id="contextMenu">
    <div class="context-item" data-action="cut">
        Cut <span class="shortcut">Ctrl+X</span>
    </div>
    <div class="context-item" data-action="copy">
        Copy <span class="shortcut">Ctrl+C</span>
    </div>
    <div class="context-item" data-action="paste">
        Paste <span class="shortcut">Ctrl+V</span>
    </div>
    <div class="context-divider"></div>
    <div class="context-item" data-action="insertRowAbove">
        Insert row above
    </div>
    <div class="context-item" data-action="insertRowBelow">
        Insert row below
    </div>
    <div class="context-item" data-action="insertColLeft">
        Insert column left
    </div>
    <div class="context-item" data-action="insertColRight">
        Insert column right
    </div>
    <div class="context-divider"></div>
    <div class="context-item" data-action="deleteRow">Delete row</div>
    <div class="context-item" data-action="deleteCol">Delete column</div>
    <div class="context-divider"></div>
    <div class="context-item" data-action="clearContents">Clear contents</div>
    <div class="context-item" data-action="clearFormatting">
        Clear formatting
    </div>
</div>

<div class="modal hidden" id="shareModal">
    <div class="modal-content">
        <div class="modal-header">
            <h3>Share Spreadsheet</h3>
            <button class="btn-close" id="closeShareModal">×</button>
        </div>
        <div class="modal-body">
            <div class="share-input-group">
                <input type="email" placeholder="Enter email address" id="shareEmail" />
                <select id="sharePermission">
                    <option value="view">Can view</option>
                    <option value="edit">Can edit</option>
                </select>
                <button class="btn-primary" id="sendShareBtn">Share</button>
            </div>
            <div class="share-link-section">
                <h4>Or share with link</h4>
                <div class="share-link-group">
                    <input type="text" readonly id="shareLink" />
                    <button class="btn-icon" id="copyLinkBtn" title="Copy link">
                        <svg width="16" height="16" viewBox="0 0 24 24" fill="none" stroke="currentColor"
                            stroke-width="2">
                            <rect x="9" y="9" width="13" height="13" rx="2" ry="2"></rect>
                            <path d="M5 15H4a2 2 0 0 1-2-2V4a2 2 0 0 1 2-2h9a2 2 0 0 1 2 2v1"></path>
                        </svg>
                    </button>
                </div>
            </div>
        </div>
    </div>
</div>

<div class="modal hidden" id="chartModal">
    <div class="modal-content modal-large">
        <div class="modal-header">
            <h3>Insert Chart</h3>
            <button class="btn-close" id="closeChartModal">×</button>
        </div>
        <div class="modal-body">
            <div class="chart-type-selector">
                <button class="chart-type-btn active" data-type="bar">
                    <svg width="24" height="24" viewBox="0 0 24 24" fill="currentColor">
                        <rect x="3" y="12" width="4" height="9"></rect>
                        <rect x="10" y="6" width="4" height="15"></rect>
                        <rect x="17" y="3" width="4" height="18"></rect>
                    </svg>
                    <span>Bar</span>
                </button>
                <button class="chart-type-btn" data-type="line">
                    <svg width="24" height="24" viewBox="0 0 24 24" fill="none" stroke="currentColor" stroke-width="2">
                        <polyline points="3 18 9 12 13 16 21 6"></polyline>
                    </svg>
                    <span>Line</span>
                </button>
                <button class="chart-type-btn" data-type="pie">
                    <svg width="24" height="24" viewBox="0 0 24 24" fill="none" stroke="currentColor" stroke-width="2">
                        <circle cx="12" cy="12" r="10"></circle>
                        <path d="M12 2v10l8.5 5"></path>
                    </svg>
                    <span>Pie</span>
                </button>
            </div>
            <div class="chart-options">
                <label>Data Range</label>
                <input type="text" id="chartDataRange" placeholder="e.g., A1:B10" />
                <label>Chart Title</label>
                <input type="text" id="chartTitle" placeholder="Enter chart title" />
            </div>
            <div class="modal-actions">
                <button class="btn-secondary" id="cancelChartBtn">
                    Cancel
                </button>
                <button class="btn-primary" id="insertChartBtnConfirm">
                    Insert Chart
                </button>
            </div>
        </div>
    </div>
</div>

<div class="modal hidden" id="findReplaceModal">
    <div class="modal-content">
        <div class="modal-header">
            <h3>Find & Replace</h3>
            <button class="btn-close" id="closeFindReplaceModal">×</button>
        </div>
        <div class="modal-body">
            <div class="find-replace-group">
                <label>Find:</label>
                <input type="text" id="findInput" placeholder="Search text..." autofocus />
            </div>
            <div class="find-replace-group">
                <label>Replace:</label>
                <input type="text" id="replaceInput" placeholder="Replace with..." />
            </div>
            <div class="find-replace-options">
                <label class="checkbox-label">
                    <input type="checkbox" id="findMatchCase" />
                    Match case
                </label>
                <label class="checkbox-label">
                    <input type="checkbox" id="findWholeCell" />
                    Match entire cell contents
                </label>
                <label class="checkbox-label">
                    <input type="checkbox" id="findRegex" />
                    Use regular expressions
                </label>
            </div>
            <div class="find-results" id="findResults">
                <span>0 matches found</span>
            </div>
            <div class="modal-actions">
                <button class="btn-secondary" id="findPrevBtn">Previous</button>
                <button class="btn-secondary" id="findNextBtn">Next</button>
                <button class="btn-primary" id="replaceBtn">Replace</button>
                <button class="btn-primary" id="replaceAllBtn">
                    Replace All
                </button>
            </div>
        </div>
    </div>
</div>

<div class="modal hidden" id="conditionalFormatModal">
    <div class="modal-content modal-large">
        <div class="modal-header">
            <h3>Conditional Formatting</h3>
            <button class="btn-close" id="closeConditionalFormatModal">
                ×
            </button>
        </div>
        <div class="modal-body">
            <div class="cf-section">
                <label>Apply to range:</label>
                <input type="text" id="cfRange" placeholder="e.g., A1:D10" />
            </div>
            <div class="cf-section">
                <label>Format cells if:</label>
                <select id="cfRuleType">
                    <option value="greater_than">Greater than</option>
                    <option value="less_than">Less than</option>
                    <option value="equal_to">Equal to</option>
                    <option value="between">Between</option>
                    <option value="text_contains">Text contains</option>
                    <option value="text_starts">Text starts with</option>
                    <option value="text_ends">Text ends with</option>
                    <option value="duplicate">Duplicate values</option>
                    <option value="unique">Unique values</option>
                    <option value="blank">Is blank</option>
                    <option value="not_blank">Is not blank</option>
                    <option value="top_n">Top N values</option>
                    <option value="bottom_n">Bottom N values</option>
                    <option value="above_average">Above average</option>
                    <option value="below_average">Below average</option>
                    <option value="color_scale">Color scale</option>
                    <option value="data_bar">Data bars</option>
                    <option value="icon_set">Icon set</option>
                </select>
            </div>
            <div class="cf-section cf-values" id="cfValuesSection">
                <input type="text" id="cfValue1" placeholder="Value" />
                <input type="text" id="cfValue2" placeholder="and" class="hidden" />
            </div>
            <div class="cf-section">
                <label>Formatting style:</label>
                <div class="cf-style-options">
                    <div class="cf-style-row">
                        <label>Background:</label>
                        <input type="color" id="cfBgColor" value="#ffeb3b" />
                    </div>
                    <div class="cf-style-row">
                        <label>Text color:</label>
                        <input type="color" id="cfTextColor" value="#000000" />
                    </div>
                    <div class="cf-style-row">
                        <label>Bold:</label>
                        <input type="checkbox" id="cfBold" />
                    </div>
                    <div class="cf-style-row">
                        <label>Italic:</label>
                        <input type="checkbox" id="cfItalic" />
                    </div>
                </div>
            </div>
            <div class="cf-preview">
                <label>Preview:</label>
                <div class="cf-preview-cell" id="cfPreviewCell">Sample</div>
            </div>
            <div class="modal-actions">
                <button class="btn-secondary" id="cancelCfBtn">Cancel</button>
                <button class="btn-primary" id="applyCfBtn">Apply</button>
            </div>
        </div>
    </div>
</div>

<div class="modal hidden" id="dataValidationModal">
    <div class="modal-content modal-large">
        <div class="modal-header">
            <h3>Data Validation</h3>
            <button class="btn-close" id="closeDataValidationModal">×</button>
        </div>
        <div class="modal-body">
            <div class="dv-tabs">
                <button class="dv-tab active" data-tab="settings">
                    Settings
                </button>
                <button class="dv-tab" data-tab="input">Input Message</button>
                <button class="dv-tab" data-tab="error">Error Alert</button>
            </div>
            <div class="dv-tab-content active" id="dvSettingsTab">
                <div class="dv-section">
                    <label>Apply to range:</label>
                    <input type="text" id="dvRange" placeholder="e.g., A1:A100" />
                </div>
                <div class="dv-section">
                    <label>Allow:</label>
                    <select id="dvType">
                        <option value="any">Any value</option>
                        <option value="whole_number">Whole number</option>
                        <option value="decimal">Decimal</option>
                        <option value="list">List</option>
                        <option value="date">Date</option>
                        <option value="time">Time</option>
                        <option value="text_length">Text length</option>
                        <option value="custom">Custom formula</option>
                    </select>
                </div>
                <div class="dv-section dv-criteria" id="dvCriteriaSection">
                    <label>Data:</label>
                    <select id="dvOperator">
                        <option value="between">between</option>
                        <option value="not_between">not between</option>
                        <option value="equal">equal to</option>
                        <option value="not_equal">not equal to</option>
                        <option value="greater">greater than</option>
                        <option value="less">less than</option>
                        <option value="greater_equal">
                            greater than or equal to
                        </option>
                        <option value="less_equal">
                            less than or equal to
                        </option>
                    </select>
                </div>
                <div class="dv-section dv-values" id="dvValuesSection">
                    <div class="dv-value-row">
                        <label id="dvValue1Label">Minimum:</label>
                        <input type="text" id="dvValue1" />
                    </div>
                    <div class="dv-value-row" id="dvValue2Row">
                        <label>Maximum:</label>
                        <input type="text" id="dvValue2" />
                    </div>
                </div>
                <div class="dv-section dv-list hidden" id="dvListSection">
                    <label>Source (comma-separated):</label>
                    <textarea id="dvListSource" placeholder="Option 1, Option 2, Option 3"></textarea>
                </div>
                <div class="dv-section">
                    <label class="checkbox-label">
                        <input type="checkbox" id="dvIgnoreBlank" checked />
                        Ignore blank
                    </label>
                    <label class="checkbox-label">
                        <input type="checkbox" id="dvShowDropdown" checked />
                        In-cell dropdown
                    </label>
                </div>
            </div>
            <div class="dv-tab-content" id="dvInputTab">
                <div class="dv-section">
                    <label class="checkbox-label">
                        <input type="checkbox" id="dvShowInput" checked />
                        Show input message when cell is selected
                    </label>
                </div>
                <div class="dv-section">
                    <label>Title:</label>
                    <input type="text" id="dvInputTitle" placeholder="Input title" />
                </div>
                <div class="dv-section">
                    <label>Input message:</label>
                    <textarea id="dvInputMessage" placeholder="Enter instructions for the user"></textarea>
                </div>
            </div>
            <div class="dv-tab-content" id="dvErrorTab">
                <div class="dv-section">
                    <label class="checkbox-label">
                        <input type="checkbox" id="dvShowError" checked />
                        Show error alert after invalid data is entered
                    </label>
                </div>
                <div class="dv-section">
                    <label>Style:</label>
                    <select id="dvErrorStyle">
                        <option value="stop">Stop</option>
                        <option value="warning">Warning</option>
                        <option value="information">Information</option>
                    </select>
                </div>
                <div class="dv-section">
                    <label>Title:</label>
                    <input type="text" id="dvErrorTitle" placeholder="Error title" />
                </div>
                <div class="dv-section">
                    <label>Error message:</label>
                    <textarea id="dvErrorMessage" placeholder="Enter error message"></textarea>
                </div>
            </div>
            <div class="modal-actions">
                <button class="btn-secondary" id="clearDvBtn">Clear All</button>
                <button class="btn-secondary" id="cancelDvBtn">Cancel</button>
                <button class="btn-primary" id="applyDvBtn">OK</button>
            </div>
        </div>
    </div>
</div>

<div class="modal hidden" id="printPreviewModal">
    <div class="modal-content modal-fullscreen">
        <div class="modal-header">
            <h3>Print Preview</h3>
            <div class="print-toolbar">
                <select id="printOrientation">
                    <option value="portrait">Portrait</option>
                    <option value="landscape">Landscape</option>
                </select>
                <select id="printPaperSize">
                    <option value="letter">Letter (8.5" x 11")</option>
                    <option value="a4">A4 (210mm x 297mm)</option>
                    <option value="legal">Legal (8.5" x 14")</option>
                    <option value="tabloid">Tabloid (11" x 17")</option>
                </select>
                <select id="printScale">
                    <option value="100">100%</option>
                    <option value="fit_width">Fit to width</option>
                    <option value="fit_page">Fit to page</option>
                    <option value="75">75%</option>
                    <option value="50">50%</option>
                </select>
                <label class="checkbox-label">
                    <input type="checkbox" id="printGridlines" />
                    Gridlines
                </label>
                <label class="checkbox-label">
                    <input type="checkbox" id="printHeaders" />
                    Row/Column headers
                </label>
            </div>
            <button class="btn-close" id="closePrintPreviewModal">×</button>
        </div>
        <div class="modal-body print-preview-body">
            <div class="print-preview-container" id="printPreviewContainer">
                <div class="print-page" id="printPage">
                    <div class="print-content" id="printContent"></div>
                </div>
            </div>
        </div>
        <div class="modal-actions">
            <button class="btn-secondary" id="cancelPrintBtn">Cancel</button>
            <button class="btn-primary" id="printBtn">
                <svg width="16" height="16" viewBox="0 0 24 24" fill="none" stroke="currentColor" stroke-width="2">
                    <polyline points="6 9 6 2 18 2 18 9"></polyline>
                    <path d="M6 18H4a2 2 0 0 1-2-2v-5a2 2 0 0 1 2-2h16a2 2 0 0 1 2 2v5a2 2 0 0 1-2 2h-2"></path>
                    <rect x="6" y="14" width="12" height="8"></rect>
                </svg>
                Print
            </button>
        </div>
    </div>
</div>

<div class="modal hidden" id="customNumberFormatModal">
    <div class="modal-content">
        <div class="modal-header">
            <h3>Custom Number Format</h3>
            <button class="btn-close" id="closeCustomFormatModal">×</button>
        </div>
        <div class="modal-body">
            <div class="cnf-section">
                <label>Category:</label>
                <select id="cnfCategory">
                    <option value="number">Number</option>
                    <option value="currency">Currency</option>
                    <option value="date">Date</option>
                    <option value="time">Time</option>
                    <option value="percentage">Percentage</option>
                    <option value="fraction">Fraction</option>
                    <option value="scientific">Scientific</option>
                    <option value="text">Text</option>
                    <option value="custom">Custom</option>
                </select>
            </div>
            <div class="cnf-section">
                <label>Format code:</label>
                <input type="text" id="cnfFormatCode" placeholder="#,##0.00" />
            </div>
            <div class="cnf-section">
                <label>Preview:</label>
                <div class="cnf-preview" id="cnfPreview">1,234.56</div>
            </div>
            <div class="cnf-section">
                <label>Common formats:</label>
                <div class="cnf-formats-list" id="cnfFormatsList">
                    <div class="cnf-format-item" data-format="#,##0">1,235</div>
                    <div class="cnf-format-item" data-format="#,##0.00">
                        1,234.56
                    </div>
                    <div class="cnf-format-item" data-format="$#,##0.00">
                        $1,234.56
                    </div>
                    <div class="cnf-format-item" data-format="0%">12%</div>
                    <div class="cnf-format-item" data-format="0.00%">
                        12.34%
                    </div>
                    <div class="cnf-format-item" data-format="0.00E+00">
                        1.23E+03
                    </div>
                    <div class="cnf-format-item" data-format="MM/DD/YYYY">
                        01/15/2024
                    </div>
                    <div class="cnf-format-item" data-format="MMMM D, YYYY">
                        January 15, 2024
                    </div>
                    <div class="cnf-format-item" data-format="HH:MM:SS">
                        14:30:00
                    </div>
                </div>
            </div>
            <div class="modal-actions">
                <button class="btn-secondary" id="cancelCnfBtn">Cancel</button>
                <button class="btn-primary" id="applyCnfBtn">Apply</button>
            </div>
        </div>
    </div>
</div>

<div class="modal hidden" id="insertImageModal">
    <div class="modal-content">
        <div class="modal-header">
            <h3>Insert Image</h3>
            <button class="btn-close" id="closeInsertImageModal">×</button>
        </div>
        <div class="modal-body">
            <div class="img-tabs">
                <button class="img-tab active" data-tab="url">From URL</button>
                <button class="img-tab" data-tab="upload">Upload</button>
            </div>
            <div class="img-tab-content active" id="imgUrlTab">
                <div class="img-section">
                    <label>Image URL:</label>
                    <input type="text" id="imgUrl" placeholder="https://..." />
                </div>
            </div>
            <div class="img-tab-content" id="imgUploadTab">
                <div class="img-section">
                    <label>Select file:</label>
                    <input type="file" id="imgFile" accept="image/*" />
                </div>
                <div class="img-drop-zone" id="imgDropZone">
                    <svg width="48" height="48" viewBox="0 0 24 24" fill="none" stroke="currentColor" stroke-width="1">
                        <rect x="3" y="3" width="18" height="18" rx="2" ry="2"></rect>
                        <circle cx="8.5" cy="8.5" r="1.5"></circle>
                        <polyline points="21 15 16 10 5 21"></polyline>
                    </svg>
                    <p>Drag and drop an image here</p>
                </div>
            </div>
            <div class="img-preview-container hidden" id="imgPreviewContainer">
                <label>Preview:</label>
                <img id="imgPreview" src="" alt="Preview" />
            </div>
            <div class="modal-actions">
                <button class="btn-secondary" id="cancelImgBtn">Cancel</button>
                <button class="btn-primary" id="insertImgBtn">Insert</button>
            </div>
        </div>
    </div>
</div>

<script src="sheet/sheet.js"></script>