renumbered string ID defines consecutively to close gaps

... and shrink the resident array a little.
Also included the awk script that does this.

Change-Id: I47ab6d9d49d229dcffeef1a684f5c6fa836f91d0

2 files changed, 624 insertions, 569 deletions

diff --git a/sc/inc/globstr.hrc b/sc/inc/globstr.hrc
index 25a5a018cc00..f02ef5122b00 100644
--- a/sc/inc/globstr.hrc
+++ b/sc/inc/globstr.hrc
@@ -28,6 +28,12 @@
  * other string IDs of strings used in message boxes and elsewhere go into
  * sc/inc/sc.hrc if they need to be global, or if restricted to UI dialogs into
  * a proper sc/source/ui/xxx/yyy.hrc and corresponding .src PLEASE!
+ *
+ * When inserting or removing defines the entire file can be renumbered using
+ * sc/util/number-defines-consecutively.awk
+ * Hint: when inserting a define use some arbitrary large enough number such as
+ * 9999 and then renumber the file, which you HAVE TO then since otherwise the
+ * number would be greater than the count of resident strings.
  */
 
 #define STR_UNDO_DELETECELLS        1
@@ -69,626 +75,626 @@
 #define STR_UNDO_IMPORTDATA         37
 #define STR_UNDO_REPEATDB           38
 
