SpreadJS 剪切单元格之后插入单元格报错

Joestar.Xu · Joestar.Xu

BattleHawk76 发表于 2023-12-6 11:15
好像不支持上传vue文件

您这边把文件放在一个压缩包里再上传试试。

BattleHawk76 · BattleHawk76

index.zip (3.97 KB, 下载次数: 1)

BattleHawk76 · BattleHawk76

BattleHawk76 发表于 2023-12-6 15:20

[
{
title: "货代编号",
dataKey: "freightForwarderNo",
width: 100,
},
{
title: "货代名称",
dataKey: "freightForwarderName",
width: 100,
},
{
title: "货代情况",
dataKey: "freightForwarderSituation",
width: 100,
},
{
title: "用到箱数",
dataKey: "boxesNum",
width: 100,
},
{
title: "货件号",
dataKey: "shipmentNo",
width: 100,
},
{
title: "追踪码",
dataKey: "trackingCode",
width: 100,
},
{
title: "周期",
dataKey: "cycle",
width: 100,
},
{
title: "接收数量",
dataKey: "receivedNum",
width: 100,
},
{
title: "仓库编码",
dataKey: "warehouseCode",
width: 120,
},
{
title: "类别",
dataKey: "code",
width: 200,
enterFun: (scope) => {
searchDetailByCode(scope.row.code, "code", scope.rowIndex);
choseTableRow.value = scope.row;
editCabinetRowIndex.value = null;
},
},
{
title: "商品名称",
dataKey: "productName",
width: 200,
enterFun: (scope) => {
searchDetailByCode(scope.row.productName, "productName", scope.rowIndex);
choseTableRow.value = scope.row;
editCabinetRowIndex.value = null;
},
},
{
title: "asin",
dataKey: "asin",
width: 100,
},
{
title: "欧洲备注",
dataKey: "europeRemark",
width: 100,
},
{
title: "SKU",
dataKey: "sku",
width: 150,
enterFun: (scope) => {
searchDetailBySku(scope.row, scope.rowIndex);
choseTableRow.value = scope.row;
editCabinetRowIndex.value = null;
},
},
{
title: "装数",
dataKey: "packagesNum",
width: 100,
},
{
title: "备注",
dataKey: "remark",
width: 100,
},
{
title: "特殊配件",
dataKey: "specialAccessories",
width: 100,
},
{
title: "件数",
dataKey: "num",
width: 100,
value: (item) => {
return proxy.lodash.round(
proxy.lodash.divide(item.totalBoxes, item.perBoxBoxesNum),
10
);
},
},
{
title: "每箱盒数",
dataKey: "perBoxBoxesNum",
width: 100,
},
{
title: "总盒数",
dataKey: "totalBoxes",
width: 100,
},
{
title: "内盒尺寸(cm)",
dataKey: "innerSizeCm",
width: 150,
},
{
title: "外盒尺寸(cm)",
dataKey: "outsideSizeCm",
width: 150,
},
{
title: "总只数",
dataKey: "totalNum",
width: 100,
value: (item) => {
return proxy.lodash.round(
proxy.lodash.multiply(item.packagesNum, item.totalBoxes),
10
);
},
},
{
title: "库存数量",
dataKey: "inventory",
width: 100,
onlyShow: true,
},
{
title: "每箱重量",
dataKey: "boxWeightKg",
width: 100,
},
{
title: "总重",
dataKey: "totalWeight",
width: 100,
value: (item) => {
return proxy.lodash.round(
proxy.lodash.multiply(item.num, item.boxWeightKg),
10
);
},
},
{
title: "体积重单件",
dataKey: "volume",
width: 100,
},
{
title: "总体积",
dataKey: "totalVolume",
width: 100,
value: (item) => {
return proxy.lodash.round(
proxy.lodash.multiply(item.num, item.volume),
10
);
},
},
{
title: "单价",
dataKey: "price",
width: 100,
},
{
title: "总额",
dataKey: "total",
width: 100,
value: (item) => {
return proxy.lodash.round(
proxy.lodash.multiply(
item.price,
proxy.lodash.multiply(item.packagesNum, item.totalBoxes)
),
10
);
},
},
{
title: "我们发货时间",
dataKey: "deliveryTime",
width: 180,
type: "datetime",
},
{
title: "货代发货日期",
dataKey: "freightForwarderDate",
width: 180,
type: "datetime",
},
{
title: "天数",
dataKey: "days",
width: 100,
},
{
title: "到仓时间",
dataKey: "arrivalTime",
width: 180,
type: "datetime",
},
{
title: "实际到仓日期",
dataKey: "actualArrivalTime",
width: 180,
type: "datetime",
},
{
title: "报价",
dataKey: "offer",
width: 100,
},
{
title: "重量",
dataKey: "weight",
width: 100,
},
{
title: "总价",
dataKey: "totalPrice",
width: 100,
},
{
title: "单号",
dataKey: "encode",
width: 100,
},
{
title: "备注2",
dataKey: "remark2",
width: 100,
},
// {
// title: "规格名称",
// dataKey: "specName",
// width: 200,
// },
{
title: "已开单",
dataKey: "completeNum",
width: 100,
value: (item) => {
return item.completeNum || 0;
},
},
{
title: "未开单",
dataKey: "unfinishedNum",
width: 100,
value: (item) => {
return (
proxy.lodash.round(
proxy.lodash.subtract(
item.num ||
proxy.lodash.round(
proxy.lodash.divide(item.totalBoxes, item.perBoxBoxesNum),
10
),
item.completeNum
),
10
) || 0
);
},
},
{
title: "每盒重量",
dataKey: "innerWeightKg",
width: 100,
},
// {
// title: "缺口数量",
// dataKey: "gapNum",
// width: 100,
// },
{
title: "装柜",
dataKey: "cabinetName",
width: 70,
fixed: "right",
onlyShow: true,
},
{
title: "包装小组",
dataKey: "packingTeamName",
width: 180,
fixed: "right",
onlyShow: true,
h: ({ scope }) => {
return h(VSelect, {
modelValue: scope.row.packingTeamId,
items: packingGroupList.value,
density: "compact",
itemTitle: "deptName",
itemValue: "id",
clearable: true,
style: {
width: "180px",
height: "20px",
},
menuProps: {
attach: "#gcEditingInput",
},
"onUpdate:modelValue": (e) => {
scope.row.packingTeamId = e;
scope.row.packingTeamName = proxy.lodash.find(
packingGroupList.value,
(item) => {
return item.id == e;
}
)?.deptName;
},
"onClick:clear": () => {
scope.row.packingTeamId = null;
scope.row.packingTeamName = null;
},
});
},
},
// {
// title: "操作",
// width: 200,
// fixed: "right",
// cellRenderer: (row) => {
// return h("div", {}, [
// h(
// ElButton,
// {
// type: "danger",
// onclick: () => {
// row.rowData.cabinetName = null;
// row.rowData.cabinetId = null;
// },
// disabled: !row.rowData.id,
// size: "small",
// },
// "删除装柜"
// ),
// h(
// ElButton,
// {
// type: "success",
// onclick: () => {
// handleAddOrEditCabinet("edit", row.rowData, "out");
// },
// disabled: !row.rowData.id,
// size: "small",
// },
// "分配装柜"
// ),
// ]);
// },
// },
]

