AutoSave
кабинка-376b94b508f581d3d1ae407d
Home

Clipboard

Paste
Font

Copy, cut, and paste visible cells from the current selection and active cell.

Clipboard
Главная

Шрифт

Абзац

Font, size, colour and borders apply to the current visible selection.

Шрифт
Главная

Выравнивание

Alignment applies to the current visible selection. Extended print layout and automatic row/column resizing remain separate tasks.

Выравнивание
Главная

Перенос и объединение

Wrap

Wrap, shrink to fit and merge apply to the current visible selection; extended print layout remains a separate task.

Перенос и объединение
Home

Number

Number

Basic number, percentage, currency, date, time, and text formats apply to the current visible selection.

Number
Главная

Стили

Conditional formatting applies visible styles to the selected numeric cells.

Стили
Главная

Ячейки

Ячейки

Insert, delete, hide, unhide and autofit work on the visible rows and columns of the current workbook.

Ячейки
Главная

Редактирование

Change Case: select a visible text cell.

Editing

Editing works on the visible cell, the formula bar, clear, cut, copy, paste and filling the selected range.

Редактирование
Paste
Clipboard
Font
Alignment
Paragraph
Cells
Number
Styles
Cells

Change Case: select a visible text cell.

Editing
A1

Choose data source

Choose a data source to connect through Power Query.

11 data sources

Рабочая область листа

Сетка, выделение и ввод работают в видимой области текущего листа.

kind=default-ltr-session-placeholder; workbook=ltr; active=ltr; writing=horizontal-tbНаправление листа применяется к текущему виду.

ABCDEFGHIJKLMNOPQRSTUVWXYZAAABACADAEAFAGAHAIAJAKALAMANAOAPAQARASATAUAVAWAXAYAZBABBBCBD
1SQLite for Excel — a workbook that is a program
2
3The three sheets of this workbook are empty on purpose. Everything it does lives in its VBA project:
4a library by Govert van Drimmelen that lets Excel talk to a SQLite database through the sqlite3 library.
5
6What is inside
7Module SQLite3 — 44 entry points: open and close a database, prepare a statement, step through rows,
8read columns, bind parameters, read the error text. Module SQLite3Demo — the usage examples.
9Declare statements bind those calls to sqlite3.dll — a Windows component that is not part of this workbook.
10
11What SumOffice does with it
12Keeps the whole VBA project byte-for-byte through open and save, and reads it: names, modules, entry points,
13references and every external dependency. Nothing here runs by itself, and the engine never calls sqlite3.dll.
14A macro can only be run on a copy, with your permission, and only when everything it needs is available here.
15
16Try it with the assistant
17Press ✦ Agent and ask:
18 • What is this workbook for? List its VBA modules and what each one does.
19 • Which entry points can run here, and what blocks the rest?
20 • Explain the Declare statements: which library do they need and what happens without it.
21
22The passport in the assistant panel answers the same questions without a model: what the workbook may do,
23what it asks the system for, and what is refused here.
24
25SQLite for Excel is a third-party open-source library. It is published here unchanged, as a real file.
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96

Canvas grid keeps keyboard focus on the visible cell selection. Arrow keys move the active cell inside the visible window. Alt+Up/Down and bottom-bar buttons move through visible read-only surface objects. Escape returns from object selection to cells.

Sheets 4 листа | видимые вкладки
About this exhibit -> xl/worksheets/sheet1.xml
ready n/a live_verified live_verified updated_truthfully
About this exhibit -> xl/worksheets/sheet1.xml
ready n/a live_verified live_verified values_only_same_workbook_sheet no no no no no no live_verified unreferenced_bounded_sheet_only live_verified last_unreferenced_bounded_sheet_current_session save_reopen_after_restore_live blocked_truthful_boundary no live_verified same_workbook_sheet_order_only true no true live_verified same_workbook_visible_hidden_very_hidden live_verified blocked_truthful_boundary live_verified same_workbook_worksheet_sheetPr_tabColor_rgb live_verified same_workbook_worksheet_sheetPr_codeName live_verified same_workbook_unpassworded_sheetProtection_metadata no live_verified active_worksheet_cells_only_preserve_sheet_metadata no

Нижний shell показывает видимые вкладки книги. Переключение листов live только при host bridge; вставка листа остаётся non-live.

ReadyInsertingDeletingFittingOpeningSortingFiltering Cell mode
100 %