-#define STR_MSSG_DOSUBTOTALS_0      40
-#define STR_MSSG_DOSUBTOTALS_1      41
-#define STR_MSSG_DOSUBTOTALS_2      42
-#define STR_MSSG_REPEATDB_0         43
-#define STR_MSSG_MAKEAUTOFILTER_0   44
-#define STR_MSSG_IMPORTDATA_0       45
-#define STR_MSSG_MAKEOUTLINE_0      46
-#define STR_MSSG_REMOVEOUTLINE_0    47
-#define STR_MSSG_PASTEFROMCLIP_0    48
-#define STR_MSSG_PASTEFROMCLIP_1    49
-#define STR_MSSG_MOVEBLOCKTO_0      50
-#define STR_MSSG_INSERTCELLS_0      52
-#define STR_MSSG_DELETECELLS_0      53
-#define STR_MSSG_MERGECELLS_0       54
-#define STR_MSSG_SEARCHANDREPLACE_0 55
-#define STR_MSSG_SOLVE_0            56
-#define STR_MSSG_SOLVE_1            57
-#define STR_MSSG_SOLVE_2            58
-#define STR_MSSG_SOLVE_3            59
-#define STR_MSSG_SOLVE_4            60
-
-#define STR_TABLE_GESAMTERGEBNIS    64
-#define STR_TABLE_ERGEBNIS          65
-#define STR_UNDO_SPELLING           66
-#define STR_TABLE_UND               67
-#define STR_TABLE_ODER              68
-#define STR_UNDO_INSERTCELLS        69
-#define STR_TABLE_DEF               70
-#define STR_MOVE_TO_END             72
-#define STR_BOX_YNI                 73
-#define STR_NO_REF_TABLE            74
-
-#define STR_PIVOTFUNC_SUM           75  // pivot.cxx
-#define STR_PIVOTFUNC_COUNT         76
-#define STR_PIVOTFUNC_AVG           77
-#define STR_PIVOTFUNC_MAX           78
-#define STR_PIVOTFUNC_MIN           79
-#define STR_PIVOTFUNC_PROD          80
-#define STR_PIVOTFUNC_COUNT2        90
-#define STR_PIVOTFUNC_STDDEV        91
-#define STR_PIVOTFUNC_STDDEV2       92
-#define STR_PIVOTFUNC_VAR           93
-#define STR_PIVOTFUNC_VAR2          94
-#define STR_PIVOT_TOTAL             95
-#define STR_PIVOT_DATA              96
-
-#define STR_PIVOT_INVALID_DBAREA    97 // tabvwsh3.cxx
-
-#define STR_TABLE                   98
-#define STR_COLUMN                  99
-#define STR_ROW                     100
-#define STR_LOAD_DOC                101
-#define STR_SAVE_DOC                102
-
-#define STR_ERR_INVALID_TABREF      103
-#define STR_AREA_ALREADY_INSERTED   104
-#define STR_INVALID_TABREF          105
-#define STR_INVALID_QUERYAREA       106
-
-#define STR_REIMPORT_EMPTY          107
-#define STR_NOMULTISELECT           108
-#define STR_FILL_SERIES_PROGRESS    109 // documen3.cxx
-
-#define STR_UNKNOWN_FILTER          110
-
-#define STR_DATABASE_NOTFOUND       111
-#define STR_DATABASE_ABORTED        112
-
-#define STR_UNDO_PRINTRANGES        113
-
-#define STR_UNDO_DEC_INDENT         114
-#define STR_UNDO_INC_INDENT         115
-#define STR_UNDO_THESAURUS          116
-
-#define STR_FILL_TAB                117
-#define STR_NO_VALUE                118     /* moved to compiler.src, keep define! */
-#define STR_UPDATE_SCENARIO         119
-#define STR_ERR_NEWSCENARIO         120
-#define STR_SCENARIO                121
-#define STR_PIVOT_TABLE             122
-#define STR_NEWTABNAMENOTUNIQUE     123
-
-#define STR_FUN_TEXT_SUM            124
-#define STR_FUN_TEXT_COUNT          125
-#define STR_FUN_TEXT_AVG            126
-#define STR_FUN_TEXT_MAX            127
-#define STR_FUN_TEXT_MIN            128
-#define STR_FUN_TEXT_PRODUCT        129
-#define STR_FUN_TEXT_STDDEV         130
-#define STR_FUN_TEXT_VAR            131
-#define STR_DOC_STAT                132
-
-#define STR_DBNAME_IMPORT           134
-
-#define STR_NOCHARTATCURSOR         135
-#define STR_NOAREASELECTED          136
-#define STR_INVALIDTABNAME          137
-
-#define STR_PIVOT_NOTFOUND          138
-#define STR_ERROR_STR               139
-#define STR_NV_STR                  140     /* moved to compiler.src, keep define! */
-#define STR_EMPTYDATA               141
-#define STR_PIVOT_NODATA            142
-#define STR_PIVOT_MOVENOTALLOWED    143
-
-#define STR_PRINT_INVALID_AREA      144
-
-#define STR_PAGESTYLE               145
-#define STR_HEADER                  146
-#define STR_FOOTER                  147
-
-#define STR_TEXTATTRS               148
-
-#define STR_HFCMD_DELIMITER         149
-#define STR_HFCMD_PAGE              150
-#define STR_HFCMD_PAGES             151
-#define STR_HFCMD_DATE              152
-#define STR_HFCMD_TIME              153
-#define STR_HFCMD_FILE              154
-#define STR_HFCMD_TABLE             155
-
-#define STR_PROTECTIONERR           156
-
-#define STR_PAGEHEADER              157
-#define STR_PAGEFOOTER              158
-#define STR_PAGE                    159
-#define STR_LONG_ERR_ILL_ARG        160
-#define STR_LONG_ERR_ILL_PAR        161
-#define STR_LONG_ERR_ILL_FPO        162
-#define STR_LONG_ERR_ILL_CHAR       163
-#define STR_LONG_ERR_ILL_SEP        164
-#define STR_LONG_ERR_PAIR           165
-#define STR_LONG_ERR_OP_EXP         166
-#define STR_LONG_ERR_VAR_EXP        167
-#define STR_LONG_ERR_CODE_OVF       168
-#define STR_LONG_ERR_STR_OVF        169
-#define STR_LONG_ERR_STACK_OVF      170
-#define STR_LONG_ERR_SYNTAX         171
-#define STR_LONG_ERR_CIRC_REF       172
-#define STR_LONG_ERR_NO_NAME        173
-#define STR_LONG_ERR_NO_REF         174
-#define STR_LONG_ERR_NO_CONV        175
-#define STR_LONG_ERR_NO_VALUE       176
-#define STR_LONG_ERR_NV             177
-
-#define STR_GRIDCOLOR               178
-#define STR_MERGE_NOTEMPTY          179
-#define STR_CELL_FILTER             180
-
-#define STR_TARGETNOTFOUND          181
-
-#define STR_INVALID_EPS             182
-#define STR_TABLE_OP                183     // documen4.cxx
-#define STR_UNDO_TABOP              184
-
-#define STR_INVALID_AFNAME          185
-
-#define STR_AREA                    186
-#define STR_YES                     187
-#define STR_NO                      188
-#define STR_PROTECTION              189
-#define STR_FORMULAS                190
-#define STR_HIDE                    191
-#define STR_PRINT                   192
-
-#define STR_INVALID_AFAREA          193
-
-#define STR_CASCADE                 194 // function auto pilot
-#define STR_OPTIONAL                195
-#define STR_REQUIRED                196
-#define STR_EDITFUNCTION            197
-#define STR_INVALID                 198
-
-#define STR_NOTES                   199
-#define STR_QUERY_DELTAB            200
-
-#define STR_UNDO_DETREFRESH         201
-
-#define STR_UNDO_SHOWNOTE           202
-#define STR_UNDO_HIDENOTE           203
-#define STR_UNDO_DRAGDROP           204
-
-#define STR_EXPORT_ASCII_WARNING    205
-#define STR_IMPORT_ERROR            206
-#define STR_IMPORT_ASCII            207
-#define STR_IMPORT_LOTUS            208
-#define STR_IMPORT_DBF              209
-#define STR_EXPORT_ASCII            210
-
-#define STR_STYLENAME_STANDARD      71
-#define STR_STYLENAME_RESULT        133
-#define STR_STYLENAME_RESULT1       211
-#define STR_STYLENAME_HEADLINE      212
-#define STR_STYLENAME_HEADLINE1     213
-#define STR_STYLENAME_REPORT        214
-#define STR_STYLENAME_REPORT1       215
-
-#define STR_PIVOT_ERROR             216
-#define STR_PIVOT_PROGRESS          217
-#define STR_IMPORT_EXCEL_WARNING    218
-#define STR_SPELLING_STOP_OK        219
-#define STR_THESAURUS_NO_STRING     220
-#define STR_SPELLING_BEGIN_TAB      221
-#define STR_SPELLING_NO_LANG        222                         // can be removed later
-
-#define STR_UNDO_GRAFEDIT           223
-
-#define STR_NOLANGERR               224
-
-#define STR_UNDO_INSERT_TAB         225
-#define STR_UNDO_DELETE_TAB         226
-#define STR_UNDO_RENAME_TAB         227
-#define STR_UNDO_MOVE_TAB           228
-#define STR_UNDO_COPY_TAB           229
-#define STR_UNDO_APPEND_TAB         230
-
-#define STR_CHART_MAINTITLE         231
-#define STR_CHART_SUBTITLE          232
-#define STR_CHART_XTITLE            233
-#define STR_CHART_YTITLE            234
-#define STR_CHART_ZTITLE            235
-
-#define STR_ABSREFLOST              236
-#define STR_NAMECONFLICT            237
-
-#define STR_ERR_AUTOFILTER          238
-#define STR_MSSG_SEARCHANDREPLACE_1 239
-#define STR_MSSG_SEARCHANDREPLACE_2 240
-#define STR_MSSG_SEARCHANDREPLACE_3 241
-
-#define STR_CREATENAME_REPLACE      242
-#define STR_CREATENAME_MARKERR      243
-
-#define STR_UNDO_LISTNAMES          244
-#define STR_UNDO_PIVOT_NEW          245
-#define STR_UNDO_PIVOT_MODIFY       246
-#define STR_UNDO_PIVOT_DELETE       247
-#define STR_UNDO_CONSOLIDATE        248
-#define STR_UNDO_USESCENARIO        249
-#define STR_UNDO_MAKESCENARIO       250
-
-#define STR_CONSOLIDATE_ERR1        251
-#define STR_SCENARIO_NOTFOUND       252
+#define STR_MSSG_DOSUBTOTALS_0      39
+#define STR_MSSG_DOSUBTOTALS_1      40
+#define STR_MSSG_DOSUBTOTALS_2      41
+#define STR_MSSG_REPEATDB_0         42
+#define STR_MSSG_MAKEAUTOFILTER_0   43
+#define STR_MSSG_IMPORTDATA_0       44
+#define STR_MSSG_MAKEOUTLINE_0      45
+#define STR_MSSG_REMOVEOUTLINE_0    46
+#define STR_MSSG_PASTEFROMCLIP_0    47
+#define STR_MSSG_PASTEFROMCLIP_1    48
+#define STR_MSSG_MOVEBLOCKTO_0      49
+#define STR_MSSG_INSERTCELLS_0      50
+#define STR_MSSG_DELETECELLS_0      51
+#define STR_MSSG_MERGECELLS_0       52
+#define STR_MSSG_SEARCHANDREPLACE_0 53
+#define STR_MSSG_SOLVE_0            54
+#define STR_MSSG_SOLVE_1            55
+#define STR_MSSG_SOLVE_2            56
+#define STR_MSSG_SOLVE_3            57
+#define STR_MSSG_SOLVE_4            58
+
+#define STR_TABLE_GESAMTERGEBNIS    59
+#define STR_TABLE_ERGEBNIS          60
+#define STR_UNDO_SPELLING           61
+#define STR_TABLE_UND               62
+#define STR_TABLE_ODER              63
+#define STR_UNDO_INSERTCELLS        64
+#define STR_TABLE_DEF               65
+#define STR_MOVE_TO_END             66
+#define STR_BOX_YNI                 67
+#define STR_NO_REF_TABLE            68
+
+#define STR_PIVOTFUNC_SUM           69  // pivot.cxx
+#define STR_PIVOTFUNC_COUNT         70
+#define STR_PIVOTFUNC_AVG           71
+#define STR_PIVOTFUNC_MAX           72
+#define STR_PIVOTFUNC_MIN           73
+#define STR_PIVOTFUNC_PROD          74
+#define STR_PIVOTFUNC_COUNT2        75
+#define STR_PIVOTFUNC_STDDEV        76
+#define STR_PIVOTFUNC_STDDEV2       77
+#define STR_PIVOTFUNC_VAR           78
+#define STR_PIVOTFUNC_VAR2          79
+#define STR_PIVOT_TOTAL             80
+#define STR_PIVOT_DATA              81
+
+#define STR_PIVOT_INVALID_DBAREA    82 // tabvwsh3.cxx
+
+#define STR_TABLE                   83
+#define STR_COLUMN                  84
+#define STR_ROW                     85
+#define STR_LOAD_DOC                86
+#define STR_SAVE_DOC                87
+
+#define STR_ERR_INVALID_TABREF      88
+#define STR_AREA_ALREADY_INSERTED   89
+#define STR_INVALID_TABREF          90
+#define STR_INVALID_QUERYAREA       91
+
+#define STR_REIMPORT_EMPTY          92
+#define STR_NOMULTISELECT           93
+#define STR_FILL_SERIES_PROGRESS    94 // documen3.cxx
+
+#define STR_UNKNOWN_FILTER          95
+
+#define STR_DATABASE_NOTFOUND       96
+#define STR_DATABASE_ABORTED        97
+
+#define STR_UNDO_PRINTRANGES        98
+
+#define STR_UNDO_DEC_INDENT         99
+#define STR_UNDO_INC_INDENT         100
+#define STR_UNDO_THESAURUS          101
+
+#define STR_FILL_TAB                102
+#define STR_NO_VALUE                103     /* moved to compiler.src, keep define! */
+#define STR_UPDATE_SCENARIO         104
+#define STR_ERR_NEWSCENARIO         105
+#define STR_SCENARIO                106
+#define STR_PIVOT_TABLE             107
+#define STR_NEWTABNAMENOTUNIQUE     108
+
+#define STR_FUN_TEXT_SUM            109
+#define STR_FUN_TEXT_COUNT          110
+#define STR_FUN_TEXT_AVG            111
+#define STR_FUN_TEXT_MAX            112
+#define STR_FUN_TEXT_MIN            113
+#define STR_FUN_TEXT_PRODUCT        114
+#define STR_FUN_TEXT_STDDEV         115
+#define STR_FUN_TEXT_VAR            116
+#define STR_DOC_STAT                117
+
+#define STR_DBNAME_IMPORT           118
+
+#define STR_NOCHARTATCURSOR         119
+#define STR_NOAREASELECTED          120
+#define STR_INVALIDTABNAME          121
+
+#define STR_PIVOT_NOTFOUND          122
+#define STR_ERROR_STR               123
+#define STR_NV_STR                  124     /* moved to compiler.src, keep define! */
+#define STR_EMPTYDATA               125
+#define STR_PIVOT_NODATA            126
+#define STR_PIVOT_MOVENOTALLOWED    127
+
+#define STR_PRINT_INVALID_AREA      128
+
+#define STR_PAGESTYLE               129
+#define STR_HEADER                  130
+#define STR_FOOTER                  131
+
+#define STR_TEXTATTRS               132
+
+#define STR_HFCMD_DELIMITER         133
+#define STR_HFCMD_PAGE              134
+#define STR_HFCMD_PAGES             135
+#define STR_HFCMD_DATE              136
+#define STR_HFCMD_TIME              137
+#define STR_HFCMD_FILE              138
+#define STR_HFCMD_TABLE             139
+
+#define STR_PROTECTIONERR           140
+
+#define STR_PAGEHEADER              141
+#define STR_PAGEFOOTER              142
+#define STR_PAGE                    143
+#define STR_LONG_ERR_ILL_ARG        144
+#define STR_LONG_ERR_ILL_PAR        145
+#define STR_LONG_ERR_ILL_FPO        146
+#define STR_LONG_ERR_ILL_CHAR       147
+#define STR_LONG_ERR_ILL_SEP        148
+#define STR_LONG_ERR_PAIR           149
+#define STR_LONG_ERR_OP_EXP         150
+#define STR_LONG_ERR_VAR_EXP        151
+#define STR_LONG_ERR_CODE_OVF       152
+#define STR_LONG_ERR_STR_OVF        153
+#define STR_LONG_ERR_STACK_OVF      154
+#define STR_LONG_ERR_SYNTAX         155
+#define STR_LONG_ERR_CIRC_REF       156
+#define STR_LONG_ERR_NO_NAME        157
+#define STR_LONG_ERR_NO_REF         158
+#define STR_LONG_ERR_NO_CONV        159
+#define STR_LONG_ERR_NO_VALUE       160
+#define STR_LONG_ERR_NV             161
+
+#define STR_GRIDCOLOR               162
+#define STR_MERGE_NOTEMPTY          163
+#define STR_CELL_FILTER             164
+
+#define STR_TARGETNOTFOUND          165
+
+#define STR_INVALID_EPS             166
+#define STR_TABLE_OP                167     // documen4.cxx
+#define STR_UNDO_TABOP              168
+
+#define STR_INVALID_AFNAME          169
+
+#define STR_AREA                    170
+#define STR_YES                     171
+#define STR_NO                      172
+#define STR_PROTECTION              173
+#define STR_FORMULAS                174
+#define STR_HIDE                    175
+#define STR_PRINT                   176
+
+#define STR_INVALID_AFAREA          177
+
+#define STR_CASCADE                 178 // function auto pilot
+#define STR_OPTIONAL                179
+#define STR_REQUIRED                180
+#define STR_EDITFUNCTION            181
+#define STR_INVALID                 182
+
+#define STR_NOTES                   183
+#define STR_QUERY_DELTAB            184
+
+#define STR_UNDO_DETREFRESH         185
+
+#define STR_UNDO_SHOWNOTE           186
+#define STR_UNDO_HIDENOTE           187
+#define STR_UNDO_DRAGDROP           188
+
+#define STR_EXPORT_ASCII_WARNING    189
+#define STR_IMPORT_ERROR            190
+#define STR_IMPORT_ASCII            191
+#define STR_IMPORT_LOTUS            192
+#define STR_IMPORT_DBF              193
+#define STR_EXPORT_ASCII            194
+
+#define STR_STYLENAME_STANDARD      195
+#define STR_STYLENAME_RESULT        196
+#define STR_STYLENAME_RESULT1       197
+#define STR_STYLENAME_HEADLINE      198
+#define STR_STYLENAME_HEADLINE1     199
+#define STR_STYLENAME_REPORT        200
+#define STR_STYLENAME_REPORT1       201
+
+#define STR_PIVOT_ERROR             202
+#define STR_PIVOT_PROGRESS          203
+#define STR_IMPORT_EXCEL_WARNING    204
+#define STR_SPELLING_STOP_OK        205
+#define STR_THESAURUS_NO_STRING     206
+#define STR_SPELLING_BEGIN_TAB      207
+#define STR_SPELLING_NO_LANG        208                         // can be removed later
+
+#define STR_UNDO_GRAFEDIT           209
+
+#define STR_NOLANGERR               210
+
+#define STR_UNDO_INSERT_TAB         211
+#define STR_UNDO_DELETE_TAB         212
+#define STR_UNDO_RENAME_TAB         213
+#define STR_UNDO_MOVE_TAB           214
+#define STR_UNDO_COPY_TAB           215
+#define STR_UNDO_APPEND_TAB         216
+
+#define STR_CHART_MAINTITLE         217
+#define STR_CHART_SUBTITLE          218
+#define STR_CHART_XTITLE            219
+#define STR_CHART_YTITLE            220
+#define STR_CHART_ZTITLE            221
+
+#define STR_ABSREFLOST              222
+#define STR_NAMECONFLICT            223
+
+#define STR_ERR_AUTOFILTER          224
+#define STR_MSSG_SEARCHANDREPLACE_1 225
+#define STR_MSSG_SEARCHANDREPLACE_2 226
+#define STR_MSSG_SEARCHANDREPLACE_3 227
+
+#define STR_CREATENAME_REPLACE      228
+#define STR_CREATENAME_MARKERR      229
+
+#define STR_UNDO_LISTNAMES          230
+#define STR_UNDO_PIVOT_NEW          231
+#define STR_UNDO_PIVOT_MODIFY       232
+#define STR_UNDO_PIVOT_DELETE       233
+#define STR_UNDO_CONSOLIDATE        234
+#define STR_UNDO_USESCENARIO        235
+#define STR_UNDO_MAKESCENARIO       236
+
+#define STR_CONSOLIDATE_ERR1        237
+#define STR_SCENARIO_NOTFOUND       238
 
