| blob | a1a8be63f46aa066e945192c88a6413bcfeeffb4 |
1 /* -*- Mode: C++; tab-width: 4; indent-tabs-mode: nil; c-basic-offset: 4 -*- */
2 /*
3 * This file is part of the LibreOffice project.
4 *
5 * This Source Code Form is subject to the terms of the Mozilla Public
6 * License, v. 2.0. If a copy of the MPL was not distributed with this
7 * file, You can obtain one at http://mozilla.org/MPL/2.0/.
8 *
9 * This file incorporates work covered by the following license notice:
10 *
11 * Licensed to the Apache Software Foundation (ASF) under one or more
12 * contributor license agreements. See the NOTICE file distributed
13 * with this work for additional information regarding copyright
14 * ownership. The ASF licenses this file to you under the Apache
15 * License, Version 2.0 (the "License"); you may not use this file
16 * except in compliance with the License. You may obtain a copy of
17 * the License at http://www.apache.org/licenses/LICENSE-2.0 .
18 */
20 #ifndef SC_SC_HRC
21 #define SC_SC_HRC
23 #include <svx/svxids.hrc>
25 class ScTpPrintItem;
26 class SvxZoomSliderItem;
28 // areas
30 #ifndef SC_VIEW_START // duplicated in sfx2/sfxsids.hrc
31 #define SC_VIEW_START (SID_SC_START)
32 #endif
33 // SC_VIEW_END (SID_SC_START + 99)
34 #define SC_MESSAGE_START (SID_SC_START + 100)
35 // SC_MESSAGE_END (SID_SC_START + 199)
36 #ifndef SC_FUNCTION_START // duplicated in sfx2/sfxsids.hrc
37 #define SC_FUNCTION_START (SID_SC_START + 200)
38 #endif
39 // SC_FUNCTION_END (SID_SC_START + 299)
40 #define SC_PARAM_START (SID_SC_START + 300)
41 // SC_PARAM_END (SID_SC_START + 399)
42 #define SC_SIDEBAR_PROPERTY_BEGIN (SID_SC_START + 400)
43 // SC_SIDEBAR_PROPERTY_END (SID_SC_START + 499)
45 // stay compatible to the past
46 #define SC_RESOURCE_START (RID_APP_START+5000)
48 // help IDs -
49 // calc has a range of 2000 IDs
50 // the functions need 11*90 = 990 IDs
52 #define HID_SC_SHEET_START (HID_SC_START + 1010)
53 #define HID_SC_SHELL_START (HID_SC_START + 1030)
55 // help IDs for templates
56 #define HID_SC_SHEET_CELL_STD (HID_SC_SHEET_START +0 )
57 #define HID_SC_SHEET_CELL_ERG1 (HID_SC_SHEET_START +2 )
58 #define HID_SC_SHEET_PAGE_STD (HID_SC_SHEET_START +10 )
59 #define HID_SC_SHEET_PAGE_REP (HID_SC_SHEET_START +11 )
61 // view-functions (max. 100)
62 #define FID_SCALESTATUS (SC_VIEW_START + 10)
63 #define SID_UPDATECHART (SC_VIEW_START + 13)
65 // TabPage entry - Legacy selection
66 #define SID_SC_INPUT_LEGACY_CELL_SELECTION TypedWhichId<SfxBoolItem>(SC_VIEW_START + 15)
67 #define SID_SC_OPT_SORT_REF_UPDATE TypedWhichId<SfxBoolItem>(SC_VIEW_START + 16)
69 // Format options
70 #define SID_SCFORMULAOPTIONS TypedWhichId<ScTpFormulaItem>(SC_VIEW_START + 20)
71 #define SID_SCDEFAULTSOPTIONS TypedWhichId<ScTpDefaultsItem>(SC_VIEW_START + 21)
74 #define SID_DATA_PROVIDER (SC_VIEW_START + 31)
75 #define SID_DATA_PROVIDER_REFRESH (SC_VIEW_START + 32)
76 #define SID_DATA_STREAMS_PLAY (SC_VIEW_START + 33)
77 #define SID_DATA_STREAMS_STOP (SC_VIEW_START + 34)
78 #define SID_DATA_STREAMS (SC_VIEW_START + 35)
80 // slot-IDs for attributes
81 #define SID_SCATTR_PROTECTION (SC_VIEW_START + 36) // protection-page
83 // other slot-IDs:
84 #define SID_SCUSERLISTS (SC_VIEW_START + 37) // user defined lists
85 #define RES_TBX_DUMMY (SC_VIEW_START + 38) // dummy-item
86 #define SID_SCVIEWOPTIONS TypedWhichId<ScTpViewItem>(SC_VIEW_START + 39)
87 #define SID_SCDOCOPTIONS TypedWhichId<ScTpCalcItem>(SC_VIEW_START + 40)
89 // cursor movements as properties:
90 #define SID_CURRENTCELL TypedWhichId<SfxStringItem>(SC_VIEW_START + 41)
91 #define SID_CURRENTTAB TypedWhichId<SfxUInt16Item>(SC_VIEW_START + 42)
92 #define SID_CURRENTDOC TypedWhichId<SfxStringItem>(SC_VIEW_START + 43)
93 #define SID_CURRENTOBJECT TypedWhichId<SfxStringItem>(SC_VIEW_START + 44)
95 // slot-IDs for special toolbox functions:
96 #define SID_NUMBER_CURRENCY (SC_VIEW_START + 45)
97 #define SID_NUMBER_PERCENT (SC_VIEW_START + 46)
99 // "slot" IDs for input images:
100 // 47..51 are used for toolbox ids
102 #define SID_NUMBER_STANDARD (SC_VIEW_START + 52)
103 #define SID_NUMBER_DATE (SC_VIEW_START + 53)
104 #define SID_NUMBER_TWODEC (SC_VIEW_START + 54)
105 #define SID_NUMBER_SCIENTIFIC (SC_VIEW_START + 55)
106 #define SID_NUMBER_TIME (SC_VIEW_START + 56)
107 #define SID_NUMBER_INCDEC (SC_VIEW_START + 57)
108 #define SID_NUMBER_DECDEC (SC_VIEW_START + 58)
109 #define SID_NUMBER_THOUSANDS (SC_VIEW_START + 59)
111 // misc:
112 #define SID_LINKS (SC_VIEW_START + 60)
113 #define SID_SC_INPUT_WARNACTIVESHEET TypedWhichId<SfxBoolItem>(SC_VIEW_START + 61)
114 #define SID_INSERT_SMATH (SC_VIEW_START + 63)
115 // Put this here since all available slots for "SC_INPUT" are taken
116 #define SID_SC_INPUT_ENTER_PASTE_MODE TypedWhichId<SfxBoolItem>(SC_VIEW_START + 64)
117 #define SID_MIRROR_VERTICAL (SC_VIEW_START + 65)
118 #define SID_MIRROR_HORIZONTAL (SC_VIEW_START + 66)
119 #define SID_CELL_FORMAT_RESET (SC_VIEW_START + 67)
120 #define SID_SCPRINTOPTIONS TypedWhichId<ScTpPrintItem>(SC_VIEW_START + 68)
121 #define SID_WINDOW_SPLIT (SC_VIEW_START + 69)
122 #define SID_WINDOW_FIX (SC_VIEW_START + 70)
123 #define SID_DRAW_CHART (SC_VIEW_START + 71)
124 #define SID_UPDATETABLINKS (SC_VIEW_START + 72)
126 // TabPage entry
127 #define SID_SC_INPUT_SELECTION TypedWhichId<SfxBoolItem>(SC_VIEW_START + 73)
128 #define SID_SC_INPUT_SELECTIONPOS TypedWhichId<SfxUInt16Item>(SC_VIEW_START + 74)
129 #define SID_SC_INPUT_EDITMODE TypedWhichId<SfxBoolItem>(SC_VIEW_START + 75)
130 #define SID_SC_INPUT_FMT_EXPAND TypedWhichId<SfxBoolItem>(SC_VIEW_START + 76)
131 #define SID_SC_INPUT_RANGEFINDER TypedWhichId<SfxBoolItem>(SC_VIEW_START + 77)
132 #define SID_SC_INPUT_REF_EXPAND TypedWhichId<SfxBoolItem>(SC_VIEW_START + 78)
133 #define SID_SC_INPUT_MARK_HEADER TypedWhichId<SfxBoolItem>(SC_VIEW_START + 79)
135 #define SID_REIMPORT_AFTER_LOAD (SC_VIEW_START + 80)
136 #define SID_DRAW_NOTEEDIT (SC_VIEW_START + 81)
138 #define SID_CHOOSE_DESIGN (SC_VIEW_START + 82)
139 #define SID_EURO_CONVERTER (SC_VIEW_START + 83)
140 //See include/sfx2/sfxsids.hrc for reserved usage of (SC_VIEW_START + 84)
141 #define SID_EXTERNAL_SOURCE (SC_VIEW_START + 85)
143 #define SID_SC_INPUT_TEXTWYSIWYG TypedWhichId<SfxBoolItem>(SC_VIEW_START + 86)
145 #define SID_ENABLE_HYPHENATION (SC_VIEW_START + 87)
147 #define SID_RENAME_OBJECT (SC_VIEW_START + 88)
148 #define SID_FOCUS_INPUTLINE (SC_VIEW_START + 89)
149 #define SID_SELECT_TABLES TypedWhichId<SfxIntegerListItem>(SC_VIEW_START + 90)
151 // new entry "Filter..." in DP popup menu
152 #define SID_DP_FILTER (SC_VIEW_START + 91)
154 // replace cell contents warning
155 #define SID_SC_INPUT_REPLCELLSWARN TypedWhichId<SfxBoolItem>(SC_VIEW_START + 92)
157 // additional IDs for list/range validity
158 #define FID_VALID_LISTTYPE TypedWhichId<SfxInt16Item>(SC_VIEW_START + 93)
160 // #i68101# ID for changing title & description of an object
161 #define SID_TITLE_DESCRIPTION_OBJECT (SC_VIEW_START + 94)
163 // #i59082# assign macro to shape
164 #define SID_ASSIGNMACRO (SC_VIEW_START + 95)
166 // "Zoom / Synchronize sheets" in options dialog
167 #define SID_SC_OPT_SYNCZOOM TypedWhichId<SfxBoolItem>(SC_VIEW_START + 98)
169 #define SID_SC_OPT_KEY_BINDING_COMPAT TypedWhichId<SfxUInt16Item>(SC_VIEW_START + 99)
171 // NOTE: last valid ID is (SC_VIEW_START + 100)
173 // messages
175 #define FID_INPUTLINE_STATUS (SC_MESSAGE_START)
176 #define FID_INPUTLINE_ENTER (SC_MESSAGE_START + 1)
177 #define FID_REPAINT (SC_MESSAGE_START + 2)
178 #define SID_SOLVE (SC_MESSAGE_START + 6)
179 #define FID_FILTER_OK (SC_MESSAGE_START + 8)
180 #define FID_INPUTLINE_MATRIX (SC_MESSAGE_START + 11)
181 #define SID_DLG_RETOK (SC_MESSAGE_START + 12)
182 #define SID_STATUS_DOCPOS TypedWhichId<SfxStringItem>(SC_MESSAGE_START + 14)
183 #define SID_STATUS_PAGESTYLE TypedWhichId<SfxStringItem>(SC_MESSAGE_START + 15)
184 #define SID_STATUS_SELMODE TypedWhichId<SfxUInt16Item>(SC_MESSAGE_START + 16)
185 #define SID_DLG_MATRIX (SC_MESSAGE_START + 18)
187 #define SID_STATUS_SELMODE_ERG (SC_MESSAGE_START + 22)
188 #define SID_STATUS_SELMODE_ERW (SC_MESSAGE_START + 23)
189 #define SID_STATUS_SELMODE_NORM (SC_MESSAGE_START + 24)
191 #define SID_CHART_SOURCE TypedWhichId<SfxStringItem>(SC_MESSAGE_START + 25)
192 #define SID_CHART_NAME TypedWhichId<SfxStringItem>(SC_MESSAGE_START + 26)
193 #define SID_CHART_ADDSOURCE (SC_MESSAGE_START + 27)
195 #define SID_AUTO_STYLE (SC_MESSAGE_START + 28)
197 #define FID_INPUTLINE_BLOCK (SC_MESSAGE_START + 29)
199 #define SID_STATUS_SUM TypedWhichId<SfxStringItem>(SC_MESSAGE_START + 30)
201 #define SID_ENTER_STRING TypedWhichId<SfxStringItem>(SC_MESSAGE_START + 37)
202 #define SID_ROWCOL_SELCOUNT (SC_MESSAGE_START + 38)
203 #define SID_AUTO_SUM (SC_MESSAGE_START + 39)
205 // messages for opening dialogs:
206 #define SID_OPENDLG_CONSOLIDATE (SC_MESSAGE_START + 50)
207 #define SID_OPENDLG_PIVOTTABLE (SC_MESSAGE_START + 51)
208 #define SID_OPENDLG_FUNCTION (SC_MESSAGE_START + 52)
209 #define SID_OPENDLG_SOLVE (SC_MESSAGE_START + 53)
210 #define SID_OPENDLG_TABOP (SC_MESSAGE_START + 54)
211 #define SID_OPENDLG_CURRENTCONDFRMT (SC_MESSAGE_START + 58)
212 #define SID_OPENDLG_CONDFRMT (SC_MESSAGE_START + 59)
213 #define SID_OPENDLG_OPTSOLVER (SC_MESSAGE_START + 60)
214 #define SID_VALIDITY_REFERENCE (SC_MESSAGE_START + 61)
215 #define SID_OPENDLG_CONDFRMT_MANAGER (SC_MESSAGE_START + 62)
216 #define SID_POPUP_CONDFRMT (SC_MESSAGE_START + 63)
217 #define SID_OPENDLG_CURRENTCONDFRMT_MANAGER (SC_MESSAGE_START + 64)
218 #define SID_OPENDLG_COLORSCALE (SC_MESSAGE_START + 66)
219 #define SID_OPENDLG_DATABAR (SC_MESSAGE_START + 67)
220 #define SID_OPENDLG_ICONSET (SC_MESSAGE_START + 68)
221 #define SID_OPENDLG_CONDDATE (SC_MESSAGE_START + 69)
223 #define SID_RANDOM_NUMBER_GENERATOR_DIALOG (SC_MESSAGE_START + 70)
224 #define SID_SAMPLING_DIALOG (SC_MESSAGE_START + 71)
225 #define SID_DESCRIPTIVE_STATISTICS_DIALOG (SC_MESSAGE_START + 72)
226 #define SID_ANALYSIS_OF_VARIANCE_DIALOG (SC_MESSAGE_START + 73)
227 #define SID_CORRELATION_DIALOG (SC_MESSAGE_START + 74)
228 #define SID_COVARIANCE_DIALOG (SC_MESSAGE_START + 75)
229 #define SID_EXPONENTIAL_SMOOTHING_DIALOG (SC_MESSAGE_START + 76)
230 #define SID_MOVING_AVERAGE_DIALOG (SC_MESSAGE_START + 77)
231 #define SID_REGRESSION_DIALOG (SC_MESSAGE_START + 78)
232 #define SID_TTEST_DIALOG (SC_MESSAGE_START + 79)
233 #define SID_FTEST_DIALOG (SC_MESSAGE_START + 80)
234 #define SID_ZTEST_DIALOG (SC_MESSAGE_START + 81)
235 #define SID_CHI_SQUARE_TEST_DIALOG (SC_MESSAGE_START + 82)
236 #define SID_SEARCH_RESULTS_DIALOG (SC_MESSAGE_START + 83)
237 #define SID_WINDOW_FIX_ROW TypedWhichId<SfxInt32Item>(SC_MESSAGE_START + 84)
238 #define SID_WINDOW_FIX_COL TypedWhichId<SfxInt32Item>(SC_MESSAGE_START + 85)
239 #define SID_COLUMN_OPERATIONS (SC_MESSAGE_START + 86)
240 #define SID_ROW_OPERATIONS (SC_MESSAGE_START + 87)
241 #define SID_FOURIER_ANALYSIS_DIALOG (SC_MESSAGE_START + 88)
242 #define SID_SPARKLINE_DIALOG (SC_MESSAGE_START + 89)
243 #define SID_SPARKLINE_DATA_RANGE_DIALOG (SC_MESSAGE_START + 90)
244 #define SID_POPUP_EASY_CONDITIONAL_FORMAT (SC_MESSAGE_START + 91)
245 #define SID_EASY_CONDITIONAL_FORMAT_DIALOG (SC_MESSAGE_START + 92)
247 // functions
249 #define SID_OPEN_CALC (SC_FUNCTION_START + 4)
250 #define SID_CONVERT_FORMULA_TO_VALUE (SC_FUNCTION_START + 5)
251 #define FID_MOVE_KEEP_INSERT_MODE (SC_FUNCTION_START + 6)
252 #ifndef FILE_MENU_END // duplicated in sfx2/sfxsids.hrc
253 #define FILE_MENU_END (SC_FUNCTION_START + 20)
254 #endif
256 #ifndef EDIT_MENU_START // duplicated in sfx2/sfxsids.hrc
257 #define EDIT_MENU_START (FILE_MENU_END)
258 #endif
259 #define FID_DELETE_CELL TypedWhichId<SfxStringItem>(EDIT_MENU_START + 2)
260 #define FID_DELETE_TABLE (EDIT_MENU_START + 3)
261 #define FID_FILL_TO_BOTTOM (EDIT_MENU_START + 4)
262 #define FID_FILL_TO_RIGHT (EDIT_MENU_START + 5)
263 #define FID_FILL_TO_TOP (EDIT_MENU_START + 6)
264 #define FID_FILL_TO_LEFT (EDIT_MENU_START + 7)
265 #define FID_FILL_TAB TypedWhichId<SfxStringItem>(EDIT_MENU_START + 8)
266 #define FID_FILL_SERIES TypedWhichId<SfxStringItem>(EDIT_MENU_START + 9)
267 #define FID_FILL_SINGLE_EDIT (EDIT_MENU_START + 10)
268 #define SID_HFEDIT (EDIT_MENU_START + 15)
270 #define SID_DEL_ROWS (EDIT_MENU_START + 16)//JN
271 #define SID_DEL_COLS (EDIT_MENU_START + 17)//JN
272 // EDIT_MENU_START + 18 is defined in include/sfx2/sfxsids.hrc
273 #define FID_CHG_SHOW (EDIT_MENU_START + 19)
275 #define EDIT_MENU_END (EDIT_MENU_START + 20)
276 #define VIEW_MENU_START (EDIT_MENU_END)
278 #define FID_TOGGLEINPUTLINE TypedWhichId<SfxBoolItem>(VIEW_MENU_START + 1)
279 #define FID_TOGGLEHEADERS (VIEW_MENU_START + 2)
280 #define FID_HANDLEDUPLICATERECORDS (VIEW_MENU_START + 3)
281 #define FID_SCALE TypedWhichId<SvxZoomItem>(VIEW_MENU_START + 4)
282 #define FID_TOGGLESYNTAX (VIEW_MENU_START + 5)
283 #define FID_TOGGLECOLROWHIGHLIGHTING (VIEW_MENU_START + 6)
284 #define FID_PAGEBREAKMODE (VIEW_MENU_START + 7)
285 #define FID_FUNCTION_BOX (VIEW_MENU_START + 8)
286 #define FID_NORMALVIEWMODE (VIEW_MENU_START + 9)
287 #define FID_TOGGLEFORMULA (VIEW_MENU_START + 10)
289 #define FID_CHG_ACCEPT (VIEW_MENU_START + 18)// DANGER DIRTY ID
290 #define FID_CHG_COMMENT (VIEW_MENU_START + 19)// DANGER DIRTY ID
291 #define VIEW_MENU_END (VIEW_MENU_START + 20)
293 #define INSERT_MENU_START (VIEW_MENU_END)
294 #define FID_INS_ROWBRK (INSERT_MENU_START + 1)
295 #define FID_INS_COLBRK (INSERT_MENU_START + 2)
296 #define FID_DEL_ROWBRK (INSERT_MENU_START + 3)
297 #define FID_DEL_COLBRK (INSERT_MENU_START + 4)
298 #define FID_INS_CELL_CONTENTS TypedWhichId<SfxStringItem>(INSERT_MENU_START + 5)
299 #define FID_INS_CELL TypedWhichId<SfxStringItem>(INSERT_MENU_START + 6)
300 #define FID_INS_ROW (INSERT_MENU_START + 7)
301 #define FID_INS_COLUMN (INSERT_MENU_START + 8)
302 #define FID_INS_TABLE TypedWhichId<SfxStringItem>(INSERT_MENU_START + 9)
303 #define SID_INS_FUNCTION (INSERT_MENU_START + 10)
304 #define FID_DEFINE_NAME (INSERT_MENU_START + 11)
305 #define FID_INSERT_NAME (INSERT_MENU_START + 12)
306 #define FID_USE_NAME (INSERT_MENU_START + 13)
307 #define FID_APPLY_NAME (INSERT_MENU_START + 14)
308 #define FID_INS_TABLE_EXT (INSERT_MENU_START + 15)
309 #define FID_ADD_NAME (INSERT_MENU_START + 16)
310 #define FID_INS_CELLSDOWN (INSERT_MENU_START + 18)
311 #define FID_INS_CELLSRIGHT (INSERT_MENU_START + 19)
312 #define FID_INS_ROWS_AFTER (INSERT_MENU_START + 20)
313 #define FID_INS_COLUMNS_AFTER (INSERT_MENU_START + 21)
314 #define FID_INS_ROWS_BEFORE (INSERT_MENU_START + 22)
315 #define FID_INS_COLUMNS_BEFORE (INSERT_MENU_START + 23)
316 #define FID_DEFINE_CURRENT_NAME (INSERT_MENU_START + 24)
317 #define INSERT_MENU_END (INSERT_MENU_START + 25)
319 #define FORMAT_MENU_START (INSERT_MENU_END)
320 #define FID_CELL_FORMAT (FORMAT_MENU_START)
321 #define FID_ROW_HEIGHT TypedWhichId<SfxUInt16Item>(FORMAT_MENU_START + 1)
322 #define FID_ROW_OPT_HEIGHT TypedWhichId<SfxUInt16Item>(FORMAT_MENU_START + 2)
323 #define FID_ROW_HIDE (FORMAT_MENU_START + 3)
324 #define FID_ROW_SHOW (FORMAT_MENU_START + 4)
325 #define FID_COL_WIDTH TypedWhichId<SfxUInt16Item>(FORMAT_MENU_START + 5)
326 #define FID_COL_OPT_WIDTH TypedWhichId<SfxUInt16Item>(FORMAT_MENU_START + 6)
327 #define FID_COL_HIDE (FORMAT_MENU_START + 7)
328 #define FID_COL_SHOW (FORMAT_MENU_START + 8)
329 #define FID_TABLE_HIDE (FORMAT_MENU_START + 9)
330 #define FID_TABLE_SHOW TypedWhichId<SfxStringItem>(FORMAT_MENU_START + 10)
331 #define FID_MERGE_ON (FORMAT_MENU_START + 15)
332 #define FID_MERGE_OFF (FORMAT_MENU_START + 16)
333 #define SID_FORMATPAGE (FORMAT_MENU_START + 17)
334 #define SID_TEXT_STANDARD (FORMAT_MENU_START + 18)
335 #define SID_DRAWTEXT_ATTR_DLG (FORMAT_MENU_START + 19)
336 #define FID_TABLE_VISIBLE (FORMAT_MENU_START + 20)
337 #define FID_COL_OPT_DIRECT (FORMAT_MENU_START + 21)
338 #define FID_TOGGLEHIDDENCOLROW (FORMAT_MENU_START + 22)
339 #define FORMAT_MENU_END (FORMAT_MENU_START + 23)
341 #define EXTRA_MENU_START (FORMAT_MENU_END)
342 #define FID_AUTO_CALC (EXTRA_MENU_START + 3)
343 #define FID_RECALC (EXTRA_MENU_START + 4)
344 #define FID_PROTECT_TABLE (EXTRA_MENU_START + 6)
345 #define FID_PROTECT_DOC (EXTRA_MENU_START + 7)
346 #define SID_SHARE_DOC (EXTRA_MENU_START + 11)
347 #define SID_SCENARIOS TypedWhichId<SfxStringItem>(EXTRA_MENU_START + 12)
348 #define SID_PIVOT_RECALC (EXTRA_MENU_START + 14)
349 #define SID_PIVOT_KILL (EXTRA_MENU_START + 15)
351 #define FID_HARD_RECALC (EXTRA_MENU_START + 18)
352 #define FID_AUTOCOMPLETE (EXTRA_MENU_START + 19)
354 #define EXTRA_MENU_END (EXTRA_MENU_START + 20)
356 #define DATA_MENU_START (EXTRA_MENU_END)
357 #define SID_DEFINE_DBNAME (DATA_MENU_START)
358 #define SID_SELECT_DB TypedWhichId<SfxStringItem>(DATA_MENU_START + 1)
359 #define SID_SORT (DATA_MENU_START + 2)
360 #define SID_FILTER (DATA_MENU_START + 3)
361 #define SID_SPECIAL_FILTER (DATA_MENU_START + 4)
362 #define SID_AUTO_FILTER (DATA_MENU_START + 5)
363 #define SID_UNFILTER (DATA_MENU_START + 6)
364 #define SID_QUERY (DATA_MENU_START + 7)
365 #define SID_MANAGE_XML_SOURCE (DATA_MENU_START + 8)
366 #define SID_SUBTOTALS (DATA_MENU_START + 13)
367 #define SID_AUTO_OUTLINE (DATA_MENU_START + 14)
368 #define SID_REIMPORT_DATA (DATA_MENU_START + 16)
369 #define SID_PIVOT_TABLE (DATA_MENU_START + 17)
370 #define SID_TABOP (DATA_MENU_START + 18)
371 #define SID_TEXT_TO_COLUMNS (DATA_MENU_START + 19)
372 #define SID_CONSOLIDATE (DATA_MENU_START + 20)
373 #define SID_AUTOFILTER_HIDE (DATA_MENU_START + 21)
374 #define SID_SBA_IMPORT (DATA_MENU_START + 22)
375 #define SID_SORT_DESCENDING (DATA_MENU_START + 23)
376 #define SID_SORT_ASCENDING (DATA_MENU_START + 24)
377 #define SID_OUTLINE_HIDE (DATA_MENU_START + 25)
378 #define SID_OUTLINE_SHOW (DATA_MENU_START + 26)
379 #define SID_OUTLINE_MAKE TypedWhichId<SfxStringItem>(DATA_MENU_START + 27)
380 #define SID_OUTLINE_REMOVE TypedWhichId<SfxStringItem>(DATA_MENU_START + 28)
382 #define DATA_MENU_END (DATA_MENU_START + 29)
384 #define TAB_POPUP_START (DATA_MENU_END)
385 #define FID_TAB_MENU_RENAME (TAB_POPUP_START)
386 #define FID_TAB_RENAME TypedWhichId<SfxStringItem>(TAB_POPUP_START+1)
387 #define FID_TAB_MOVE TypedWhichId<SfxStringItem>(TAB_POPUP_START+2)
388 #define FID_TAB_SELECTALL (TAB_POPUP_START+3)
389 #define FID_TAB_APPEND (TAB_POPUP_START+4)
390 #define FID_TAB_INDEX (TAB_POPUP_START+5)
391 #define FID_TAB_RTL (TAB_POPUP_START+6)
392 #define FID_TAB_DESELECTALL (TAB_POPUP_START+7)
393 #define FID_TAB_MENU_SET_TAB_BG_COLOR (TAB_POPUP_START + 8)
394 #define FID_TAB_SET_TAB_BG_COLOR (TAB_POPUP_START + 9)
395 #define FID_TAB_EVENTS (TAB_POPUP_START+10)
396 #define FID_TAB_DUPLICATE (TAB_POPUP_START+11)
398 #define TAB_POPUP_END (TAB_POPUP_START + 20)
400 #define OBJBAR_FORMAT_START (TAB_POPUP_END)
401 #define SID_ALIGNLEFT (OBJBAR_FORMAT_START+6)
402 #define SID_ALIGNRIGHT (OBJBAR_FORMAT_START+7)
403 #define SID_ALIGNCENTERHOR (OBJBAR_FORMAT_START+8)
404 #define SID_ALIGNBLOCK (OBJBAR_FORMAT_START+9)
405 #define SID_ALIGNTOP (OBJBAR_FORMAT_START+10)
406 #define SID_ALIGNBOTTOM (OBJBAR_FORMAT_START+11)
407 #define SID_ALIGNCENTERVER (OBJBAR_FORMAT_START+12)
408 #define SID_SELECT_SCENARIO TypedWhichId<SfxStringItem>(OBJBAR_FORMAT_START+13)
410 #define SID_V_ALIGNCELL (OBJBAR_FORMAT_START+14)
411 #define SID_H_ALIGNCELL (OBJBAR_FORMAT_START+15)
413 #define OBJBAR_FORMAT_END (OBJBAR_FORMAT_START+20)
415 #define RID_INPUTBAR_START (OBJBAR_FORMAT_END)
416 #define RID_INPUTBAR_END (RID_INPUTBAR_START+1)
418 #define DRAW_BAR_START (RID_INPUTBAR_END)
419 #define SID_ANCHOR_PAGE (DRAW_BAR_START+24)
420 #define SID_ANCHOR_CELL (DRAW_BAR_START+25)
421 #define SID_ANCHOR_CELL_RESIZE (DRAW_BAR_START+26)
422 #define SID_ANCHOR_TOGGLE (DRAW_BAR_START+27)
423 #define SID_ORIGINALSIZE (DRAW_BAR_START+28)
424 #define SID_FITCELLSIZE (DRAW_BAR_START+29)
426 #define DRAW_BAR_END (DRAW_BAR_START+50)
428 #define DRAWTEXTBAR_START (DRAW_BAR_END)
429 #define DRAWTEXTBAR_END (DRAWTEXTBAR_START+20)
431 #define DETECTIVE_START (DRAWTEXTBAR_END)
432 #define SID_DETECTIVE_ADD_PRED (DETECTIVE_START)
433 #define SID_DETECTIVE_DEL_PRED (DETECTIVE_START+1)
434 #define SID_DETECTIVE_ADD_SUCC (DETECTIVE_START+2)
435 #define SID_DETECTIVE_DEL_SUCC (DETECTIVE_START+3)
436 #define SID_DETECTIVE_ADD_ERR (DETECTIVE_START+4)
437 #define SID_DETECTIVE_DEL_ALL (DETECTIVE_START+5)
439 #define SID_DETECTIVE_FILLMODE (DETECTIVE_START+6)
440 #define SID_FILL_ADD_PRED (DETECTIVE_START+7)
441 #define SID_FILL_DEL_PRED (DETECTIVE_START+8)
442 #define SID_FILL_ADD_SUCC (DETECTIVE_START+9)
443 #define SID_FILL_DEL_SUCC (DETECTIVE_START+10)
444 #define SID_FILL_NONE (DETECTIVE_START+11)
445 #define SID_FILL_SELECT (DETECTIVE_START+12)
447 #define SID_DETECTIVE_INVALID (DETECTIVE_START+13)
449 #define SID_DETECTIVE_REFRESH (DETECTIVE_START+14)
450 #define SID_DETECTIVE_AUTO (DETECTIVE_START+15)
452 #define SID_DETECTIVE_MARK_PRED (DETECTIVE_START+16)
453 #define SID_DETECTIVE_MARK_SUCC (DETECTIVE_START+17)
455 #define DETECTIVE_END (DETECTIVE_START+20)
457 #define SID_API_SLOTS (DETECTIVE_END)
458 #define SID_INSERT_MATRIX (SID_API_SLOTS+1)
460 #define SID_DELETE_NOTE (SID_API_SLOTS+2)
462 #define SID_PREVIEW_START (SID_API_SLOTS+20)
463 #define SID_PREVIEW_NEXT (SID_PREVIEW_START)
464 #define SID_PREVIEW_PREVIOUS (SID_PREVIEW_START+1)
465 #define SID_PREVIEW_FIRST (SID_PREVIEW_START+2)
466 #define SID_PREVIEW_LAST (SID_PREVIEW_START+3)
467 #define SID_PREVIEW_CLOSE (SID_PREVIEW_START+7)
468 #define SID_PREVIEW_MARGIN (SID_PREVIEW_START+8)
469 #define SID_PREVIEW_SCALINGFACTOR TypedWhichId<SvxZoomSliderItem>(SID_PREVIEW_START+9)
470 #define SID_PREVIEW_END (SID_PREVIEW_START+10)
472 // with SID_KEYFUNC_START defined in include/sfx2/sfxsids.hrc there is a risk of
473 // adding entries that cause an overlap here
474 static_assert(SID_PREVIEW_END < SID_KEYFUNC_START, "calc slots ids trampling info keyfunc slot range");
476 //from sfx: #define SID_KEYFUNC_START (SID_PREVIEW_END+5)
477 // from SID_KEYFUNC_START + 0 to SID_KEYFUNC_START + 13 are defined in include/sfx2/sfxsids.hrc
478 #define SID_CURSORPAGELEFT_ (SID_KEYFUNC_START + 6)
479 #define SID_CURSORPAGERIGHT_ (SID_KEYFUNC_START + 8)
480 #define SID_CURSORBLKUP (SID_KEYFUNC_START + 14)
481 #define SID_CURSORBLKDOWN (SID_KEYFUNC_START + 15)
482 #define SID_CURSORBLKLEFT (SID_KEYFUNC_START + 16)
483 #define SID_CURSORBLKRIGHT (SID_KEYFUNC_START + 17)
484 #define SID_CURSORBLKUP_SEL (SID_KEYFUNC_START + 18)
485 #define SID_CURSORBLKDOWN_SEL (SID_KEYFUNC_START + 19)
486 #define SID_CURSORBLKLEFT_SEL (SID_KEYFUNC_START + 20)
487 #define SID_CURSORBLKRIGHT_SEL (SID_KEYFUNC_START + 21)
489 #define SID_NEXT_TABLE (SID_KEYFUNC_START + 22)
490 #define SID_PREV_TABLE (SID_KEYFUNC_START + 23)
492 #define SID_NEXT_UNPROTECT (SID_KEYFUNC_START + 24)
493 #define SID_PREV_UNPROTECT (SID_KEYFUNC_START + 25)
495 #define SID_SELECT_COL (SID_KEYFUNC_START + 26)
496 #define SID_SELECT_ROW (SID_KEYFUNC_START + 27)
497 #define SID_SELECT_NONE (SID_KEYFUNC_START + 28)
498 #define SID_ALIGNCURSOR (SID_KEYFUNC_START + 29)
499 #define SID_MARKDATAAREA (SID_KEYFUNC_START + 30)
500 #define SID_SETINPUTMODE (SID_KEYFUNC_START + 31)
501 #define SID_DELETE_CONTENTS (SID_KEYFUNC_START + 32)
503 #define SID_MARKAREA (SID_KEYFUNC_START + 33)
505 #define FID_FILL_AUTO TypedWhichId<SfxStringItem>(SID_KEYFUNC_START + 35)
506 #define SID_CANCEL (SID_KEYFUNC_START + 36)
508 #define SID_CURSORENTERUP (SID_KEYFUNC_START + 37)
509 #define SID_CURSORENTERDOWN (SID_KEYFUNC_START + 38)
511 #define SID_MARKARRAYFORMULA (SID_KEYFUNC_START + 39)
513 #define SID_NEXT_TABLE_SEL (SID_KEYFUNC_START + 40)
514 #define SID_PREV_TABLE_SEL (SID_KEYFUNC_START + 41)
516 #define SID_ACCEPT_FORMULA (SID_KEYFUNC_START + 42)
517 #define SID_START_FORMULA (SID_KEYFUNC_START + 43)
518 #define SID_COPYDELETE (SID_KEYFUNC_START + 44)
520 #define SID_KEYFUNC_END (SID_KEYFUNC_START + 50)
522 #define SID_NEW_SLOTS (SID_KEYFUNC_END)
524 #define SID_NEW_TABLENAME TypedWhichId<SfxStringItem>(SID_NEW_SLOTS+1)
525 #define SID_EXPORT_AS_GRAPHIC (SID_NEW_SLOTS+2)
527 #define FID_MERGE_TOGGLE (SID_NEW_SLOTS+10)
529 #define SID_RANGE_ROW TypedWhichId<SfxInt32Item>(SID_NEW_SLOTS+20)
530 #define SID_RANGE_COL TypedWhichId<SfxInt16Item>(SID_NEW_SLOTS+21)
531 #define SID_RANGE_TABLE TypedWhichId<SfxInt16Item>(SID_NEW_SLOTS+22)
532 // empty, was SID_RANGE_VALUE
533 #define SID_RANGE_FORMULA TypedWhichId<SfxStringItem>(SID_NEW_SLOTS+24)
534 #define SID_RANGE_TEXTVALUE TypedWhichId<SfxStringItem>(SID_NEW_SLOTS+26)
535 #define SID_TABLE_ACTIVATE (SID_NEW_SLOTS+27)
537 #define SID_DEFINE_PRINTAREA (SID_NEW_SLOTS+31)
538 #define SID_DELETE_PRINTAREA (SID_NEW_SLOTS+32)
539 #define SID_CHANGE_PRINTAREA TypedWhichId<SfxStringItem>(SID_NEW_SLOTS+33)
540 #define SID_OPENDLG_EDIT_PRINTAREA (SID_NEW_SLOTS+34)
542 #define SID_OLE_ACTIVATE (SID_NEW_SLOTS+36)
543 #define SID_OLE_DEACTIVATE (SID_NEW_SLOTS+37)
545 #define SID_TOGGLE_REL (SID_NEW_SLOTS+38)
546 #define SID_DATA_SELECT (SID_NEW_SLOTS+39)
548 // search & replace
549 #define FID_SEARCH (SID_NEW_SLOTS+40)
550 #define FID_REPEAT_SEARCH (SID_NEW_SLOTS+41)
551 #define FID_REPLACE (SID_NEW_SLOTS+42)
552 #define FID_SEARCH_ALL (SID_NEW_SLOTS+43)
553 #define FID_REPLACE_ALL (SID_NEW_SLOTS+44)
554 #define FID_SEARCH_COUNT (SID_NEW_SLOTS+45)
556 #define SID_SC_SETTEXT (SID_NEW_SLOTS+46)
557 #define SID_RANGE_ADDRESS TypedWhichId<SfxStringItem>(SID_NEW_SLOTS+47)
558 #define SID_NUMBER_FORMAT TypedWhichId<SfxStringItem>(SID_NEW_SLOTS+49)
560 #define SID_OLE_SELECT (SID_NEW_SLOTS+50)
562 #define FID_CURRENTVALIDATION (SID_NEW_SLOTS+51)
563 #define SID_RANGE_NOTETEXT TypedWhichId<SfxStringItem>(SID_NEW_SLOTS+52)
564 #define FID_INSERT_FILE (SID_NEW_SLOTS+53)
566 #define FID_VALIDATION (SID_NEW_SLOTS+54)
568 // slots for toolbox controller in toolbar
569 #define SID_TBXCTL_INSERT (SID_NEW_SLOTS+55)
570 #define SID_TBXCTL_INSCELLS (SID_NEW_SLOTS+56)
572 #define SID_DEFINE_COLROWNAMERANGES (SID_NEW_SLOTS+58)
574 #define FID_NOTE_VISIBLE (SID_NEW_SLOTS+59)
576 // items for validation
577 #define FID_VALID_MODE TypedWhichId<SfxUInt16Item>(SID_NEW_SLOTS+60)
578 #define FID_VALID_CONDMODE TypedWhichId<SfxUInt16Item>(SID_NEW_SLOTS+61)
579 #define FID_VALID_VALUE1 TypedWhichId<SfxStringItem>(SID_NEW_SLOTS+62)
580 #define FID_VALID_VALUE2 TypedWhichId<SfxStringItem>(SID_NEW_SLOTS+63)
581 #define FID_VALID_BLANK TypedWhichId<SfxBoolItem>(SID_NEW_SLOTS+64)
582 #define FID_VALID_CASESENS TypedWhichId<SfxBoolItem>(SID_NEW_SLOTS+65)
583 #define FID_VALID_SHOWHELP TypedWhichId<SfxBoolItem>(SID_NEW_SLOTS+66)
584 #define FID_VALID_HELPTITLE TypedWhichId<SfxStringItem>(SID_NEW_SLOTS+67)
585 #define FID_VALID_HELPTEXT TypedWhichId<SfxStringItem>(SID_NEW_SLOTS+68)
586 #define FID_VALID_SHOWERR TypedWhichId<SfxBoolItem>(SID_NEW_SLOTS+69)
587 #define FID_VALID_ERRSTYLE TypedWhichId<SfxUInt16Item>(SID_NEW_SLOTS+70)
588 #define FID_VALID_ERRTITLE TypedWhichId<SfxStringItem>(SID_NEW_SLOTS+71)
589 #define FID_VALID_ERRTEXT TypedWhichId<SfxStringItem>(SID_NEW_SLOTS+72)
591 #define SID_REFRESH_DBAREA (SID_NEW_SLOTS+73)
593 #define FID_FOCUS_POSWND (SID_NEW_SLOTS+74)
595 #define FID_DEL_MANUALBREAKS (SID_NEW_SLOTS+79)
596 #define SID_ADD_PRINTAREA (SID_NEW_SLOTS+80)
597 #define FID_ADJUST_PRINTZOOM (SID_NEW_SLOTS+81)
598 #define FID_RESET_PRINTZOOM (SID_NEW_SLOTS+82)
600 #define SID_TABLES_COUNT (SID_NEW_SLOTS+83)
601 #define SID_ACTIVE_OBJ_NAME TypedWhichId<SfxStringItem>(SID_NEW_SLOTS+84)
602 #define SID_OBJECT_LEFT (SID_NEW_SLOTS+85)
603 #define SID_OBJECT_TOP (SID_NEW_SLOTS+86)
604 #define SID_OBJECT_WIDTH (SID_NEW_SLOTS+87)
605 #define SID_OBJECT_HEIGHT (SID_NEW_SLOTS+88)
607 #define SID_DELETE_SCENARIO (SID_NEW_SLOTS+95)
608 #define SID_EDIT_SCENARIO (SID_NEW_SLOTS+96)
609 #define SID_INSERT_FIELD_SHEET (SID_NEW_SLOTS+97)
610 #define SID_INSERT_FIELD_TITLE (SID_NEW_SLOTS+98)
611 #define SID_INSERT_FIELD_DATE_VAR (SID_NEW_SLOTS+99)
613 #define FID_SHOW_NOTE (SID_NEW_SLOTS+100)
614 #define FID_HIDE_NOTE (SID_NEW_SLOTS+101)
615 #define FID_SHOW_ALL_NOTES (SID_NEW_SLOTS+102)
616 #define FID_HIDE_ALL_NOTES (SID_NEW_SLOTS+103)
617 #define FID_DELETE_ALL_NOTES (SID_NEW_SLOTS+104)
618 #define SID_SCATTR_CELLPROTECTION (SID_NEW_SLOTS+105)
619 #define SID_SELECT_UNPROTECTED_CELLS (SID_NEW_SLOTS+106)
620 #define SID_SELECT_VISIBLE_ROWS (SID_NEW_SLOTS+107)
621 #define SID_SELECT_VISIBLE_COLUMNS (SID_NEW_SLOTS+108)
622 #define SID_CURRENT_FORMULA_RANGE (SID_NEW_SLOTS+109)
624 #define SID_INSERT_SPARKLINE (SID_NEW_SLOTS+110)
625 #define SID_DELETE_SPARKLINE (SID_NEW_SLOTS+111)
626 #define SID_EDIT_SPARKLINE_GROUP (SID_NEW_SLOTS+112)
627 #define SID_DELETE_SPARKLINE_GROUP (SID_NEW_SLOTS+113)
628 #define SID_GROUP_SPARKLINES (SID_NEW_SLOTS+114)
629 #define SID_UNGROUP_SPARKLINES (SID_NEW_SLOTS+115)
630 #define SID_EDIT_SPARKLINE (SID_NEW_SLOTS+116)
631 #define SID_SC_OPT_LINKS TypedWhichId<SfxBoolItem>(SID_NEW_SLOTS + 117)
633 // idl parameter
635 #define SID_SORT_BYROW TypedWhichId<SfxBoolItem>(SC_PARAM_START)
636 #define SID_SORT_HASHEADER TypedWhichId<SfxBoolItem>(SC_PARAM_START+1)
637 #define SID_SORT_CASESENS TypedWhichId<SfxBoolItem>(SC_PARAM_START+2)
638 #define SID_SORT_ATTRIBS TypedWhichId<SfxBoolItem>(SC_PARAM_START+3)
639 #define SID_SORT_USERDEF TypedWhichId<SfxUInt16Item>(SC_PARAM_START+4)
640 #define SID_SORT_NATURALSORT TypedWhichId<SfxBoolItem>(SC_PARAM_START+5)
641 #define SID_SORT_INCCOMMENTS TypedWhichId<SfxBoolItem>(SC_PARAM_START+6)
642 #define SID_SORT_INCIMAGES TypedWhichId<SfxBoolItem>(SC_PARAM_START+7)
644 // Sidebar -------------------------------------------------------------
646 #define SID_PROPERTY_PANEL_CELLTEXT_DLG (SC_SIDEBAR_PROPERTY_BEGIN+0)
647 #define SID_NUMBER_TYPE_FORMAT TypedWhichId<SfxUInt16Item>(SC_SIDEBAR_PROPERTY_BEGIN+1)
649 // resources
651 #define SID_DATA_FORM (SC_RESOURCE_START+15) // menu (in Data menu)
652 #define SID_INSERT_CURRENT_DATE (SC_RESOURCE_START+16)
653 #define SID_INSERT_CURRENT_TIME (SC_RESOURCE_START+17)
654 #define FID_TAB_TOGGLE_GRID (SC_RESOURCE_START+18) // toggle sheet grid
655 #define WID_SIMPLE_REF (SC_RESOURCE_START+20)
657 #endif
659 /* vim:set shiftwidth=4 softtabstop=4 expandtab: */