Microsoft Q&A
Office Open Specifications
93 questions
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.
Open Specifications: Technical documents for protocols, computer languages, standards support, and data portability. The goal with Open Specifications is to help developers open new opportunities to interoperate with Windows, SQL, Office, and SharePoint.
Content
Need information on SharePoint Metadata fields
Hi all, I'm needing some information regarding specific metadata available in SharePoint files/documents. Vti_replid, vti_rtag... etc I've gone through the protocol documentation but was unable to locate specific information about these fields. …


convert word document to pdf and render via office.com or web api
My organization uses Microsoft extensively, Sharepoint Online, Office 365, etc. I want a web application to render Word and Excel documents by converting to PDF. I read where a page at office.com can be opened, including the URL of a document, and it…


Clarification regarding ActionItemType for OneNote 2010 format
Hello! By MS-ONE every note tag has a property ActionItemType(paragraph 2.3.85). It is described as "an ActionItemType element (section 2.3.85) that specifies the identity of the note tag". We cannot understand what does it mean... For…
3D coordinate system orientation in Office Drawing Binary File Format
The Office Drawing Binary File Format has the attributes c3DKeyX, c3DKeyY, c3DKeyZ and c3DFillX, c3DFillY, c3DFillZ. How is the coordinate system orientated? Is it a right-hand or a left-hand system?


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,…

