How PowerPoint 3D engine calculate scaling factor of 3D models (am3d:meterPerModelUnit)
I want to add some 3D models into PowerPoint presentation using OpenXML and C#, in order to generate proper XML tags, I drag GLB files into an empty presentation, then extract its XML contents. There are so many parameters with am3d tag, and I know about…
Diagnosing Invalid XLSX
Hi, Our software generated an xlsx. Trying to open it in excel results in an error and Excel offers to repair the file, and the repaired file appears to be fine. The repair log indicates that the problem was something in sheet3.xml, so I tried…
Is there a way to remove the washout feature of Microsoft Word watermark?
When adding a watermark to the header of the word document, it automatically adds opacity to it. I want to remove that opacity and upon checking on the Microsoft Word itself, I found out that it can be removed by unchecking the Washout option. Can this…
MS-OVBA - V3 Content Normalized Data
Hi! I am to implement the V3 Content Normalized Data function. When appending the buffer of the references the algorithm says: IF next USHORT = REFERENCENAME.Id THEN ... END IF IF next USHORT = REFERENCENAME.Reserved THEN ... END IF …
How to convert an csv sheet to excel(.xlsx) sheet using openxml??
Any code available for conversion of csv sheet to excel(.xlsx) sheet using openxml??
OpenXml get page number to which each paragraph
I have a Word docx file and I want to retrieve all the paragraphs in OpenXml with c#. I need to know: 1.-The number of pages of the Documents. 2.-The page number to which each paragraph belongs. Can you show an example where the paragraphs of the…
MS Office Online document editing in Web Application with documents stored in File System
Hello, I am looking for MS Office Word document editing solution in the web browser for one of my ASP.net application where the documents are stored on the File System. The requirement is to View, edit the document in Web Browser that are…
correct treatment of von-part in Word bibliography
I was directed here from this thread: https://answers.microsoft.com/en-us/msoffice/forum/all/correct-treatment-of-middle-name/d617e3a7-a5ff-4af3-95f7-dda49f33e5c7?messageId=ff78cc88-b9eb-4338-80b6-9a0eed447d9e According to the Microsoft answer, I…
Co-authoring with desktop Office & custom cloud storage
Hello, I'm investigating possibility to give users ability of co-editing documents stored on the custom storage server. Server already can work with Office Online (via WOPI) also we have VSTO add-in that can open/save documents from/to server via REST…
Why do these documents have different data label separators?
I have a doughnut chart with the data label separator set to New Line. This shows up in chart1.xml under /c:ser/c:dLbls: However, in another document I have the same xml, but the data labels separator shows as Comma. Here are…
Why is this patternType showing as solid instead of none?
This excel file (https://windwardstudios.box.com/s/t1mh7xlgwlwni3b4j6l8x986ymiqvsf1) has a conditional formatting rule that adds a light red background. In xl/worksheets/sheet2.xml, I can see that the dxfId of the cfRule is "1" …
unit for coordinates of points in wrapPolygon
Hi, the OOXML standard specifies for the wrapPolygon element (§20.4.2.16) the type CT_WrapPath. It is a sequence of one element "start" and at least two elements "lineTo". These have the type CT_Point2D. That has the attributes…
EXCEL REPAIR
<?xml version="1.0" encoding="UTF-8" standalone="true"?> -<recoveryLog xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main"> <logFileName>error031120_01.xml</logFileName> …
How is font determined with no font declaration?
Hello, I have a question regarding how the font is determined in the document.xml file. In the word template there is a content control checkbox with a Wingdings checkmark as the marker. After the checkbox is just simple test with the font Trebuchet MS…
Automatically autofit row heights for columns where the text wraps when loading an Excel sheet?
I am creating an Excel sheet with the python openpyxl library (which is extremely cool and useful). The sheet contains two columns of some fixed, preset width which contains text. The format of these columns is set to auto-wrap, so if the text is longer…
WOPI unlock call | PutFile call delay - never gets triggered in chrome and latest edge browser - Fixed with OOS 2021 June 3 Security Patch
This is a known issue where Chrome is deprecating Sync XHR on Oct 22 2019, affecting WAC's ability to unlock file and shutdown gracefully. At this time, no timeline when a fix will be ready. Per Chrome,…
Why are styles for the table first row being applied to additional rows?
I have 2 documents a template and then a document where data has been applied and generated. The issue is that there is a table with the the firstRow style having bold in it and then all additional rows are not bolded. This is correct in the template. …
Open XML SDK: AddMediaReferenceRelationship and AddVideoReferenceRelationship in Open XML Version 2.13.0 and Open XML Version 2.12.3
The code is run, both in version 2.13.0 and 2.12.3 Sample Code: MediaDataPart mediaDataPart1 = document.CreateMediaDataPart("video/mp4", ".mp4"); System.IO.Stream mediaDataPart1Stream =…
Clarification regarding PageMarginOriginX/PageMarginOriginY for OneNote 2010 format
Hello! In MS-ONE the properties PageMarginOriginX/PageMarginOriginY are described in chapters 2.3.59/2.3.60. These properties affect the rendering of a page. Now we interpret them as following: If we process TitleNode then we don't use these…
Converting from OneNote 2010 format to input/output html and vice versa
Hello! Microsoft provides cloud version of OneNote. The same document could be retrieved from this service in the following ways: As a *.one file from OneDrive web interface. As an html document via MS Graph API. The retrieved…