-#define STR_UNDO_APPLYCELLSTYLE     253
-
-#define STR_UNDO_DETADDPRED         254
-#define STR_UNDO_DETDELPRED         255
-#define STR_UNDO_DETADDSUCC         256
-#define STR_UNDO_DETDELSUCC         257
-#define STR_UNDO_DETADDERROR        258
-#define STR_UNDO_DETDELALL          259
-
-#define STR_QUERY_DELENTRY          260
-
-#define STR_VOBJ_OBJECT             261
-#define STR_VOBJ_CHART              262
-#define STR_VOBJ_DRAWINGS           263
-#define STR_VOBJ_MODE_SHOW          264
-#define STR_VOBJ_MODE_HIDE          265
-
-#define STR_SCATTR_PAGE_TOPDOWN     267
-#define STR_SCATTR_PAGE_LEFTRIGHT   268
-#define STR_SCATTR_PAGE_NOTES       269
-#define STR_SCATTR_PAGE_GRID        270
-#define STR_SCATTR_PAGE_HEADERS     271
-#define STR_SCATTR_PAGE_FORMULAS    272
-#define STR_SCATTR_PAGE_NULLVALS    273
-#define STR_SCATTR_PAGE_PRINTDIR    274
-#define STR_SCATTR_PAGE_FIRSTPAGENO 275
-#define STR_SCATTR_PAGE_SCALE       276
-#define STR_SCATTR_PAGE_SCALETOPAGES 277
+#define STR_UNDO_APPLYCELLSTYLE     239
+
+#define STR_UNDO_DETADDPRED         240
+#define STR_UNDO_DETDELPRED         241
+#define STR_UNDO_DETADDSUCC         242
+#define STR_UNDO_DETDELSUCC         243
+#define STR_UNDO_DETADDERROR        244
+#define STR_UNDO_DETDELALL          245
+
+#define STR_QUERY_DELENTRY          246
+
+#define STR_VOBJ_OBJECT             247
+#define STR_VOBJ_CHART              248
+#define STR_VOBJ_DRAWINGS           249
+#define STR_VOBJ_MODE_SHOW          250
+#define STR_VOBJ_MODE_HIDE          251
+
+#define STR_SCATTR_PAGE_TOPDOWN     252
+#define STR_SCATTR_PAGE_LEFTRIGHT   253
+#define STR_SCATTR_PAGE_NOTES       254
+#define STR_SCATTR_PAGE_GRID        255
+#define STR_SCATTR_PAGE_HEADERS     256
+#define STR_SCATTR_PAGE_FORMULAS    257
+#define STR_SCATTR_PAGE_NULLVALS    258
+#define STR_SCATTR_PAGE_PRINTDIR    259
+#define STR_SCATTR_PAGE_FIRSTPAGENO 260
+#define STR_SCATTR_PAGE_SCALE       261
+#define STR_SCATTR_PAGE_SCALETOPAGES 262
 
