在合并过后的单元格插入多张图片，并使用startColumnOffset控制左偏移量不生效

收藏

我想实现的效果是：在一个合并的单元格中。可以放入多张图片，图片大小适配，位置均匀分配单元格。代码在demo中

JoestarXu · JoestarXu

本帖最后由 JoestarXu 于 2023-5-25 12:12 编辑

您好，我看您之前提的帖子和这个帖子的需求几乎一致。

https://gcdn.grapecity.com.cn/showtopic-168392-1-1.html

您可以参考以下代码看能否解决您的问题：

window.onload = function () {
let designerConfig = JSON.parse(
JSON.stringify(GC.Spread.Sheets.Designer.DefaultConfig)
);
let designer = new GC.Spread.Sheets.Designer.Designer(
"gc-designer-container",
designerConfig
);
let spread = designer.getWorkbook();
let sheet = spread.getActiveSheet();
sheet.addSpan(16, 5, 1, 2);
let arr = [
"data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAALgAAAA9CAYAAAAeTqOsAAAAAXNSR0IArs4c6QAADppJREFUeF7tnQm0TWUbxx+ZImPmeSzjQplCZIhoUWYSCk1EqGQmM5kqZJawzLPIMjWYF1moUCkZi0JmGb/1e761v+9+97vu2eecfc7e233ftVr3uuecfd79PP/3ef/P/3neXaK7d+/eFTOMBXxugR9//FF69OghX331lYwbN05atmypd5TIANznnk2g0ycunz9/XtatWyeLFi2Sr7/+Wv7++2957LHHpFWrVvLmm29K4sSJDcATKD58fdvXr19XUPfr109+++03vZdHHnlEI3e1atUkWbJk/7k/E8F97eqENflDhw7JlClTZOPGjfLdd99JpkyZpH79+tK4cWMpW7aspE2bVhIlSvQ/RjEAT1gY8d3d3rp1S86cOSODBw+WiRMnKoDTp0+vHLtXr16SJUuWeO/JANx3Lk8YEwbYO3fulE8//VSWLl2qfLtAgQLSsWNHqVWrlhQpUuT/onVcljEATxh48cVdkjjeuHFDfv75Z+nbt6+sWbNG+FuuXLnk3Xfflddff10eeOCBoO7FADwoc5k3R8oCN2/elG3btsmkSZNUEYGWVKhQQV555RWpV6+e0pLY/NrOXAzA7VjJvCdiFiBiHzx4UKZNm6YcO2nSpFK4cGGN4M8++6w8+OCDYX237wF+9epV+fPPPwXOljVrVkmZMmVIKz0sK5oPh2SBkydPSqdOnTRy//XXX1KuXDnVr6tXr66+DCVix56ILwEOL7ty5YqsWrVKRo8eLd9++63eV+nSpWXChAkqGQXL1ULykPlQ0Ba4c+eOatezZs2SgQMHqp8KFSokbdu21QQyefLkQV8zvg/4DuCAm9U+atQo5Wtwt5o1a8off/whu3btkuHDh2tUSJEihaOGMhcL3wKXLl2SoUOHysKFC+XIkSPy0EMPKS156qmnJGfOnI5EbN9H8AsXLkjv3r3lk08+0eya/oNGjRpJ586d1XBEha5duypVMcN9CxCQ8NnWrVvVb/v27dMCDVLf9OnTHY/YvgY40bpOnTqyadMm3daoalWsWFGpCjISUQGQP//885IkSRL3vZvAZ0BehK8oqVN5xH/srm3atFEdm16RSA/fUBSiQIsWLVQbJcv+6KOPlJocOHBAM+4VK1bICy+8IEOGDJHcuXNHZLuLtDPuh+sTsW/fvi1097HLTp48WaM0eRG+KV++fFSDjy8AjsEA85dffilp0qSRb775RkqUKKHbHdve2rVrlceNHDlSu8lMguneUrl27ZrybJJ9qo9E6gEDBujOC+d2QhkJ5u48D3A6x7p06aJ8DU2Usi0y0vfffy/du3eX9evXq3oyZswYpSsG3MG437n3/vPPPzJ37lx5//335dixY7qLdujQQdUROLdbw9MAZ7t75513tAhABk4XGZEataRZs2Zy/PhxrXINGzZMaYsBd/RhhI9++eUXpYfItUToGjVqyOzZsyVz5sxRj9i+STIxHBEBleTUqVMyfvx4LdvS8wvnJokkOrz99tuqprg9rD4KcgIW4OnTp+Xs2bNy7tw55aD58uXTylzJkiVdd7oTtkLP3rNnj+rZn332mQagBg0aqI+gI14Zno3gdJIRvZGXyMIB8tNPP61Rgr4EVBP+RnN7tHldTOcBbHjnkiVLdCehiAGt4u/sKJSeySFQFPLkySPLli3TPMGvg/vi/kgY4dkk/0iy5EEkkNyvl4YnAU7RpmfPnrrNAeonn3xSJUEoCVTkww8/1KTTTUqCo1EKKDatXLlSJcoMGTKovouj+a9UqVIavS9evCgvvviifPHFF1K5cmWZOnWqnkDx0+B+uQ+OiKFgEXhy5Mihyla3bt0kY8aMrgaae9nScwDHkCSM/fv319ZJGtrpLON3pCYM63aUICJDk4jYDNQBEip2mlSpUsVp699//13pCclY+/bt9bNu7jzBLC58QgsrhwygX8yb3/ERPdpeHp4DONIf1IMCgTUefvhh5eJUKN0s4ABO+CZtAjic8jL9EyS8efPmjdfPfJa+mT59+ui5QRJneLmXB8A+fPiwjB07VlUs/v3EE0/Ie++9pztVzLOPXr0PTwGcShcnOIiGREkiRdGiRfWAKdTErYhHQnXixAmtwPFYAhYZ7QEkWHYXnJWU0eOcP39+5bCcJfTaAMTWiXXk2Tlz5igVRPYjYr/88stem3K88/EMwDHq9u3btV1y7969ki5dOnnppZdU6w6nddJymJXoEUn5nWYs+DHOi2/hwDsp/0Mp4NlIYEQwcoNgFhzzgKbUrl1bFwvggeYEc41II4s5/vTTTwpqq1CD1MdiRCEhx/DbcB3gVmn3888/V9mP6hcRbsSIEdKwYcOwE0m4++rVqzXixn7GUbFixbSbjagaOxITcSlY0LwFLYFnA0rAfS+eHcj5KA4kzyTMzZs31+9OnTp1oI9F/HUUHiRNqAjldSQ/ggpHxCjc+Hm4DvDLly+rIRcvXqyJJEDjtDQleCc4nsUjueajjz6qXJmoDeiRtgAu1VHUDWvgcJJZpEhkyTJlymi0JXqH06XI/aEMoRWjDKHtk3i6NdjJyHmI1rQ/wLezZ8+uSfCrr77qiUJNuLZxDeBEyF9//VWIojiezjIM/vjjj6sMGBNw4d5kXJ+HqhDVAXmTJk20qMRA412+fLkuOubVtGlTTQxZHOEOFtuWLVuUe0OPPvjgA01Qo0lTmANPgPrhhx+UU5PME1SgH+Q+dPtRZ7hfhisA5zTOW2+9pVwPg9etW1ejBy2VbN0oDETWSA+2XxYTADt69KguMqIXSS05AIUmEksnuSc8nryCgg/6MTtVNO6VgIJeP3PmTNXveYgOciuBBNUKzR5d+34bUQU4EXH//v3atwCgMSgdgEhPbNUkfjgdYEUjquFs5EfK6nQqIkMyv4IFCypNat26tePzYHHzvfB5msQAO7sDWj/fTVJHpZN+91BtQNCAR5PUct2PP/5YKRkVVxYxRSZ2SnaQ+xHUMRdp1ABOdRIwIwOSSBLBARRaMsYnSyea8DpJZjQGnYjwYZJJFhe0pWrVqtrvYvfBMsHO01IqWEBQIZJMaBHfbQ1agomyJHp2B/QOyjdjxgzNG7A3uwU5DoM2ARYzsisLKxq7ht25R/J9EQc4p96R/6AD8E/AS6GEhhx4KBGNjkCehfHcc8/J/Pnz431UAJ1rRJ1wHyeAUTmND/9mXhSTUG2gLE5c+15OI4ElseNRZADcGkRWEjxOmkMnsBP0iJPmsQ/iAmbOpXKdzZs3K6At+ZOozzP6SKahVjR4UU6nZTWQJBpJoLl17YgCnC2S5ne4NokNVT/4HkUDy9j8nSgOH0QDt05ax2UQtl2SUoDAI3JJikLdxrk+0ZRIxzxJrIhykexvAZgbNmyQ1157TftqOFrH7/B/qpws3thSph1gEPF5CCVJc7Zs2TR/4Kf1CI1wbGTn+738nogAnGhC7zYFAp55QTQZNGiQOoDoGNPgtMLS7govRK5CiotrwN9psCJicbCB7r1AD170kuEBNzsZ+QcttNgCm1jH63id3Y6ozr2Ro6B0AFJsAoCxE+DlvvmJjErkRwVJyCCOz88RAXi7du1U1ybiQj8oIFjRMbYj4MH0NbAVoywQneMa8HW62HA4CSHatJ+cShst/J4dg3yDe4E2xL4Hq/JK4os90OL5G7kCNM9JRcdLASBSc3EU4Gy/KCCoAUQZlAKrZ/teN0Blj2eZVKpUSTXpuKqEHCiGkrBg6DTkERGRpBJOG5sdDa7PgWmiMQdxAzVnMQc+RzRHzSlevLjSPTi1GfYt4AjASYqso2Vk7TiD0rud0+1Eb6J4lSpV9Gfs6iWRD67KoqGnGpXF7XZZ++b99zsXLFig1IToO2/ePAW5nd0HWY/P0sKAlEogwE5m2LdAWABn66S7jjI2J3CQnpD/6Iu222WHHosaQBMS/DMmeElAATVN9pyit07V2789998JSAEnfBpqgkpk53kgcHJsS+EJWkOFkaJQOK0C7lsj+jMIGeBEbfRi5C4kKzg2Up+dqB3zNilooB6QRBGtYjqfhQN/ByRUOSOlTUfS7PS00HcCMFGTALmdsXv3bu1YREaluosd2AHsRH47108o7wka4ERtCgoUbejf4N+0tRJdQmlr5UQIhRY0aK5nARw+T2ECjZemJJp/nGi+irZjqRZSrSR5hmYFShLZtegytORSuDtqixcOVkfbdk58X1AAB8ycpH7jjTeECENxhKZ/ijahJn2UqVkwMbdvnEzJnlMkRC8WEwDxY/SCP5M3cEZzx44d8foMSRU7UF6nuMN9UxsI1bZOAMTv17AFcOskNRSCRAeNlkQJ2QrHheMAi4OzSJDFiOBEbJ6GBB/nO9ni7fBWLzoD9QdqQnIIhYs9kAPJMeDmvE7ZnkUN50Y69eOi9pIfbAOcqIKziDIkPgDQiYSH4g10BADgaLZxElWSVhYT1U8nvscto2MnAgHtBfBxCjQczWMnpC2APmx4NhGbHIMF7URrrlv367XvtQVwJk0U59QHdILOP6ceVE6vNRVPdHCKQ0Q7tHGqlZzqYYfwcxSznvrEaXR2Ies5KYCc32l8Yjd85plntMPP/B8qnF0itgHu7Nf+92qUrwEzjmZnILmifE/0JpL7TfOOy05IfnT2EcGhd7TEUonlIDV9JH6lX5HChJPXdR3gSIwkkLSr8pM2UU68ENXpy/Zz9HbSUeZaoVnAdYDDP5HCeOoTMiP9ykiGRHPADTXipwF6aA5O6J9yHeAAmONTJJtwfMr8lO/h+JTpaWOlDYD2TwPyhA7X4O/fdYAzZTgqhw7QfAE1UR0wc9qFwghau3n2d/DONZ8Q8QTAcQSlfyI4PRscQCC5RFrj8WaA3PQ8G7iGYgHPADyUyZvPGAsEsoABeCALmdd9bQEDcF+7z0w+kAUMwANZyLzuawsYgPvafWbygSxgAB7IQuZ1X1vAANzX7jOTD2QBA/BAFjKv+9oCBuC+dp+ZfCALGIAHspB53dcWMAD3tfvM5ANZ4F+W2jTCzSfRKwAAAABJRU5ErkJggg==",
"data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAALgAAAA9CAYAAAAeTqOsAAAAAXNSR0IArs4c6QAADppJREFUeF7tnQm0TWUbxx+ZImPmeSzjQplCZIhoUWYSCk1EqGQmM5kqZJawzLPIMjWYF1moUCkZi0JmGb/1e761v+9+97vu2eecfc7e233ftVr3uuecfd79PP/3ef/P/3neXaK7d+/eFTOMBXxugR9//FF69OghX331lYwbN05atmypd5TIANznnk2g0ycunz9/XtatWyeLFi2Sr7/+Wv7++2957LHHpFWrVvLmm29K4sSJDcATKD58fdvXr19XUPfr109+++03vZdHHnlEI3e1atUkWbJk/7k/E8F97eqENflDhw7JlClTZOPGjfLdd99JpkyZpH79+tK4cWMpW7aspE2bVhIlSvQ/RjEAT1gY8d3d3rp1S86cOSODBw+WiRMnKoDTp0+vHLtXr16SJUuWeO/JANx3Lk8YEwbYO3fulE8//VSWLl2qfLtAgQLSsWNHqVWrlhQpUuT/onVcljEATxh48cVdkjjeuHFDfv75Z+nbt6+sWbNG+FuuXLnk3Xfflddff10eeOCBoO7FADwoc5k3R8oCN2/elG3btsmkSZNUEYGWVKhQQV555RWpV6+e0pLY/NrOXAzA7VjJvCdiFiBiHzx4UKZNm6YcO2nSpFK4cGGN4M8++6w8+OCDYX237wF+9epV+fPPPwXOljVrVkmZMmVIKz0sK5oPh2SBkydPSqdOnTRy//XXX1KuXDnVr6tXr66+DCVix56ILwEOL7ty5YqsWrVKRo8eLd9++63eV+nSpWXChAkqGQXL1ULykPlQ0Ba4c+eOatezZs2SgQMHqp8KFSokbdu21QQyefLkQV8zvg/4DuCAm9U+atQo5Wtwt5o1a8off/whu3btkuHDh2tUSJEihaOGMhcL3wKXLl2SoUOHysKFC+XIkSPy0EMPKS156qmnJGfOnI5EbN9H8AsXLkjv3r3lk08+0eya/oNGjRpJ586d1XBEha5duypVMcN9CxCQ8NnWrVvVb/v27dMCDVLf9OnTHY/YvgY40bpOnTqyadMm3daoalWsWFGpCjISUQGQP//885IkSRL3vZvAZ0BehK8oqVN5xH/srm3atFEdm16RSA/fUBSiQIsWLVQbJcv+6KOPlJocOHBAM+4VK1bICy+8IEOGDJHcuXNHZLuLtDPuh+sTsW/fvi1097HLTp48WaM0eRG+KV++fFSDjy8AjsEA85dffilp0qSRb775RkqUKKHbHdve2rVrlceNHDlSu8lMguneUrl27ZrybJJ9qo9E6gEDBujOC+d2QhkJ5u48D3A6x7p06aJ8DU2Usi0y0vfffy/du3eX9evXq3oyZswYpSsG3MG437n3/vPPPzJ37lx5//335dixY7qLdujQQdUROLdbw9MAZ7t75513tAhABk4XGZEataRZs2Zy/PhxrXINGzZMaYsBd/RhhI9++eUXpYfItUToGjVqyOzZsyVz5sxRj9i+STIxHBEBleTUqVMyfvx4LdvS8wvnJokkOrz99tuqprg9rD4KcgIW4OnTp+Xs2bNy7tw55aD58uXTylzJkiVdd7oTtkLP3rNnj+rZn332mQagBg0aqI+gI14Zno3gdJIRvZGXyMIB8tNPP61Rgr4EVBP+RnN7tHldTOcBbHjnkiVLdCehiAGt4u/sKJSeySFQFPLkySPLli3TPMGvg/vi/kgY4dkk/0iy5EEkkNyvl4YnAU7RpmfPnrrNAeonn3xSJUEoCVTkww8/1KTTTUqCo1EKKDatXLlSJcoMGTKovouj+a9UqVIavS9evCgvvviifPHFF1K5cmWZOnWqnkDx0+B+uQ+OiKFgEXhy5Mihyla3bt0kY8aMrgaae9nScwDHkCSM/fv319ZJGtrpLON3pCYM63aUICJDk4jYDNQBEip2mlSpUsVp699//13pCclY+/bt9bNu7jzBLC58QgsrhwygX8yb3/ERPdpeHp4DONIf1IMCgTUefvhh5eJUKN0s4ABO+CZtAjic8jL9EyS8efPmjdfPfJa+mT59+ui5QRJneLmXB8A+fPiwjB07VlUs/v3EE0/Ie++9pztVzLOPXr0PTwGcShcnOIiGREkiRdGiRfWAKdTErYhHQnXixAmtwPFYAhYZ7QEkWHYXnJWU0eOcP39+5bCcJfTaAMTWiXXk2Tlz5igVRPYjYr/88stem3K88/EMwDHq9u3btV1y7969ki5dOnnppZdU6w6nddJymJXoEUn5nWYs+DHOi2/hwDsp/0Mp4NlIYEQwcoNgFhzzgKbUrl1bFwvggeYEc41II4s5/vTTTwpqq1CD1MdiRCEhx/DbcB3gVmn3888/V9mP6hcRbsSIEdKwYcOwE0m4++rVqzXixn7GUbFixbSbjagaOxITcSlY0LwFLYFnA0rAfS+eHcj5KA4kzyTMzZs31+9OnTp1oI9F/HUUHiRNqAjldSQ/ggpHxCjc+Hm4DvDLly+rIRcvXqyJJEDjtDQleCc4nsUjueajjz6qXJmoDeiRtgAu1VHUDWvgcJJZpEhkyTJlymi0JXqH06XI/aEMoRWjDKHtk3i6NdjJyHmI1rQ/wLezZ8+uSfCrr77qiUJNuLZxDeBEyF9//VWIojiezjIM/vjjj6sMGBNw4d5kXJ+HqhDVAXmTJk20qMRA412+fLkuOubVtGlTTQxZHOEOFtuWLVuUe0OPPvjgA01Qo0lTmANPgPrhhx+UU5PME1SgH+Q+dPtRZ7hfhisA5zTOW2+9pVwPg9etW1ejBy2VbN0oDETWSA+2XxYTADt69KguMqIXSS05AIUmEksnuSc8nryCgg/6MTtVNO6VgIJeP3PmTNXveYgOciuBBNUKzR5d+34bUQU4EXH//v3atwCgMSgdgEhPbNUkfjgdYEUjquFs5EfK6nQqIkMyv4IFCypNat26tePzYHHzvfB5msQAO7sDWj/fTVJHpZN+91BtQNCAR5PUct2PP/5YKRkVVxYxRSZ2SnaQ+xHUMRdp1ABOdRIwIwOSSBLBARRaMsYnSyea8DpJZjQGnYjwYZJJFhe0pWrVqtrvYvfBMsHO01IqWEBQIZJMaBHfbQ1agomyJHp2B/QOyjdjxgzNG7A3uwU5DoM2ARYzsisLKxq7ht25R/J9EQc4p96R/6AD8E/AS6GEhhx4KBGNjkCehfHcc8/J/Pnz431UAJ1rRJ1wHyeAUTmND/9mXhSTUG2gLE5c+15OI4ElseNRZADcGkRWEjxOmkMnsBP0iJPmsQ/iAmbOpXKdzZs3K6At+ZOozzP6SKahVjR4UU6nZTWQJBpJoLl17YgCnC2S5ne4NokNVT/4HkUDy9j8nSgOH0QDt05ax2UQtl2SUoDAI3JJikLdxrk+0ZRIxzxJrIhykexvAZgbNmyQ1157TftqOFrH7/B/qpws3thSph1gEPF5CCVJc7Zs2TR/4Kf1CI1wbGTn+738nogAnGhC7zYFAp55QTQZNGiQOoDoGNPgtMLS7govRK5CiotrwN9psCJicbCB7r1AD170kuEBNzsZ+QcttNgCm1jH63id3Y6ozr2Ro6B0AFJsAoCxE+DlvvmJjErkRwVJyCCOz88RAXi7du1U1ybiQj8oIFjRMbYj4MH0NbAVoywQneMa8HW62HA4CSHatJ+cShst/J4dg3yDe4E2xL4Hq/JK4os90OL5G7kCNM9JRcdLASBSc3EU4Gy/KCCoAUQZlAKrZ/teN0Blj2eZVKpUSTXpuKqEHCiGkrBg6DTkERGRpBJOG5sdDa7PgWmiMQdxAzVnMQc+RzRHzSlevLjSPTi1GfYt4AjASYqso2Vk7TiD0rud0+1Eb6J4lSpV9Gfs6iWRD67KoqGnGpXF7XZZ++b99zsXLFig1IToO2/ePAW5nd0HWY/P0sKAlEogwE5m2LdAWABn66S7jjI2J3CQnpD/6Iu222WHHosaQBMS/DMmeElAATVN9pyit07V2789998JSAEnfBpqgkpk53kgcHJsS+EJWkOFkaJQOK0C7lsj+jMIGeBEbfRi5C4kKzg2Up+dqB3zNilooB6QRBGtYjqfhQN/ByRUOSOlTUfS7PS00HcCMFGTALmdsXv3bu1YREaluosd2AHsRH47108o7wka4ERtCgoUbejf4N+0tRJdQmlr5UQIhRY0aK5nARw+T2ECjZemJJp/nGi+irZjqRZSrSR5hmYFShLZtegytORSuDtqixcOVkfbdk58X1AAB8ycpH7jjTeECENxhKZ/ijahJn2UqVkwMbdvnEzJnlMkRC8WEwDxY/SCP5M3cEZzx44d8foMSRU7UF6nuMN9UxsI1bZOAMTv17AFcOskNRSCRAeNlkQJ2QrHheMAi4OzSJDFiOBEbJ6GBB/nO9ni7fBWLzoD9QdqQnIIhYs9kAPJMeDmvE7ZnkUN50Y69eOi9pIfbAOcqIKziDIkPgDQiYSH4g10BADgaLZxElWSVhYT1U8nvscto2MnAgHtBfBxCjQczWMnpC2APmx4NhGbHIMF7URrrlv367XvtQVwJk0U59QHdILOP6ceVE6vNRVPdHCKQ0Q7tHGqlZzqYYfwcxSznvrEaXR2Ies5KYCc32l8Yjd85plntMPP/B8qnF0itgHu7Nf+92qUrwEzjmZnILmifE/0JpL7TfOOy05IfnT2EcGhd7TEUonlIDV9JH6lX5HChJPXdR3gSIwkkLSr8pM2UU68ENXpy/Zz9HbSUeZaoVnAdYDDP5HCeOoTMiP9ykiGRHPADTXipwF6aA5O6J9yHeAAmONTJJtwfMr8lO/h+JTpaWOlDYD2TwPyhA7X4O/fdYAzZTgqhw7QfAE1UR0wc9qFwghau3n2d/DONZ8Q8QTAcQSlfyI4PRscQCC5RFrj8WaA3PQ8G7iGYgHPADyUyZvPGAsEsoABeCALmdd9bQEDcF+7z0w+kAUMwANZyLzuawsYgPvafWbygSxgAB7IQuZ1X1vAANzX7jOTD2QBA/BAFjKv+9oCBuC+dp+ZfCALGIAHspB53dcWMAD3tfvM5ANZ4F+W2jTCzSfRKwAAAABJRU5ErkJggg==",
"data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAALgAAAA9CAYAAAAeTqOsAAAAAXNSR0IArs4c6QAADppJREFUeF7tnQm0TWUbxx+ZImPmeSzjQplCZIhoUWYSCk1EqGQmM5kqZJawzLPIMjWYF1moUCkZi0JmGb/1e761v+9+97vu2eecfc7e233ftVr3uuecfd79PP/3ef/P/3neXaK7d+/eFTOMBXxugR9//FF69OghX331lYwbN05atmypd5TIANznnk2g0ycunz9/XtatWyeLFi2Sr7/+Wv7++2957LHHpFWrVvLmm29K4sSJDcATKD58fdvXr19XUPfr109+++03vZdHHnlEI3e1atUkWbJk/7k/E8F97eqENflDhw7JlClTZOPGjfLdd99JpkyZpH79+tK4cWMpW7aspE2bVhIlSvQ/RjEAT1gY8d3d3rp1S86cOSODBw+WiRMnKoDTp0+vHLtXr16SJUuWeO/JANx3Lk8YEwbYO3fulE8//VSWLl2qfLtAgQLSsWNHqVWrlhQpUuT/onVcljEATxh48cVdkjjeuHFDfv75Z+nbt6+sWbNG+FuuXLnk3Xfflddff10eeOCBoO7FADwoc5k3R8oCN2/elG3btsmkSZNUEYGWVKhQQV555RWpV6+e0pLY/NrOXAzA7VjJvCdiFiBiHzx4UKZNm6YcO2nSpFK4cGGN4M8++6w8+OCDYX237wF+9epV+fPPPwXOljVrVkmZMmVIKz0sK5oPh2SBkydPSqdOnTRy//XXX1KuXDnVr6tXr66+DCVix56ILwEOL7ty5YqsWrVKRo8eLd9++63eV+nSpWXChAkqGQXL1ULykPlQ0Ba4c+eOatezZs2SgQMHqp8KFSokbdu21QQyefLkQV8zvg/4DuCAm9U+atQo5Wtwt5o1a8off/whu3btkuHDh2tUSJEihaOGMhcL3wKXLl2SoUOHysKFC+XIkSPy0EMPKS156qmnJGfOnI5EbN9H8AsXLkjv3r3lk08+0eya/oNGjRpJ586d1XBEha5duypVMcN9CxCQ8NnWrVvVb/v27dMCDVLf9OnTHY/YvgY40bpOnTqyadMm3daoalWsWFGpCjISUQGQP//885IkSRL3vZvAZ0BehK8oqVN5xH/srm3atFEdm16RSA/fUBSiQIsWLVQbJcv+6KOPlJocOHBAM+4VK1bICy+8IEOGDJHcuXNHZLuLtDPuh+sTsW/fvi1097HLTp48WaM0eRG+KV++fFSDjy8AjsEA85dffilp0qSRb775RkqUKKHbHdve2rVrlceNHDlSu8lMguneUrl27ZrybJJ9qo9E6gEDBujOC+d2QhkJ5u48D3A6x7p06aJ8DU2Usi0y0vfffy/du3eX9evXq3oyZswYpSsG3MG437n3/vPPPzJ37lx5//335dixY7qLdujQQdUROLdbw9MAZ7t75513tAhABk4XGZEataRZs2Zy/PhxrXINGzZMaYsBd/RhhI9++eUXpYfItUToGjVqyOzZsyVz5sxRj9i+STIxHBEBleTUqVMyfvx4LdvS8wvnJokkOrz99tuqprg9rD4KcgIW4OnTp+Xs2bNy7tw55aD58uXTylzJkiVdd7oTtkLP3rNnj+rZn332mQagBg0aqI+gI14Zno3gdJIRvZGXyMIB8tNPP61Rgr4EVBP+RnN7tHldTOcBbHjnkiVLdCehiAGt4u/sKJSeySFQFPLkySPLli3TPMGvg/vi/kgY4dkk/0iy5EEkkNyvl4YnAU7RpmfPnrrNAeonn3xSJUEoCVTkww8/1KTTTUqCo1EKKDatXLlSJcoMGTKovouj+a9UqVIavS9evCgvvviifPHFF1K5cmWZOnWqnkDx0+B+uQ+OiKFgEXhy5Mihyla3bt0kY8aMrgaae9nScwDHkCSM/fv319ZJGtrpLON3pCYM63aUICJDk4jYDNQBEip2mlSpUsVp699//13pCclY+/bt9bNu7jzBLC58QgsrhwygX8yb3/ERPdpeHp4DONIf1IMCgTUefvhh5eJUKN0s4ABO+CZtAjic8jL9EyS8efPmjdfPfJa+mT59+ui5QRJneLmXB8A+fPiwjB07VlUs/v3EE0/Ie++9pztVzLOPXr0PTwGcShcnOIiGREkiRdGiRfWAKdTErYhHQnXixAmtwPFYAhYZ7QEkWHYXnJWU0eOcP39+5bCcJfTaAMTWiXXk2Tlz5igVRPYjYr/88stem3K88/EMwDHq9u3btV1y7969ki5dOnnppZdU6w6nddJymJXoEUn5nWYs+DHOi2/hwDsp/0Mp4NlIYEQwcoNgFhzzgKbUrl1bFwvggeYEc41II4s5/vTTTwpqq1CD1MdiRCEhx/DbcB3gVmn3888/V9mP6hcRbsSIEdKwYcOwE0m4++rVqzXixn7GUbFixbSbjagaOxITcSlY0LwFLYFnA0rAfS+eHcj5KA4kzyTMzZs31+9OnTp1oI9F/HUUHiRNqAjldSQ/ggpHxCjc+Hm4DvDLly+rIRcvXqyJJEDjtDQleCc4nsUjueajjz6qXJmoDeiRtgAu1VHUDWvgcJJZpEhkyTJlymi0JXqH06XI/aEMoRWjDKHtk3i6NdjJyHmI1rQ/wLezZ8+uSfCrr77qiUJNuLZxDeBEyF9//VWIojiezjIM/vjjj6sMGBNw4d5kXJ+HqhDVAXmTJk20qMRA412+fLkuOubVtGlTTQxZHOEOFtuWLVuUe0OPPvjgA01Qo0lTmANPgPrhhx+UU5PME1SgH+Q+dPtRZ7hfhisA5zTOW2+9pVwPg9etW1ejBy2VbN0oDETWSA+2XxYTADt69KguMqIXSS05AIUmEksnuSc8nryCgg/6MTtVNO6VgIJeP3PmTNXveYgOciuBBNUKzR5d+34bUQU4EXH//v3atwCgMSgdgEhPbNUkfjgdYEUjquFs5EfK6nQqIkMyv4IFCypNat26tePzYHHzvfB5msQAO7sDWj/fTVJHpZN+91BtQNCAR5PUct2PP/5YKRkVVxYxRSZ2SnaQ+xHUMRdp1ABOdRIwIwOSSBLBARRaMsYnSyea8DpJZjQGnYjwYZJJFhe0pWrVqtrvYvfBMsHO01IqWEBQIZJMaBHfbQ1agomyJHp2B/QOyjdjxgzNG7A3uwU5DoM2ARYzsisLKxq7ht25R/J9EQc4p96R/6AD8E/AS6GEhhx4KBGNjkCehfHcc8/J/Pnz431UAJ1rRJ1wHyeAUTmND/9mXhSTUG2gLE5c+15OI4ElseNRZADcGkRWEjxOmkMnsBP0iJPmsQ/iAmbOpXKdzZs3K6At+ZOozzP6SKahVjR4UU6nZTWQJBpJoLl17YgCnC2S5ne4NokNVT/4HkUDy9j8nSgOH0QDt05ax2UQtl2SUoDAI3JJikLdxrk+0ZRIxzxJrIhykexvAZgbNmyQ1157TftqOFrH7/B/qpws3thSph1gEPF5CCVJc7Zs2TR/4Kf1CI1wbGTn+738nogAnGhC7zYFAp55QTQZNGiQOoDoGNPgtMLS7govRK5CiotrwN9psCJicbCB7r1AD170kuEBNzsZ+QcttNgCm1jH63id3Y6ozr2Ro6B0AFJsAoCxE+DlvvmJjErkRwVJyCCOz88RAXi7du1U1ybiQj8oIFjRMbYj4MH0NbAVoywQneMa8HW62HA4CSHatJ+cShst/J4dg3yDe4E2xL4Hq/JK4os90OL5G7kCNM9JRcdLASBSc3EU4Gy/KCCoAUQZlAKrZ/teN0Blj2eZVKpUSTXpuKqEHCiGkrBg6DTkERGRpBJOG5sdDa7PgWmiMQdxAzVnMQc+RzRHzSlevLjSPTi1GfYt4AjASYqso2Vk7TiD0rud0+1Eb6J4lSpV9Gfs6iWRD67KoqGnGpXF7XZZ++b99zsXLFig1IToO2/ePAW5nd0HWY/P0sKAlEogwE5m2LdAWABn66S7jjI2J3CQnpD/6Iu222WHHosaQBMS/DMmeElAATVN9pyit07V2789998JSAEnfBpqgkpk53kgcHJsS+EJWkOFkaJQOK0C7lsj+jMIGeBEbfRi5C4kKzg2Up+dqB3zNilooB6QRBGtYjqfhQN/ByRUOSOlTUfS7PS00HcCMFGTALmdsXv3bu1YREaluosd2AHsRH47108o7wka4ERtCgoUbejf4N+0tRJdQmlr5UQIhRY0aK5nARw+T2ECjZemJJp/nGi+irZjqRZSrSR5hmYFShLZtegytORSuDtqixcOVkfbdk58X1AAB8ycpH7jjTeECENxhKZ/ijahJn2UqVkwMbdvnEzJnlMkRC8WEwDxY/SCP5M3cEZzx44d8foMSRU7UF6nuMN9UxsI1bZOAMTv17AFcOskNRSCRAeNlkQJ2QrHheMAi4OzSJDFiOBEbJ6GBB/nO9ni7fBWLzoD9QdqQnIIhYs9kAPJMeDmvE7ZnkUN50Y69eOi9pIfbAOcqIKziDIkPgDQiYSH4g10BADgaLZxElWSVhYT1U8nvscto2MnAgHtBfBxCjQczWMnpC2APmx4NhGbHIMF7URrrlv367XvtQVwJk0U59QHdILOP6ceVE6vNRVPdHCKQ0Q7tHGqlZzqYYfwcxSznvrEaXR2Ies5KYCc32l8Yjd85plntMPP/B8qnF0itgHu7Nf+92qUrwEzjmZnILmifE/0JpL7TfOOy05IfnT2EcGhd7TEUonlIDV9JH6lX5HChJPXdR3gSIwkkLSr8pM2UU68ENXpy/Zz9HbSUeZaoVnAdYDDP5HCeOoTMiP9ykiGRHPADTXipwF6aA5O6J9yHeAAmONTJJtwfMr8lO/h+JTpaWOlDYD2TwPyhA7X4O/fdYAzZTgqhw7QfAE1UR0wc9qFwghau3n2d/DONZ8Q8QTAcQSlfyI4PRscQCC5RFrj8WaA3PQ8G7iGYgHPADyUyZvPGAsEsoABeCALmdd9bQEDcF+7z0w+kAUMwANZyLzuawsYgPvafWbygSxgAB7IQuZ1X1vAANzX7jOTD2QBA/BAFjKv+9oCBuC+dp+ZfCALGIAHspB53dcWMAD3tfvM5ANZ4F+W2jTCzSfRKwAAAABJRU5ErkJggg==",
];
let { x, y, width, height } = sheet.getCellRect(16, 5);
for (let i = 0; i < arr.length; i++) {
var picture = sheet.pictures.add("f" + i, arr[i], 0, 0, 10, 10);
var point = new GC.Spread.Sheets.Point(310 + (width / 3) * i, 320);
picture.position(point);
picture.width(width / arr.length);
picture.height(height);
}
};

