本文记录 WPS 的一个已知问题,如果在表格的单元格里面配置了 VerticalMerge 或 HorizontalMerge 为 false 值时,则在此单元格内的文本将被丢失。此行为与 Office 的 PowerPoint 不同,预计是 WPS 的坑
如以下核心代码,设置表格单元格的 VerticalMerge 和 HorizontalMerge 属性
A.TableCell tableCell1 = new A.TableCell();
// 加上这句话将导致 WPS 表格丢失文字
tableCell1.VerticalMerge = false;
A.TableCell tableCell2 = new A.TableCell();
// 加上这句话将导致 WPS 表格丢失文字
tableCell2.HorizontalMerge = false;
设置 VerticalMerge 和 HorizontalMerge 属性可以控制是否垂直和水平被合并,属于合并表格单元格的功能。设置为 false 代表当前表格单元格不被合并,十分合法,此方式生成的 PPTX 文件的 XML 内容如下
<a:tc vMerge="0">
...
</a:tc>
<a:tc hMerge="0">
...
</a:tc>
此文档将会让 WPS 打开之后,可以正常显示表格元素,但是丢失表格的对应单元格内的文本。如下图为我使用代码生成的文档,分别在 WPS 和 Office 的 PowerPoint 打开的效果
从上图可见 WPS 的表格的单元格内丢失了文本
默认从 Office 的 PowerPoint 创建的表格,如果表格单元格没有合并,是没有设置 VerticalMerge 和 HorizontalMerge 属性,这就意味着如果遇到 VerticalMerge 和 HorizontalMerge 属性被设置,那必定只有在设置为 true 的情况
以下为生成表格的代码
GraphicFrame GenerateGraphicFrame()
{
GraphicFrame graphicFrame1 = new GraphicFrame();
NonVisualGraphicFrameProperties nonVisualGraphicFrameProperties1 = new NonVisualGraphicFrameProperties();
NonVisualDrawingProperties nonVisualDrawingProperties1 = new NonVisualDrawingProperties() { Id = (UInt32Value) 5U, Name = "表格 1" };
A.NonVisualDrawingPropertiesExtensionList nonVisualDrawingPropertiesExtensionList1 = new A.NonVisualDrawingPropertiesExtensionList();
A.NonVisualDrawingPropertiesExtension nonVisualDrawingPropertiesExtension1 = new A.NonVisualDrawingPropertiesExtension() { Uri = "{FF2B5EF4-FFF2-40B4-BE49-F238E27FC236}" };
OpenXmlUnknownElement openXmlUnknownElement1 = OpenXmlUnknownElement.CreateOpenXmlUnknownElement("<a16:creationId xmlns:a16=\"http://schemas.microsoft.com/office/drawing/2014/main\" id=\"{CD17561D-9B93-D5E7-0F0D-87F8D105C682}\" />");
nonVisualDrawingPropertiesExtension1.Append(openXmlUnknownElement1);
nonVisualDrawingPropertiesExtensionList1.Append(nonVisualDrawingPropertiesExtension1);
nonVisualDrawingProperties1.Append(nonVisualDrawingPropertiesExtensionList1);
NonVisualGraphicFrameDrawingProperties nonVisualGraphicFrameDrawingProperties1 = new NonVisualGraphicFrameDrawingProperties();
A.GraphicFrameLocks graphicFrameLocks1 = new A.GraphicFrameLocks() { NoGrouping = true };
nonVisualGraphicFrameDrawingProperties1.Append(graphicFrameLocks1);
ApplicationNonVisualDrawingProperties applicationNonVisualDrawingProperties1 = new ApplicationNonVisualDrawingProperties();
ApplicationNonVisualDrawingPropertiesExtensionList applicationNonVisualDrawingPropertiesExtensionList1 = new ApplicationNonVisualDrawingPropertiesExtensionList();
ApplicationNonVisualDrawingPropertiesExtension applicationNonVisualDrawingPropertiesExtension1 = new ApplicationNonVisualDrawingPropertiesExtension() { Uri = "{D42A27DB-BD31-4B8C-83A1-F6EECF244321}" };
P14.ModificationId modificationId1 = new P14.ModificationId() { Val = (UInt32Value) 2563849206U };
modificationId1.AddNamespaceDeclaration("p14", "http://schemas.microsoft.com/office/powerpoint/2010/main");
applicationNonVisualDrawingPropertiesExtension1.Append(modificationId1);
applicationNonVisualDrawingPropertiesExtensionList1.Append(applicationNonVisualDrawingPropertiesExtension1);
applicationNonVisualDrawingProperties1.Append(applicationNonVisualDrawingPropertiesExtensionList1);
nonVisualGraphicFrameProperties1.Append(nonVisualDrawingProperties1);
nonVisualGraphicFrameProperties1.Append(nonVisualGraphicFrameDrawingProperties1);
nonVisualGraphicFrameProperties1.Append(applicationNonVisualDrawingProperties1);
Transform transform1 = new Transform();
A.Offset offset1 = new A.Offset() { X = 2032000L, Y = 719666L };
A.Extents extents1 = new A.Extents() { Cx = 7985458L, Cy = 731520L };
transform1.Append(offset1);
transform1.Append(extents1);
A.Graphic graphic1 = new A.Graphic();
A.GraphicData graphicData1 = new A.GraphicData() { Uri = "http://schemas.openxmlformats.org/drawingml/2006/table" };
A.Table table1 = new A.Table();
A.TableProperties tableProperties1 = new A.TableProperties() { FirstRow = true, BandRow = true };
A.TableStyleId tableStyleId1 = new A.TableStyleId();
tableStyleId1.Text = "{5C22544A-7EE6-4342-B048-85BDC9FD1C3A}";
tableProperties1.Append(tableStyleId1);
A.TableGrid tableGrid1 = new A.TableGrid();
A.GridColumn gridColumn1 = new A.GridColumn() { Width = 3992729L };
A.ExtensionList extensionList1 = new A.ExtensionList();
A.Extension extension1 = new A.Extension() { Uri = "{9D8B030D-6E8A-4147-A177-3AD203B41FA5}" };
OpenXmlUnknownElement openXmlUnknownElement2 = OpenXmlUnknownElement.CreateOpenXmlUnknownElement("<a16:colId xmlns:a16=\"http://schemas.microsoft.com/office/drawing/2014/main\" val=\"3797773054\" />");
extension1.Append(openXmlUnknownElement2);
extensionList1.Append(extension1);
gridColumn1.Append(extensionList1);
A.GridColumn gridColumn2 = new A.GridColumn() { Width = 3992729L };
A.ExtensionList extensionList2 = new A.ExtensionList();
A.Extension extension2 = new A.Extension() { Uri = "{9D8B030D-6E8A-4147-A177-3AD203B41FA5}" };
OpenXmlUnknownElement openXmlUnknownElement3 = OpenXmlUnknownElement.CreateOpenXmlUnknownElement("<a16:colId xmlns:a16=\"http://schemas.microsoft.com/office/drawing/2014/main\" val=\"3065667247\" />");
extension2.Append(openXmlUnknownElement3);
extensionList2.Append(extension2);
gridColumn2.Append(extensionList2);
tableGrid1.Append(gridColumn1);
tableGrid1.Append(gridColumn2);
A.TableRow tableRow1 = new A.TableRow() { Height = 295275L };
A.TableCell tableCell1 = new A.TableCell();
// 加上这句话将导致 WPS 表格丢失文字
tableCell1.VerticalMerge = false;
A.TextBody textBody1 = new A.TextBody();
A.BodyProperties bodyProperties1 = new A.BodyProperties();
A.ListStyle listStyle1 = new A.ListStyle();
A.Paragraph paragraph1 = new A.Paragraph();
A.Run run1 = new A.Run();
A.RunProperties runProperties1 = new A.RunProperties() { Language = "en-US", AlternativeLanguage = "zh-CN", Dirty = false };
A.Text text1 = new A.Text();
text1.Text = "1";
run1.Append(runProperties1);
run1.Append(text1);
A.EndParagraphRunProperties endParagraphRunProperties1 = new A.EndParagraphRunProperties() { Language = "zh-CN", AlternativeLanguage = "en-US", Dirty = false };
paragraph1.Append(run1);
paragraph1.Append(endParagraphRunProperties1);
textBody1.Append(bodyProperties1);
textBody1.Append(listStyle1);
textBody1.Append(paragraph1);
A.TableCellProperties tableCellProperties1 = new A.TableCellProperties();
tableCell1.Append(textBody1);
tableCell1.Append(tableCellProperties1);
A.TableCell tableCell2 = new A.TableCell();
// 加上这句话将导致 WPS 表格丢失文字
tableCell2.HorizontalMerge = false;
A.TextBody textBody2 = new A.TextBody();
A.BodyProperties bodyProperties2 = new A.BodyProperties();
A.ListStyle listStyle2 = new A.ListStyle();
A.Paragraph paragraph2 = new A.Paragraph();
A.Run run2 = new A.Run();
A.RunProperties runProperties2 = new A.RunProperties() { Language = "en-US", AlternativeLanguage = "zh-CN", Dirty = false };
A.Text text2 = new A.Text();
text2.Text = "2";
run2.Append(runProperties2);
run2.Append(text2);
A.EndParagraphRunProperties endParagraphRunProperties2 = new A.EndParagraphRunProperties() { Language = "zh-CN", AlternativeLanguage = "en-US", Dirty = false };
paragraph2.Append(run2);
paragraph2.Append(endParagraphRunProperties2);
textBody2.Append(bodyProperties2);
textBody2.Append(listStyle2);
textBody2.Append(paragraph2);
A.TableCellProperties tableCellProperties2 = new A.TableCellProperties();
tableCell2.Append(textBody2);
tableCell2.Append(tableCellProperties2);
A.ExtensionList extensionList3 = new A.ExtensionList();
A.Extension extension3 = new A.Extension() { Uri = "{0D108BD9-81ED-4DB2-BD59-A6C34878D82A}" };
OpenXmlUnknownElement openXmlUnknownElement4 = OpenXmlUnknownElement.CreateOpenXmlUnknownElement("<a16:rowId xmlns:a16=\"http://schemas.microsoft.com/office/drawing/2014/main\" val=\"3965977653\" />");
extension3.Append(openXmlUnknownElement4);
extensionList3.Append(extension3);
tableRow1.Append(tableCell1);
tableRow1.Append(tableCell2);
tableRow1.Append(extensionList3);
A.TableRow tableRow2 = new A.TableRow() { Height = 295275L };
A.TableCell tableCell3 = new A.TableCell();
A.TextBody textBody3 = new A.TextBody();
A.BodyProperties bodyProperties3 = new A.BodyProperties();
A.ListStyle listStyle3 = new A.ListStyle();
A.Paragraph paragraph3 = new A.Paragraph();
A.EndParagraphRunProperties endParagraphRunProperties3 = new A.EndParagraphRunProperties() { Language = "zh-CN", AlternativeLanguage = "en-US", Dirty = false };
paragraph3.Append(endParagraphRunProperties3);
textBody3.Append(bodyProperties3);
textBody3.Append(listStyle3);
textBody3.Append(paragraph3);
A.TableCellProperties tableCellProperties3 = new A.TableCellProperties();
tableCell3.Append(textBody3);
tableCell3.Append(tableCellProperties3);
A.TableCell tableCell4 = new A.TableCell();
A.TextBody textBody4 = new A.TextBody();
A.BodyProperties bodyProperties4 = new A.BodyProperties();
A.ListStyle listStyle4 = new A.ListStyle();
A.Paragraph paragraph4 = new A.Paragraph();
A.EndParagraphRunProperties endParagraphRunProperties4 = new A.EndParagraphRunProperties() { Language = "zh-CN", AlternativeLanguage = "en-US", Dirty = false };
paragraph4.Append(endParagraphRunProperties4);
textBody4.Append(bodyProperties4);
textBody4.Append(listStyle4);
textBody4.Append(paragraph4);
A.TableCellProperties tableCellProperties4 = new A.TableCellProperties();
tableCell4.Append(textBody4);
tableCell4.Append(tableCellProperties4);
A.ExtensionList extensionList4 = new A.ExtensionList();
A.Extension extension4 = new A.Extension() { Uri = "{0D108BD9-81ED-4DB2-BD59-A6C34878D82A}" };
OpenXmlUnknownElement openXmlUnknownElement5 = OpenXmlUnknownElement.CreateOpenXmlUnknownElement("<a16:rowId xmlns:a16=\"http://schemas.microsoft.com/office/drawing/2014/main\" val=\"1863066117\" />");
extension4.Append(openXmlUnknownElement5);
extensionList4.Append(extension4);
tableRow2.Append(tableCell3);
tableRow2.Append(tableCell4);
tableRow2.Append(extensionList4);
table1.Append(tableProperties1);
table1.Append(tableGrid1);
table1.Append(tableRow1);
table1.Append(tableRow2);
graphicData1.Append(table1);
graphic1.Append(graphicData1);
graphicFrame1.Append(nonVisualGraphicFrameProperties1);
graphicFrame1.Append(transform1);
graphicFrame1.Append(graphic1);
return graphicFrame1;
}
本文代码放在 github 和 gitee 上,可以使用如下命令行拉取代码
先创建一个空文件夹,接着使用命令行 cd 命令进入此空文件夹,在命令行里面输入以下代码,即可获取到本文的代码
git init
git remote add origin https://gitee.com/lindexi/lindexi_gd.git
git pull origin efc266895387df74a107c584d2de84ac08c60ec1
以上使用的是 gitee 的源,如果 gitee 不能访问,请替换为 github 的源。请在命令行继续输入以下代码,将 gitee 源换成 github 源进行拉取代码
git remote remove origin
git remote add origin https://github.com/lindexi/lindexi_gd.git
git pull origin efc266895387df74a107c584d2de84ac08c60ec1
获取代码之后,进入 Pptx/JufokawnelWhelkefeeqayje 文件夹,即可获取到源代码
本文会经常更新,请阅读原文: https://blog.lindexi.com/post/dotnet-OpenXML-%E5%9C%A8-PPTX-%E8%A1%A8%E6%A0%BC%E5%8D%95%E5%85%83%E6%A0%BC%E5%8A%A0%E4%B8%8A-VerticalMerge-%E6%88%96-HorizontalMerge-%E5%B0%86%E5%AF%BC%E8%87%B4-WPS-%E4%B8%A2%E5%A4%B1%E6%96%87%E6%9C%AC.html ,以避免陈旧错误知识的误导,同时有更好的阅读体验。
如果你想持续阅读我的最新博客,请点击 RSS 订阅,推荐使用RSS Stalker订阅博客,或者收藏我的博客导航
本作品采用 知识共享署名-非商业性使用-相同方式共享 4.0 国际许可协议 进行许可。欢迎转载、使用、重新发布,但务必保留文章署名林德熙(包含链接: https://blog.lindexi.com ),不得用于商业目的,基于本文修改后的作品务必以相同的许可发布。如有任何疑问,请 与我联系 。
无盈利,不卖课,做纯粹的技术博客
以下是广告时间
推荐关注 Edi.Wang 的公众号
欢迎进入 Eleven 老师组建的 .NET 社区
以上广告全是友情推广,无盈利