复制代码

Joestar.Xu · Joestar.Xu

您好，我看了一下您的代码，如果要监听行剪切事件的话，直接监听RowChanged即可：

参考链接：https://demo.grapecity.com.cn/sp ... s.Events#rowchanged

TableRowsChanged是用于监听表格的行变动事件的，所以不会触发。

另外关于英文的问题，您这边检查一下您有没有引入中文资源，然后要设置下面这行代码才可以：

GC.Spread.Common.CultureManager.culture("zh-cn");

如：

image.png865343322.png

错位的问题我这边没有办法运行所以没有复现出来，可能是样式导致的问题，方便的话还是提供一个可以复现问题的Demo，我们这边复现后调研一下。

BattleHawk76 · BattleHawk76

Joestar.Xu 发表于 2023-12-6 17:55
您好，我看了一下您的代码，如果要监听行剪切事件的话，直接监听RowChanged即可：

参考链接：https://de ...

中文可以了.
但是剪切插入还是会卡.
剪切插入RowChanged也不会触发

AlexZ · AlexZ

错位的问题，请检查是否有 CSS 冲突

剪切插入会卡

剪切的行数有多少？是否在筛选状态下？

是否尝试过挂起事件、计算和脏数据

参考：https://demo.grapecity.com.cn/spreadjs/help/docs/BestPractices

BattleHawk76 · BattleHawk76

AlexZ 发表于 2023-12-7 00:28
错位的问题，请检查是否有 CSS 冲突

剪切的行数有多少？是否在筛选状态下？

剪切的行数不多.没有在筛选状态下使用.
但是总数据有900多条.
我想尝试挂起事件.但是不知道该在什么时候去挂起

Joestar.Xu · Joestar.Xu

BattleHawk76 发表于 2023-12-6 21:04
中文可以了.
但是剪切插入还是会卡.
剪切插入RowChanged也不会触发

抱歉之前误解您的意思了，如果是要通过剪切来插入行的话，需要您监听ClipboardPasted事件来实现，请参考：https://demo.grapecity.com.cn/sp ... nts#clipboardpasted

根据您描述的卡顿问题，您可以尝试在ClipboardPasting事件中执行suspend和resume的操作来提高性能，如仍无法解决您的问题，请您提供一个可以复现您问题的Demo，这边复现后调研一下看看是什么原因导致的问题。