-#define STR_NOREF_STR               278     /* moved to compiler.src, keep define! */
+#define STR_NOREF_STR               263     /* moved to compiler.src, keep define! */
 
-#define STR_UNDO_CHARTDATA          280
-#define STR_UNDO_ORIGINALSIZE       281
+#define STR_UNDO_CHARTDATA          264
+#define STR_UNDO_ORIGINALSIZE       265
 
-#define STR_LINKERROR               282
-#define STR_LINKERRORFILE           283
-#define STR_LINKERRORTAB            284
-#define STR_UNDO_UPDATELINK         285
+#define STR_LINKERROR               266
+#define STR_LINKERRORFILE           267
+#define STR_LINKERRORTAB            268
+#define STR_UNDO_UPDATELINK         269
 
-#define STR_IMPORT_REPLACE          286
+#define STR_IMPORT_REPLACE          270
 
-#define STR_UNDO_REMOVELINK         287
+#define STR_UNDO_REMOVELINK         271
 
-#define STR_OVERVIEW                288
-#define STR_DOC_INFO                289
-#define STR_DOC_CREATED             290
-#define STR_DOC_MODIFIED            291
-#define STR_DOC_PRINTED             292
-#define STR_DOC_THEME               293
-#define STR_DOC_KEYWORDS            318
-#define STR_DOC_COMMENT             294
-#define STR_BY                      295
-#define STR_ON                      296
+#define STR_OVERVIEW                272
+#define STR_DOC_INFO                273
+#define STR_DOC_CREATED             274
+#define STR_DOC_MODIFIED            275
+#define STR_DOC_PRINTED             276
+#define STR_DOC_THEME               277
+#define STR_DOC_KEYWORDS            278
+#define STR_DOC_COMMENT             279
+#define STR_BY                      280
+#define STR_ON                      281
 
-#define STR_RELOAD_TABLES           297
+#define STR_RELOAD_TABLES           282
 
-#define STR_FILTER_TOOMANY          298
+#define STR_FILTER_TOOMANY          283
 
-#define STR_UNDO_ENTERMATRIX        299
+#define STR_UNDO_ENTERMATRIX        284
 
-#define STR_INSERT_FULL             300
-#define STR_TABINSERT_ERROR         301
-#define STR_PASTE_ERROR             302
-#define STR_PASTE_FULL              303
+#define STR_INSERT_FULL             285
+#define STR_TABINSERT_ERROR         286
+#define STR_PASTE_ERROR             287
+#define STR_PASTE_FULL              288
 
-#define STR_ERR_INVALID_AREA        304
+#define STR_ERR_INVALID_AREA        289
 
-#define STR_IMPORT_DIF              305
-#define STR_EXPORT_DIF              306
+#define STR_IMPORT_DIF              290
+#define STR_EXPORT_DIF              291
 
