1.在有合并行的报表界面,在某单元格如C3中冻结列,如果合并行恰好包含第C列,如从A1合并到E1,则操作之后,界面会发生变化,如下图所示:
期望能像Excel一样,界面样式不发生变化。
Hello songyl
I want to clarify that the behavior you’re experiencing is the default behavior of the Webix Spreadsheet when rows and columns are frozen which can affect how styles are applied and merged.
参照WPS,冻结行列的时候,合并行内容会被截取掉,一块冻结,不影响表样格式。这个是技术上无法解决的吗?
The behavior you’ve observed is a special characteristic of the spreadsheet by design and is not something that can be resolved through technical adjustments.
也就意味着只要冻结行或者列,类似如上的表格样式肯定会调整。
冻结单元格之后,样式发生变化;取消冻结,样式不会恢复原样,这是个问题。
Hello,
Yes, as you correctly noted, in our Spreadsheet ( unlike in Excel ) after freezing a part of merged cells, the merged state ( and the styles ) will be applied only to the freezed columns, as in your screenshot . This is a limitation of the inner table used in Spreadsheet.
To return the state back, the user could press “Undo” button in the toolbar.
这个不太人性化,冻结行列是为了设计表样,如果撤销,则在冻结后改动的内容都会被撤销掉,那冻结行列其实是没有任何作用的。
Hello,
We compeletely understand your frustration, however, there is no ideal solution in this case.
I have passed your enquiry to the developers, but, unfortunately, I cannot promise you now that the existing limitations of the inner table’s functionality will be overcome in the future updates.