sc/inc/sc.hrc

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