-#define STR_ERR_NOREF               307
-#define STR_FUN_TEXT_COUNT2         308
-#define STR_NO_NAME_REF             309     /* moved to compiler.src, keep define! */
+#define STR_ERR_NOREF               292
+#define STR_FUN_TEXT_COUNT2         293
+#define STR_NO_NAME_REF             294     /* moved to compiler.src, keep define! */
 
-#define STR_MATRIXFRAGMENTERR       310
+#define STR_MATRIXFRAGMENTERR       295
 
-#define STR_UNDO_SHOWTAB            311
-#define STR_UNDO_HIDETAB            312
-#define STR_UNDO_INSERTAREALINK     313
+#define STR_UNDO_SHOWTAB            296
+#define STR_UNDO_HIDETAB            297
+#define STR_UNDO_INSERTAREALINK     298
 
-#define STR_REIMPORT_AFTER_LOAD     314
+#define STR_REIMPORT_AFTER_LOAD     299
 
-#define STR_DETINVALID_OVERFLOW     315
-#define STR_GRAPHICNAME             316
-#define STR_INVALIDNAME             317
-#define STR_ERR_LINKOVERLAP         319
+#define STR_DETINVALID_OVERFLOW     300
+#define STR_GRAPHICNAME             301
+#define STR_INVALIDNAME             302
+#define STR_ERR_LINKOVERLAP         303
 
-#define STR_VALID_MACRONOTFOUND     320
-#define STR_VALID_DEFERROR          321
+#define STR_VALID_MACRONOTFOUND     304
+#define STR_VALID_DEFERROR          305
 
-#define STR_UNDO_DETINVALID         322
+#define STR_UNDO_DETINVALID         306
 
-#define STR_PROGRESS_CALCULATING    323
-#define STR_PROGRESS_SORTING        324
-#define STR_PROGRESS_HEIGHTING      325
+#define STR_PROGRESS_CALCULATING    307
+#define STR_PROGRESS_SORTING        308
+#define STR_PROGRESS_HEIGHTING      309
 
-#define STR_QUICKHELP_DELETE        326
+#define STR_QUICKHELP_DELETE        310
 
-#define STR_FUNCTIONLIST_MORE       327
+#define STR_FUNCTIONLIST_MORE       311
 
-#define STR_PIVOT_STYLE_INNER       328
-#define STR_PIVOT_STYLE_RESULT      329
-#define STR_PIVOT_STYLE_CATEGORY    330
-#define STR_PIVOT_STYLE_TITLE       331
-#define STR_PIVOT_STYLE_FIELDNAME   332
-#define STR_PIVOT_STYLE_TOP         333
+#define STR_PIVOT_STYLE_INNER       312
+#define STR_PIVOT_STYLE_RESULT      313
+#define STR_PIVOT_STYLE_CATEGORY    314
+#define STR_PIVOT_STYLE_TITLE       315
+#define STR_PIVOT_STYLE_FIELDNAME   316
+#define STR_PIVOT_STYLE_TOP         317
 
-#define STR_OPERATION_FILTER        334
-#define STR_OPERATION_SORT          335
-#define STR_OPERATION_SUBTOTAL      336
-#define STR_OPERATION_NONE          337
+#define STR_OPERATION_FILTER        318
+#define STR_OPERATION_SORT          319
+#define STR_OPERATION_SUBTOTAL      320
+#define STR_OPERATION_NONE          321
 
-#define STR_UNDO_PROTECT_TAB        338
-#define STR_UNDO_UNPROTECT_TAB      339
-#define STR_UNDO_PROTECT_DOC        340
-#define STR_UNDO_UNPROTECT_DOC      341
+#define STR_UNDO_PROTECT_TAB        322
+#define STR_UNDO_UNPROTECT_TAB      323
+#define STR_UNDO_PROTECT_DOC        324
+#define STR_UNDO_UNPROTECT_DOC      325
 
-#define STR_PROGRESS_IMPORT         342
+#define STR_PROGRESS_IMPORT         326
 
-#define STR_SORT_ERR_MERGED         343
+#define STR_SORT_ERR_MERGED         327
 
-#define STR_TIP_WIDTH               344
-#define STR_TIP_HEIGHT              345
-#define STR_TIP_HIDE                346
+#define STR_TIP_WIDTH               328
+#define STR_TIP_HEIGHT              329
+#define STR_TIP_HIDE                330
 
-#define STR_UNDO_REMOVEBREAKS       347
-#define STR_UNDO_PRINTSCALE         348
-#define STR_UNDO_DRAG_BREAK         349
+#define STR_UNDO_REMOVEBREAKS       331
+#define STR_UNDO_PRINTSCALE         332
+#define STR_UNDO_DRAG_BREAK         333
 
-#define STR_QUICKHELP_REF           350
+#define STR_QUICKHELP_REF           334
 
-#define STR_PIVOT_OVERLAP           351
-#define STR_PIVOT_NOTEMPTY          352
+#define STR_PIVOT_OVERLAP           335
+#define STR_PIVOT_NOTEMPTY          336
 
-#define STR_QUERY_NOTFOUND          353
+#define STR_QUERY_NOTFOUND          337
 
-#define STR_ERR_INSERTOBJ           354
+#define STR_ERR_INSERTOBJ           338
 
-#define STR_PROGRESS_COMPARING      355
+#define STR_PROGRESS_COMPARING      339
 
-#define STR_CHANGED_BLANK           356
-#define STR_CHANGED_CELL            357
-#define STR_CHANGED_INSERT          358
-#define STR_CHANGED_DELETE          359
-#define STR_CHANGED_MOVE            360
+#define STR_CHANGED_BLANK           340
+#define STR_CHANGED_CELL            341
+#define STR_CHANGED_INSERT          342
+#define STR_CHANGED_DELETE          343
+#define STR_CHANGED_MOVE            344
 
-#define STR_QUERY_DELSCENARIO       361
-#define STR_UNDO_EDITSCENARIO       362
+#define STR_QUERY_DELSCENARIO       345
+#define STR_UNDO_EDITSCENARIO       346
 
-#define STR_END_REDLINING_TITLE     363
-#define STR_END_REDLINING           364
+#define STR_END_REDLINING_TITLE     347
+#define STR_END_REDLINING           348
 
-#define STR_UNDO_EDITNOTE           365
-#define STR_TABREMOVE_ERROR         366
-#define STR_CLOSE_ERROR_LINK        367
-#define STR_UNDO_RANGENAMES         368
+#define STR_UNDO_EDITNOTE           349
+#define STR_TABREMOVE_ERROR         350
+#define STR_CLOSE_ERROR_LINK        351
+#define STR_UNDO_RANGENAMES         352
 
-#define STR_MSSG_SEARCHANDREPLACE_4 369
-#define STR_MSSG_SEARCHANDREPLACE_5 370
+#define STR_MSSG_SEARCHANDREPLACE_4 353
+#define STR_MSSG_SEARCHANDREPLACE_5 354
 
