【17.1.5】在设计器上拖拽行头以调整顺序时，设计器提示“无法完成此操作”

收藏

本帖最后由 Wilson.Zhang 于 2025-1-10 08:45 编辑

配置：
spread.options.allowDragHeaderToMove = GC.Spread.Sheets.AllowDragHeaderToMove.both;

报错：
image.png120365904.png

spread.options：
{"_ps":{"allowDragHeaderToMove":3,"allowUserDragDrop":true,"allowUserDragFill":false,"allowUserZoom":true,"allowUserResize":true,"allowUndo":true,"allowSheetReorder":true,"allowContextMenu":false,"allowUserDeselect":true,"defaultDragFillType":5,"showDragFillSmartTag":true,"showHorizontalScrollbar":true,"showVerticalScrollbar":true,"scrollbarShowMax":true,"scrollbarMaxAlign":true,"tabStripVisible":true,"tabStripRatio":0.5,"tabStripPosition":0,"tabStripWidth":80,"tabEditable":false,"newTabVisible":true,"allSheetsListVisible":2,"cutCopyIndicatorVisible":true,"cutCopyIndicatorBorderColor":"#217346","tabNavigationVisible":true,"backColor":"white","backgroundImage":null,"backgroundImageLayout":0,"showResizeTip":0,"showDragDropTip":true,"showDragFillTip":true,"scrollIgnoreHidden":false,"highlightInvalidData":false,"showScrollTip":0,"grayAreaBackColor":"#F4F8EB","useTouchLayout":false,"hideSelection":false,"resizeZeroIndicator":1,"allowUserEditFormula":true,"pivotAreaReference":1,"enableFormulaTextbox":true,"referenceStyle":0,"allowDynamicArray":false,"iterativeCalculation":true,"iterativeCalculationMaximumIterations":1000,"iterativeCalculationMaximumChange":0.01,"calcOnDemand":false,"incrementalCalculation":false,"dynamicReferences":true,"autoFitType":0,"allowCopyPasteExcelStyle":true,"allowExtendPasteRange":false,"copyPasteHeaderOptions":3,"calculationMode":0,"allowUserDragMerge":false,"rowResizeMode":0,"columnResizeMode":0,"scrollByPixel":false,"scrollPixel":5,"enableAccessibility":false,"allowAutoCreateHyperlink":true,"scrollbarAppearance":0,"font":null,"customList":[],"numbersFitMode":0,"pasteSkipInvisibleRange":false,"allowAutoExtendFilterRange":false,"allowInvalidFormula":false,"formulaFormatHint":true,"defaultSheetTabStyles":{},"builtInFileIcons":{},"dragHeaderMaskBackColor":null,"dragHeaderIndicatorColor":null},"allowDragHeaderToMove":3,"allowUserDragDrop":true,"allowUserDragFill":false,"allowUserZoom":true,"allowUserResize":true,"allowUndo":true,"allowSheetReorder":true,"allowContextMenu":false,"allowUserDeselect":true,"defaultDragFillType":5,"showDragFillSmartTag":true,"showHorizontalScrollbar":true,"showVerticalScrollbar":true,"scrollbarShowMax":true,"scrollbarMaxAlign":true,"tabStripVisible":true,"tabStripRatio":0.5,"tabStripPosition":0,"tabStripWidth":80,"tabEditable":false,"newTabVisible":true,"allSheetsListVisible":2,"cutCopyIndicatorVisible":true,"cutCopyIndicatorBorderColor":"#217346","tabNavigationVisible":true,"backColor":"white","backgroundImage":null,"backgroundImageLayout":0,"showResizeTip":0,"showDragDropTip":true,"showDragFillTip":true,"scrollIgnoreHidden":false,"highlightInvalidData":false,"showScrollTip":0,"grayAreaBackColor":"#F4F8EB","useTouchLayout":false,"hideSelection":false,"resizeZeroIndicator":1,"allowUserEditFormula":true,"pivotAreaReference":1,"enableFormulaTextbox":true,"referenceStyle":0,"allowDynamicArray":false,"iterativeCalculation":true,"iterativeCalculationMaximumIterations":1000,"iterativeCalculationMaximumChange":0.01,"calcOnDemand":false,"incrementalCalculation":false,"dynamicReferences":true,"autoFitType":0,"allowCopyPasteExcelStyle":true,"allowExtendPasteRange":false,"copyPasteHeaderOptions":3,"calculationMode":0,"allowUserDragMerge":false,"rowResizeMode":0,"columnResizeMode":0,"scrollByPixel":false,"scrollPixel":5,"enableAccessibility":false,"allowAutoCreateHyperlink":true,"scrollbarAppearance":0,"font":null,"customList":[],"numbersFitMode":0,"pasteSkipInvisibleRange":false,"allowAutoExtendFilterRange":false,"allowInvalidFormula":false,"formulaFormatHint":true,"defaultSheetTabStyles":{},"builtInFileIcons":{},"dragHeaderMaskBackColor":null,"dragHeaderIndicatorColor":null}