复制代码

谢朵 · 谢朵

JoestarXu 发表于 2023-5-25 12:11
您好，我看您之前提的帖子和这个帖子的需求几乎一致。

https://gcdn.grapecity.com.cn/showtopic-168392 ...

是的，这是我联系了您们这边得技术支持后，他说让我新开一个帖子，方便跟一下。

谢朵 · 谢朵

JoestarXu 发表于 2023-5-25 12:11
您好，我看您之前提的帖子和这个帖子的需求几乎一致。

https://gcdn.grapecity.com.cn/showtopic-168392 ...

我比较疑惑得是 Point（x,y）为什么计算里面得x是固定得310，而不是动态得x。我更改为动态得x后，我发现x得数字比310大

JoestarXu · JoestarXu

谢朵发表于 2023-5-25 13:06
我比较疑惑得是 Point（x,y）为什么计算里面得x是固定得310，而不是动态得x。我更改为动态得x后，我发现x ...

您好，请问您是如何获取这个动态的x的呢？

谢朵 · 谢朵

JoestarXu 发表于 2023-5-25 14:07
您好，请问您是如何获取这个动态的x的呢？

let { x, y, width, height } = sheet.getCellRect(16, 5); 这个方法

谢朵 · 谢朵

我图里一个单元格的宽度为62。我的图片插入在F列，那应该是 5*62=310。但是我通过getCellRect获取到的x却是350.这是为什么

谢朵 · 谢朵

谢朵发表于 2023-5-25 19:00
我图里一个单元格的宽度为62。我的图片插入在F列，那应该是 5*62=310。但是我通过getCellRect获取到的x ...

为什么我通过getCellRect获取到的x总是跟我目标单元格差40

Clark.Pan · Clark.Pan

你看一下spread dom是不是跟window存在offset
参考一下这篇文章：
https://gcdn.grapecity.com.cn/showtopic-161998-1-1.html
getCellRact和hittest同理。

谢朵 · 谢朵

Clark.Pan 发表于 2023-5-26 11:35
你看一下spread dom是不是跟window存在offset
参考一下这篇文章：
https://gcdn.grapecity.com.cn/showto ...

我在使用 pictures.add(图片， id，x=401,y=799,width=56,height=56); 为什么到实际中他的xy没有在我设定的位置，我看了我的页面没有别的元素，spreadjs是定格的

		自动登录	找回密码
密码			立即注册

[已处理] 在合并过后的单元格插入多张图片，并使用startColumnOffset控制左偏移量不生效

12 个回复

讲师达人

悬赏达人

微信认证勋章

SpreadJS 认证

SpreadJS 高级认证

元老葡萄