-#define STR_UNDO_RESIZEMATRIX       371
-#define STR_TIP_RESIZEMATRIX        372
+#define STR_UNDO_RESIZEMATRIX       355
+#define STR_TIP_RESIZEMATRIX        356
 
-#define STR_READONLYERR             373
+#define STR_READONLYERR             357
 
-#define STR_PASTE_BIGGER            374
+#define STR_PASTE_BIGGER            358
 
-#define STR_MACRO_WARNING           375
+#define STR_MACRO_WARNING           359
 
-#define STR_EXPORT_DBF              376
+#define STR_EXPORT_DBF              360
 
-#define STR_UNDO_APPLYPAGESTYLE     377
-#define STR_UNDO_EDITCELLSTYLE      378
-#define STR_UNDO_EDITPAGESTYLE      379
+#define STR_UNDO_APPLYPAGESTYLE     361
+#define STR_UNDO_EDITCELLSTYLE      362
+#define STR_UNDO_EDITPAGESTYLE      363
 
-#define STR_DATAPILOT_SUBTOTAL      380
+#define STR_DATAPILOT_SUBTOTAL      364
 
-#define STR_UNDO_TRANSLITERATE      381
+#define STR_UNDO_TRANSLITERATE      365
 
-#define STR_NO_ADDIN                382
-#define STR_LONG_ERR_NO_ADDIN       383
-#define STR_NO_MACRO                384
-#define STR_LONG_ERR_NO_MACRO       385
+#define STR_NO_ADDIN                366
+#define STR_LONG_ERR_NO_ADDIN       367
+#define STR_NO_MACRO                368
+#define STR_LONG_ERR_NO_MACRO       369
 
-#define STR_SCATTR_PAGE_SCALETO         386
-#define STR_SCATTR_PAGE_SCALE_WIDTH     387
-#define STR_SCATTR_PAGE_SCALE_HEIGHT    388
-#define STR_SCATTR_PAGE_SCALE_PAGES     389
-#define STR_SCATTR_PAGE_SCALE_AUTO      390
+#define STR_SCATTR_PAGE_SCALETO         370
+#define STR_SCATTR_PAGE_SCALE_WIDTH     371
+#define STR_SCATTR_PAGE_SCALE_HEIGHT    372
+#define STR_SCATTR_PAGE_SCALE_PAGES     373
+#define STR_SCATTR_PAGE_SCALE_AUTO      374
 