sheet.options：
{"_ps":{"rowHeaderVisible":true,"colHeaderVisible":true,"clipBoardOptions":0,"frozenlineColor":"black","rowHeaderAutoText":1,"colHeaderAutoText":2,"rowHeaderAutoTextIndex":-1,"colHeaderAutoTextIndex":-1,"allowCellOverflow":false,"showFormulas":false,"showZeros":true,"isProtected":true,"protectionOptions":{"allowResizeColumns":true,"allowResizeRows":true,"allowFilter":true,"allowSort":true},"gridline":{"color":"rgb(212, 212, 212)","showVerticalGridline":true,"showHorizontalGridline":true,"_color":"rgb(212, 212, 212)","_showHorizontalGridline":true,"_showVerticalGridline":true},"reversalTrailingResizeOrder":false,"keepUnknownFormulas":false,"addColumnButtonOption":{"visible":false,"width":null,"command":"gc.spread.contextMenu.insertColumns","style":null,"tooltip":null,"_visible":false,"_command":"gc.spread.contextMenu.insertColumns","_width":null,"_style":null,"_tooltip":null},"addRowButtonOption":{"visible":false,"height":null,"command":"gc.spread.contextMenu.insertRows","style":null,"tooltip":null,"_visible":false,"_command":"gc.spread.contextMenu.insertRows","_height":null,"_style":null,"_tooltip":null},"rightToLeft":false,"sheetAreaOffset":{"left":0,"top":0,"_left":0,"_top":0}},"rowHeaderVisible":true,"colHeaderVisible":true,"clipBoardOptions":0,"frozenlineColor":"black","rowHeaderAutoText":1,"colHeaderAutoText":2,"rowHeaderAutoTextIndex":-1,"colHeaderAutoTextIndex":-1,"allowCellOverflow":false,"showFormulas":false,"showZeros":true,"isProtected":true,"protectionOptions":{"allowResizeColumns":true,"allowResizeRows":true,"allowFilter":true,"allowSort":true},"gridline":{"color":"rgb(212, 212, 212)","showVerticalGridline":true,"showHorizontalGridline":true,"_color":"rgb(212, 212, 212)","_showHorizontalGridline":true,"_showVerticalGridline":true},"reversalTrailingResizeOrder":false,"keepUnknownFormulas":false,"addColumnButtonOption":{"visible":false,"width":null,"command":"gc.spread.contextMenu.insertColumns","style":null,"tooltip":null,"_visible":false,"_command":"gc.spread.contextMenu.insertColumns","_width":null,"_style":null,"_tooltip":null},"addRowButtonOption":{"visible":false,"height":null,"command":"gc.spread.contextMenu.insertRows","style":null,"tooltip":null,"_visible":false,"_command":"gc.spread.contextMenu.insertRows","_height":null,"_style":null,"_tooltip":null},"rightToLeft":false,"sheetAreaOffset":{"left":0,"top":0,"_left":0,"_top":0}}

Wilson.Zhang · Wilson.Zhang

您好！注意到您拖动的是Table中的行，提示信息也显示了无法拖动移动表格中的行或列，这里的“表格：指的是Table。

甘苦绿茶 · 甘苦绿茶

意思是，Table 呈现出的行，是不允许，也无法调整为 “可拖拽的”，是吗？

Wilson.Zhang · Wilson.Zhang

甘苦绿茶发表于 2025-1-10 10:05
意思是，Table 呈现出的行，是不允许，也无法调整为 “可拖拽的”，是吗？

当前的Table不支持选中行列移动，您可以选中Table某行剪切粘贴至Table中其他行，或者可以考虑您的场景是否可以在拖动移动结束后再使用Table。

Wilson.Zhang · Wilson.Zhang

您好！由于您较长时间未回复，且从跟帖回复中了解到问题已得到有效解答，那就结帖了。如有新问题，欢迎发新帖沟通。

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

[已处理] 【17.1.5】在设计器上拖拽行头以调整顺序时，设计器提示“无法完成此操作”

4 个回复