validityref: #i103899# manual migration from svn (contribution from PengYunQuan)

1 files changed, 66 insertions, 16 deletions

diff --git a/sc/source/ui/dbgui/validate.src b/sc/source/ui/dbgui/validate.src
index afd3fc213391..1f8e4b48deac 100644
--- a/sc/source/ui/dbgui/validate.src
+++ b/sc/source/ui/dbgui/validate.src
@@ -65,7 +65,9 @@ TabDialog TAB_DLG_VALIDATION
     };
     Text [ en-US ] = "Validity" ;
 };
-
+//<!--Added by PengYunQuan for Validity Cell Range Picker
+#define OFFSET_X    30
+//-->Added by PengYunQuan for Validity Cell Range Picker
 TabPage TP_VALIDATION_VALUES
 {
     Hide = TRUE ;
@@ -75,13 +77,19 @@ TabPage TP_VALIDATION_VALUES
     FixedText FT_ALLOW
     {
         Pos = MAP_APPFONT ( 6 , 16 ) ;
-        Size = MAP_APPFONT ( 70 , 8 ) ;
+        //<!--Modified by PengYunQuan for Validity Cell Range Picker
+        //Size = MAP_APPFONT ( 70 , 8 ) ;
+        Size = MAP_APPFONT ( 70 - OFFSET_X , 8 ) ;
+        //-->Modified by PengYunQuan for Validity Cell Range Picker
         Text [ en-US ] = "~Allow" ;
     };
     ListBox LB_ALLOW
     {
         Border = TRUE ;
-        Pos = MAP_APPFONT ( 80 , 14 ) ;
+        //<!--Modified by PengYunQuan for Validity Cell Range Picker
+        //Pos = MAP_APPFONT ( 80 , 14 ) ;
+        Pos = MAP_APPFONT ( 80 - OFFSET_X , 14 ) ;
+        //-->Modified by PengYunQuan for Validity Cell Range Picker
         Size = MAP_APPFONT ( 90 , 80 ) ;
         TabStop = TRUE ;
         DropDown = TRUE ;
@@ -100,13 +108,19 @@ TabPage TP_VALIDATION_VALUES
     FixedText FT_VALUE
     {
         Pos = MAP_APPFONT ( 6 , 58 ) ;
-        Size = MAP_APPFONT ( 70 , 8 ) ;
+        //<!--Modified by PengYunQuan for Validity Cell Range Picker
+        //Size = MAP_APPFONT ( 70 , 8 ) ;
+        Size = MAP_APPFONT ( 70 - OFFSET_X , 8 ) ;
+        //-->Modified by PengYunQuan for Validity Cell Range Picker
         Text [ en-US ] = "~Data" ;
     };
     ListBox LB_VALUE
     {
         Border = TRUE ;
-        Pos = MAP_APPFONT ( 80 , 56 ) ;
+        //<!--Modified by PengYunQuan for Validity Cell Range Picker
+        //Pos = MAP_APPFONT ( 80 , 56 ) ;
+        Pos = MAP_APPFONT ( 80 - OFFSET_X , 56 ) ;
+        //-->Modified by PengYunQuan for Validity Cell Range Picker
         Size = MAP_APPFONT ( 90 , 90 ) ;
         TabStop = TRUE ;
         DropDown = TRUE ;
@@ -126,54 +140,81 @@ TabPage TP_VALIDATION_VALUES
     FixedText FT_MIN
     {
         Pos = MAP_APPFONT ( 6 , 76 ) ;
-        Size = MAP_APPFONT ( 70 , 8 ) ;
+        //<!--Modified by PengYunQuan for Validity Cell Range Picker
+        //Size = MAP_APPFONT ( 70 , 8 ) ;
+        Size = MAP_APPFONT ( 70 - OFFSET_X , 8 ) ;
+        //-->Modified by PengYunQuan for Validity Cell Range Picker
         Text [ en-US ] = "~Minimum" ;
     };
     Edit EDT_MIN
     {
         Border = TRUE ;
-        Pos = MAP_APPFONT ( 80 , 74 ) ;
-        Size = MAP_APPFONT ( 174 , 12 ) ;
+        //<!--Modified by PengYunQuan for Validity Cell Range Picker
+        //Pos = MAP_APPFONT ( 80 , 74 ) ;
+        //Size = MAP_APPFONT ( 174 , 12 ) ;
+        Pos = MAP_APPFONT ( 80 - OFFSET_X , 74 ) ;
+        Size = MAP_APPFONT ( 90 , 12 ) ;
+        //-->Modified by PengYunQuan for Validity Cell Range Picker
         TabStop = TRUE ;
     };
     MultiLineEdit EDT_LIST
     {
         Border = TRUE ;
-        Pos = MAP_APPFONT ( 80 , 74 ) ;
-        Size = MAP_APPFONT ( 174 , 105 ) ;
+        //<!--Modified by PengYunQuan for Validity Cell Range Picker
+        //Pos = MAP_APPFONT ( 80 , 74 ) ;
+        //Size = MAP_APPFONT ( 174 , 105 ) ;
+        Pos = MAP_APPFONT ( 80 - OFFSET_X , 74 ) ;
+        Size = MAP_APPFONT ( 174 + OFFSET_X , 105 ) ;
+        //-->Modified by PengYunQuan for Validity Cell Range Picker
         VScroll = TRUE ;
         IgnoreTab = TRUE ;
     };
     FixedText FT_MAX
     {
         Pos = MAP_APPFONT ( 6 , 92 ) ;
-        Size = MAP_APPFONT ( 70 , 8 ) ;
+        //<!--Modified by PengYunQuan for Validity Cell Range Picker
+        //Size = MAP_APPFONT ( 70 , 8 ) ;
+        Size = MAP_APPFONT ( 70 - OFFSET_X , 8 ) ;
+        //-->Modified by PengYunQuan for Validity Cell Range Picker
         Text [ en-US ] = "Ma~ximum" ;
     };
     Edit EDT_MAX
     {
         Border = TRUE ;
-        Pos = MAP_APPFONT ( 80 , 90 ) ;
-        Size = MAP_APPFONT ( 174 , 12 ) ;
+        //<!--Modified by PengYunQuan for Validity Cell Range Picker
+        //Pos = MAP_APPFONT ( 80 , 90 ) ;
+        //Size = MAP_APPFONT ( 174 , 12 ) ;
+        Pos = MAP_APPFONT ( 80 - OFFSET_X , 90 ) ;
+        Size = MAP_APPFONT ( 90 , 12 ) ;
+        //-->Modified by PengYunQuan for Validity Cell Range Picker
         TabStop = TRUE ;
     };
     CheckBox TSB_ALLOW_BLANKS
     {
-        Pos = MAP_APPFONT ( 80 , 30 ) ;
+        //<!--Modified by PengYunQuan for Validity Cell Range Picker
+        //Pos = MAP_APPFONT ( 80 , 30 ) ;
+        Pos = MAP_APPFONT ( 80 - OFFSET_X , 30 ) ;
+        //-->Modified by PengYunQuan for Validity Cell Range Picker
         Size = MAP_APPFONT ( 174 , 10 ) ;
         TabStop = TRUE ;
         Text [ en-US ] = "Allow ~blank cells" ;
     };
     CheckBox CB_SHOWLIST
     {
-        Pos = MAP_APPFONT ( 80 , 44 ) ;
+        //<!--Modified by PengYunQuan for Validity Cell Range Picker
+        //Pos = MAP_APPFONT ( 80 , 44 ) ;
+        Pos = MAP_APPFONT ( 80 - OFFSET_X , 44 ) ;
+        //-->Modified by PengYunQuan for Validity Cell Range Picker
         Size = MAP_APPFONT ( 174 , 10 ) ;
         TabStop = TRUE ;
         Text [ en-US ] = "Show selection ~list" ;
     };
     CheckBox CB_SORTLIST
     {
-        Pos = MAP_APPFONT ( 90 , 58 ) ;
+        //<!--Modified by PengYunQuan for Validity Cell Range Picker
+        //Pos = MAP_APPFONT ( 90 , 58 ) ;
+        Pos = MAP_APPFONT ( 90 - OFFSET_X , 58 ) ;
+        //-->Modified by PengYunQuan for Validity Cell Range Picker
         Size = MAP_APPFONT ( 164 , 10 ) ;
         TabStop = TRUE ;
         Text [ en-US ] = "Sor~t entries ascending" ;
@@ -185,6 +226,15 @@ TabPage TP_VALIDATION_VALUES
         WordBreak = TRUE ;
         Text [ en-US ] = "A valid source can only consist of a contiguous selection of rows and columns, or a formula that results in an area or array.";
     };
+    //<!--Added by PengYunQuan for Validity Cell Range Picker
+    ImageButton RB_VALIDITY_REF
+    {
+        Pos = MAP_APPFONT ( 142 , 73 ) ;
+        Size = MAP_APPFONT ( 13 , 14 ) ;
+        TabStop = TRUE ;
+        QuickHelpText [ en-US ] = "Shrink" ;
+    };
+    //-->Added by PengYunQuan for Validity Cell Range Picker
 };
 
 TabPage TP_VALIDATION_INPUTHELP