-#define STR_UNDO_TAB_RTL                        391
-#define STR_UNDO_HANGULHANJA            392
-#define STR_UNDO_CHINESE_TRANSLATION    393
-
-#define STR_NAME_INPUT_CELL         394
-#define STR_NAME_INPUT_RANGE        395
-#define STR_NAME_INPUT_DBRANGE      396
-#define STR_NAME_INPUT_ROW          397
-#define STR_NAME_INPUT_SHEET        398
-#define STR_NAME_INPUT_DEFINE       399
-#define STR_NAME_ERROR_SELECTION    400
-#define STR_NAME_ERROR_NAME         401
-
-#define STR_CHANGED_MOVE_REJECTION_WARNING      402
-#define STR_CHANGED_DELETE_REJECTION_WARNING    403
-
-#define STR_ERR_DATAPILOT_INPUT     411
-
-#define STR_DIV_ZERO                412     /* moved to compiler.src, keep define! */
-#define STR_LONG_ERR_DIV_ZERO       413
-#define STR_NUM_ERROR               414     /* moved to compiler.src, keep define! */
-#define STR_NULL_ERROR              415     /* moved to compiler.src, keep define! */
-
-#define STR_RECALC_MANUAL           416
-#define STR_RECALC_AUTO             417
-
-#define STR_UNDO_TAB_R1C1           418
-
-#define STR_ERR_LONG_NESTED_ARRAY   419
-#define STR_UNDO_TEXTTOCOLUMNS      420
-
-#define STR_DOC_UPDATED             421
-#define STR_DOC_WILLBESAVED         422
-#define STR_DOC_WILLNOTBESAVED      423
-#define STR_DOC_DISABLESHARED       424
-#define STR_DOC_NOLONGERSHARED      425
-#define STR_SHARED_DOC_WARNING      426
-#define STR_FILE_LOCKED_TRY_LATER   427
-#define STR_FILE_LOCKED_SAVE_LATER  428
-#define STR_UNKNOWN_USER            429
-#define STR_LONG_ERR_NULL           430
-
-#define STR_UNDO_INSERTNOTE         431
-#define STR_UNDO_DELETENOTE         432
-#define STR_STYLE_FAMILY_CELL       433
-#define STR_STYLE_FAMILY_PAGE       434
-
-#define STR_ERR_DATAPILOTSOURCE     435
-#define STR_PIVOT_FIRSTROWEMPTYERR  436
-#define STR_PIVOT_ONLYONEROWERR     437
-
-#define STR_UNDO_SET_TAB_BG_COLOR       438
-#define STR_UNDO_SET_MULTI_TAB_BG_COLOR 439
-#define STR_UNDO_INSERT_CURRENT_DATE    440
-#define STR_UNDO_INSERT_CURRENT_TIME    441
-
-#define STR_OPTIONS_WARN_SEPARATORS     442
-#define STR_SHAPE_AUTOSHAPE         443
-#define STR_SHAPE_RECTANGLE         444
-#define STR_SHAPE_LINE              445
-#define STR_SHAPE_OVAL              446
-#define STR_SHAPE_TEXTBOX           447
-
-#define STR_FORM_BUTTON             448
-#define STR_FORM_CHECKBOX           449
-#define STR_FORM_OPTIONBUTTON       450
-#define STR_FORM_LABEL              451
-#define STR_FORM_LISTBOX            452
-#define STR_FORM_GROUPBOX           453
-#define STR_FORM_DROPDOWN           454
-#define STR_FORM_SPINNER            455
-#define STR_FORM_SCROLLBAR          456
-
-#define STR_PGNUM                   457
-
-#define STR_MANAGE_NAMES            458
-
-#define STR_HEADER_NAME             459
-#define STR_HEADER_RANGE            460
-#define STR_HEADER_SCOPE            461
-#define STR_GLOBAL_SCOPE            462
-#define STR_ERR_NAME_EXISTS         463
-#define STR_ERR_NAME_INVALID        464
-
-#define STR_UNSAVED_EXT_REF         465
-#define STR_CLOSE_WITH_UNSAVED_REFS 466
-#define STR_PIVOT_GROUP             467
-#define STR_HEADER_COND             468
-
-#define STR_COND_CONDITION          469
-#define STR_COND_COLORSCALE         470
-#define STR_COND_DATABAR            471
-#define STR_COND_ICONSET            472
-#define STR_COND_FORMULA            473
-#define STR_COND_BETWEEN            474
-#define STR_COND_NOTBETWEEN         475
-#define STR_COND_UNIQUE             476
-#define STR_COND_DUPLICATE          477
-#define STR_COND_TOP10              478
-#define STR_COND_BOTTOM10           479
-#define STR_COND_TOP_PERCENT        480
-#define STR_COND_BOTTOM_PERCENT     481
-#define STR_COND_ABOVE_AVERAGE      482
-#define STR_COND_BELOW_AVERAGE      483
-#define STR_COND_ERROR              484
-#define STR_COND_NOERROR            485
-#define STR_COND_BEGINS_WITH        486
-#define STR_COND_ENDS_WITH          487
-#define STR_COND_CONTAINS           488
-#define STR_COND_NOT_CONTAINS       489
-#define STR_COND_DATE               490
-#define STR_COND_TODAY              491
-#define STR_COND_YESTERDAY          492
-#define STR_COND_TOMORROW           493
-#define STR_COND_LAST7DAYS          494
-#define STR_COND_THISWEEK           495
-#define STR_COND_LASTWEEK           496
-#define STR_COND_NEXTWEEK           497
-#define STR_COND_THISMONTH          498
-#define STR_COND_LASTMONTH          499
-#define STR_COND_NEXTMONTH          500
-#define STR_COND_THISYEAR           501
-#define STR_COND_LASTYEAR           502
-#define STR_COND_NEXTYEAR           503
-
-#define STR_ERR_CONDFORMAT_PROTECTED 504
-#define STR_EDIT_EXISTING_COND_FORMATS 505
-
-#define STR_QUERY_FORMULA_RECALC_ONLOAD_ODS 506
-#define STR_QUERY_FORMULA_RECALC_ONLOAD_XLS 507
-#define STR_ALWAYS_PERFORM_SELECTED 508
-
-#define STR_NO_INSERT_DELETE_OVER_PIVOT_TABLE 509
-
-#define STR_CHG_INSERT_COLS         510
-#define STR_CHG_INSERT_ROWS         511
-#define STR_CHG_INSERT_TABS         512
-#define STR_CHG_DELETE_COLS         513
-#define STR_CHG_DELETE_ROWS         514
-#define STR_CHG_DELETE_TABS         515
-#define STR_CHG_MOVE                516
-#define STR_CHG_CONTENT             517
-#define STR_CHG_REJECT              518
-#define STR_CHG_ACCEPTED            519
-#define STR_CHG_REJECTED            520
-#define STR_CHG_NO_ENTRY            521
-#define STR_CHG_CONTENT_WITH_CHILD  522
-#define STR_CHG_CHILD_CONTENT       523
-#define STR_CHG_CHILD_ORGCONTENT    524
-#define STR_CHG_EMPTY               525
-
-#define STR_UNDO_HIDETABS           526
-#define STR_UNDO_SHOWTABS           527
-
-#define STR_DPFIELD_GROUP_BY_SECONDS     528
-#define STR_DPFIELD_GROUP_BY_MINUTES     529
-#define STR_DPFIELD_GROUP_BY_HOURS       530
-#define STR_DPFIELD_GROUP_BY_DAYS        531
-#define STR_DPFIELD_GROUP_BY_MONTHS      532
-#define STR_DPFIELD_GROUP_BY_QUARTERS    533
-#define STR_DPFIELD_GROUP_BY_YEARS       534
-
-#define STR_COND_ABOVE_EQUAL_AVERAGE 535
-#define STR_COND_BELOW_EQUAL_AVERAGE 536
-
-#define STR_MULTI_SELECT            537
-
-#define STR_INVALIDVAL              538
-#define STR_INVALIDVAR              539
-#define STR_INVALIDFORM             540
-#define STR_NOFORMULA               541
-
-#define STR_INVALIDINPUT            542
-#define STR_INVALIDCONDITION        543
-
-#define STR_FUN_TEXT_SELECTION_COUNT    546
-
-#define STR_QUERYREMOVE             547
-#define STR_COPYLIST                548
-#define STR_COPYFROM                549
-#define STR_COPYERR                 550
-
-#define STR_CTRLCLICKHYPERLINK      551
-#define STR_CLICKHYPERLINK          552
-
-#define SC_GLOBSTR_STR_COUNT        553     /**< the count of permanently resident strings */
+#define STR_UNDO_TAB_RTL                375
+#define STR_UNDO_HANGULHANJA            376
+#define STR_UNDO_CHINESE_TRANSLATION    377
+
+#define STR_NAME_INPUT_CELL         378
+#define STR_NAME_INPUT_RANGE        379
+#define STR_NAME_INPUT_DBRANGE      380
+#define STR_NAME_INPUT_ROW          381
+#define STR_NAME_INPUT_SHEET        382
+#define STR_NAME_INPUT_DEFINE       383
+#define STR_NAME_ERROR_SELECTION    384
+#define STR_NAME_ERROR_NAME         385
+
+#define STR_CHANGED_MOVE_REJECTION_WARNING      386
+#define STR_CHANGED_DELETE_REJECTION_WARNING    387
+
+#define STR_ERR_DATAPILOT_INPUT     388
+
+#define STR_DIV_ZERO                389     /* moved to compiler.src, keep define! */
+#define STR_LONG_ERR_DIV_ZERO       390
+#define STR_NUM_ERROR               391     /* moved to compiler.src, keep define! */
+#define STR_NULL_ERROR              392     /* moved to compiler.src, keep define! */
+
+#define STR_RECALC_MANUAL           393
+#define STR_RECALC_AUTO             394
+
+#define STR_UNDO_TAB_R1C1           395
+
+#define STR_ERR_LONG_NESTED_ARRAY   396
+#define STR_UNDO_TEXTTOCOLUMNS      397
+
+#define STR_DOC_UPDATED             398
+#define STR_DOC_WILLBESAVED         399
+#define STR_DOC_WILLNOTBESAVED      400
+#define STR_DOC_DISABLESHARED       401
+#define STR_DOC_NOLONGERSHARED      402
+#define STR_SHARED_DOC_WARNING      403
+#define STR_FILE_LOCKED_TRY_LATER   404
+#define STR_FILE_LOCKED_SAVE_LATER  405
+#define STR_UNKNOWN_USER            406
+#define STR_LONG_ERR_NULL           407
+
+#define STR_UNDO_INSERTNOTE         408
+#define STR_UNDO_DELETENOTE         409
+#define STR_STYLE_FAMILY_CELL       410
+#define STR_STYLE_FAMILY_PAGE       411
+
+#define STR_ERR_DATAPILOTSOURCE     412
+#define STR_PIVOT_FIRSTROWEMPTYERR  413
+#define STR_PIVOT_ONLYONEROWERR     414
+
+#define STR_UNDO_SET_TAB_BG_COLOR       415
+#define STR_UNDO_SET_MULTI_TAB_BG_COLOR 416
+#define STR_UNDO_INSERT_CURRENT_DATE    417
+#define STR_UNDO_INSERT_CURRENT_TIME    418
+
+#define STR_OPTIONS_WARN_SEPARATORS 419
+#define STR_SHAPE_AUTOSHAPE         420
+#define STR_SHAPE_RECTANGLE         421
+#define STR_SHAPE_LINE              422
+#define STR_SHAPE_OVAL              423
+#define STR_SHAPE_TEXTBOX           424
+
+#define STR_FORM_BUTTON             425
+#define STR_FORM_CHECKBOX           426
+#define STR_FORM_OPTIONBUTTON       427
+#define STR_FORM_LABEL              428
+#define STR_FORM_LISTBOX            429
+#define STR_FORM_GROUPBOX           430
+#define STR_FORM_DROPDOWN           431
+#define STR_FORM_SPINNER            432
+#define STR_FORM_SCROLLBAR          433
+
+#define STR_PGNUM                   434
+
+#define STR_MANAGE_NAMES            435
+
+#define STR_HEADER_NAME             436
+#define STR_HEADER_RANGE            437
+#define STR_HEADER_SCOPE            438
+#define STR_GLOBAL_SCOPE            439
+#define STR_ERR_NAME_EXISTS         440
+#define STR_ERR_NAME_INVALID        441
+
+#define STR_UNSAVED_EXT_REF         442
+#define STR_CLOSE_WITH_UNSAVED_REFS 443
+#define STR_PIVOT_GROUP             444
+#define STR_HEADER_COND             445
+
+#define STR_COND_CONDITION          446
+#define STR_COND_COLORSCALE         447
+#define STR_COND_DATABAR            448
+#define STR_COND_ICONSET            449
+#define STR_COND_FORMULA            450
+#define STR_COND_BETWEEN            451
+#define STR_COND_NOTBETWEEN         452
+#define STR_COND_UNIQUE             453
+#define STR_COND_DUPLICATE          454
+#define STR_COND_TOP10              455
+#define STR_COND_BOTTOM10           456
+#define STR_COND_TOP_PERCENT        457
+#define STR_COND_BOTTOM_PERCENT     458
+#define STR_COND_ABOVE_AVERAGE      459
+#define STR_COND_BELOW_AVERAGE      460
+#define STR_COND_ERROR              461
+#define STR_COND_NOERROR            462
+#define STR_COND_BEGINS_WITH        463
+#define STR_COND_ENDS_WITH          464
+#define STR_COND_CONTAINS           465
+#define STR_COND_NOT_CONTAINS       466
+#define STR_COND_DATE               467
+#define STR_COND_TODAY              468
+#define STR_COND_YESTERDAY          469
+#define STR_COND_TOMORROW           470
+#define STR_COND_LAST7DAYS          471
+#define STR_COND_THISWEEK           472
+#define STR_COND_LASTWEEK           473
+#define STR_COND_NEXTWEEK           474
+#define STR_COND_THISMONTH          475
+#define STR_COND_LASTMONTH          476
+#define STR_COND_NEXTMONTH          477
+#define STR_COND_THISYEAR           478
+#define STR_COND_LASTYEAR           479
+#define STR_COND_NEXTYEAR           480
+
+#define STR_ERR_CONDFORMAT_PROTECTED   481
+#define STR_EDIT_EXISTING_COND_FORMATS 482
+
+#define STR_QUERY_FORMULA_RECALC_ONLOAD_ODS 483
+#define STR_QUERY_FORMULA_RECALC_ONLOAD_XLS 484
+#define STR_ALWAYS_PERFORM_SELECTED         485
+
+#define STR_NO_INSERT_DELETE_OVER_PIVOT_TABLE 486
+
+#define STR_CHG_INSERT_COLS         487
+#define STR_CHG_INSERT_ROWS         488
+#define STR_CHG_INSERT_TABS         489
+#define STR_CHG_DELETE_COLS         490
+#define STR_CHG_DELETE_ROWS         491
+#define STR_CHG_DELETE_TABS         492
+#define STR_CHG_MOVE                493
+#define STR_CHG_CONTENT             494
+#define STR_CHG_REJECT              495
+#define STR_CHG_ACCEPTED            496
+#define STR_CHG_REJECTED            497
+#define STR_CHG_NO_ENTRY            498
+#define STR_CHG_CONTENT_WITH_CHILD  499
+#define STR_CHG_CHILD_CONTENT       500
+#define STR_CHG_CHILD_ORGCONTENT    501
+#define STR_CHG_EMPTY               502
+
+#define STR_UNDO_HIDETABS           503
+#define STR_UNDO_SHOWTABS           504
+
+#define STR_DPFIELD_GROUP_BY_SECONDS     505
+#define STR_DPFIELD_GROUP_BY_MINUTES     506
+#define STR_DPFIELD_GROUP_BY_HOURS       507
+#define STR_DPFIELD_GROUP_BY_DAYS        508
+#define STR_DPFIELD_GROUP_BY_MONTHS      509
+#define STR_DPFIELD_GROUP_BY_QUARTERS    510
+#define STR_DPFIELD_GROUP_BY_YEARS       511
+
+#define STR_COND_ABOVE_EQUAL_AVERAGE 512
+#define STR_COND_BELOW_EQUAL_AVERAGE 513
+
+#define STR_MULTI_SELECT            514
+
+#define STR_INVALIDVAL              515
+#define STR_INVALIDVAR              516
+#define STR_INVALIDFORM             517
+#define STR_NOFORMULA               518
+
+#define STR_INVALIDINPUT            519
+#define STR_INVALIDCONDITION        520
+
+#define STR_FUN_TEXT_SELECTION_COUNT 521
+
+#define STR_QUERYREMOVE             522
+#define STR_COPYLIST                523
+#define STR_COPYFROM                524
+#define STR_COPYERR                 525
+
+#define STR_CTRLCLICKHYPERLINK      526
+#define STR_CLICKHYPERLINK          527
+
+#define SC_GLOBSTR_STR_COUNT        528     /**< the count of permanently resident strings */
 
 #endif
 
