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…
[MS-OVBA] V3 Signature Documentation?
Hi, in this blog entry and KB5000676 a new VBA project signature scheme 'V3 signature' is mentioned. However, it seems not to be documented in the currently available [MS-OVBA] - is there going to be a new version of [MS-OVBA] or is the 'V3…
Using negative values for effectExtent of a DrawingML object in Word
The OOXML standard specifies type ST_Coordinates as type of the attributes of the effectExtent element (§20.4.2.6). The type ST_Coordinates can have negative values, see §20.1.10.16, then ST_CoordinateUnqualified simple type (§20.1.10.19) or…
Why are the images not working for certain markers in this chart?
I have two documents - one where the image set in the chart.xml for the marker is showing in the chart (markers_show.docx), and one where its just showing the "automatic" marker (markers_dont_show.docx). In both charts, the c:marker node for…
Is there an OpenXML PDF that lists child nodes?
Hi all; I have the spec as the file c065533_ISO_IEC_29500-1_2016.pdf and unlike the previous spec, for each node, it does not list the child nodes with links to them. Is there a version of the spec that does have the child node lists & links? …
Confusing behaviour of Excel table style
Hi, I don't understand Excel's behaviour when viewing a document with a table. The table has a style: white background and orange text and borders. Cell A2 takes background color from the table style, but cell A3 overrides the table style…
21.2.2.128 order - is 0 top-most or bottom-most
Hi all; I'm trying to figure out how the c:lineChart/c:ser/c:order@Anonymous is applied. If you look at ATE-4988_topmost.docx the line chart with order=0 is top-most. But if you look at ATE-4988_bottommost.docx the line series with order=0 is…
Why we need applyFont or applyNumFmt?
I am confused about the attributes contained in xf. It seems it is unnecessary to use these attributes.
Marker settings in the style1.xml file
Hi all; In the chart1.xml a marker is defined as: <c:marker> <c:symbol val="square"/> <c:size val="5"/> <c:spPr> …