diff --git a/sc/util/number-defines-consecutively.awk b/sc/util/number-defines-consecutively.awk
new file mode 100755
index 000000000000..6297dcdb2a35
--- /dev/null
+++ b/sc/util/number-defines-consecutively.awk
@@ -0,0 +1,49 @@
+#!/usr/bin/awk -f
+#
+# -*- Mode: awk; tab-width: 4; indent-tabs-mode: t -*-
+#
+# This file is part of the LibreOffice project.
+#
+# This Source Code Form is subject to the terms of the Mozilla Public
+# License, v. 2.0. If a copy of the MPL was not distributed with this
+# file, You can obtain one at http://mozilla.org/MPL/2.0/.
+#
+
+# Consecutively number a series of defines, for example sc/inc/globstr.hrc
+# WARNING: this does not expect other defines in between and would mess around
+# with them.
+
+BEGIN {
+    id = 0;
+    lastline = ""
+}
+
+{
+    if ($1 ~ /#define/ && lastline !~ /#ifndef/)
+    {
+        n = split( $0, a, / +/, s);
+        if (dup[a[3]])
+        {
+            dupmsg = " // XXX was duplicate " a[3] " of " dup[a[3]];
+        }
+        else
+        {
+            dup[a[3]] = a[2];
+            dupmsg = "";
+        }
+        a[3] = ++id;
+        lastline = s[0];
+        for (i=1; i<=n; ++i)
+        {
+            lastline = lastline a[i] s[i];
+        }
+        lastline = lastline dupmsg;
+    }
+    else
+    {
+        lastline = $0;
+    }
+    print lastline;
+}
+
+# vim:set shiftwidth=4 softtabstop=4 expandtab: