There are important files that Microsoft projects should all have that are not present in this repository. A pull request has been opened to add the missing file(s). When the pr is merged this issue will be closed automatically.

Microsoft teams can learn more about this effort and share feedback within the open source guidance available internally.

Merge this pull request

Current code will fail in different scenarios. One of them: A1, B1, AD1 are existing cells while we are trying to insert C1. I recommend to update code as follows.

This part:

Cell refCell = null;
        foreach (Cell cell in row.Elements<Cell>())
        {
            if (cell.CellReference.Value.Length, == cellReference.Length)
            {
              if (string.Compare(cell.CellReference.Value, cellReference, true) > 0)
              {
                refCell = cell;
                break;
              }
            }
        }

should be replaced by this part:

Cell refCell = null;
			foreach (var cell in row.Elements<Cell>())
			{
				if ((cell.CellReference.Value.Length == cellReference.Length && string.Compare(cell.CellReference.Value, cellReference, StringComparison.OrdinalIgnoreCase) > 0)
					|| cell.CellReference.Value.Length > cellReference.Length)
				{
					refCell = cell;
					break;
				}
			}

Looking over: https://msdn.microsoft.com/en-us/library/office/gg278316.aspx#MinWBScenario

I am struck by how different this article is from an actual minimal Excel file. For instance...

[Content Types].xml is not mentioned
the xl subfolder is not mentioned
the separation in the worksheets and _rels and similar is not mentioned
etc.

I realize that this article is about OpenXML, and that one can organize the output as they see fit. But given that Excel is the canonical example of SpreadsheetML, it seems some discussion based on real-world examples would be useful.

There is a bug in the sample code for writing a cell to an Excel worksheet. Using this code with a spreadsheet larger than 26 columns causes file corruption. I have detailed the issue and my fix in this Stack Overflow question.

In the following article:
https://github.com/OfficeDev/office-content/blob/master/en-us/OpenXMLCon/articles/15e26fbd-fc23-466a-a7cc-b7584ba8f821.md

The sample implementation for GetCellValue does not handle formulas correctly. Strictly speaking, it is mishandling "values" (due the implementation of InnerText providing the concat of all inner text).

The issue occurs with the following steps (Using Office 2003):

1. Put any text into cell A1 (e.g. "exampletext")
2. Enter into cell A2 "=A1" (with out quotes)
3. Save, then run the sample code on the workbook and retrieve the value for A2

The above scenario will create sheet data as follows (formatted for readability, only relevant sections included)

<sheetData>
    <row r="1" spans="1:1">
      <c r="A1" t="s">
        <v>0</v>
      </c>
    </row>
    <row r="2" spans="1:1">
      <c r="A2" t="str">
        <f>A1</f>
        <v>exampletext</v>
      </c>
    </row>
  </sheetData>

(The above sheetdata A1 references the shared string table with index 0, which will result in the string "exampletext")

The problem occurs on the following line of code.

value = theCell.InnerText; // value is "A1exampletext" instead of just "exampletext" or "A1"

Instead, the sample should really reference the value or formula directly

if (theCell.CellValue != null) value = theCell.CellValue.Text;
else if (theCell.CellFormula != null) value = theCell.CellFormula.Text;
else value = theCell.InnerText;//only use this as a final fallback if all else fails

Alas my understanding of the Open xml spec is limited and I'm unsure of what other potential issues could occur due to the implementation of InnerText (e.g. inner string + value?)

Hi Team.
The given code is only creating a PPTX file only under document directory when used with visual studio 2017 and Power point 2017. But code is unable to add the slide to pptx file. Please check for once. If possible then Please upload a code which can works with visual studio 2017 and Powerpoint 2017 .

While reading a text like this: Found promising wins at Mphasis and Niranjan Chinoy:

Because Mphasis and Niranjan Chinoy are not recognized by English dictionary, the read of this sentence is split into 4 as:
Found promising wins at
Mphasis
and
Niranjan Chinoy

Is there a way spelling check can be ignored?

I paste pictures into word document. And the pictures can't be recognized by OpenXml SDK.
Inside my docx file, I found some abnormal structure:

w:r>
<w:p xmlns:m="http://schemas.openxmlformats.org/officeDocument/2006/math" xmlns:wp="http://schemas.openxmlformats.org/drawingml/2006/wordprocessingDrawing">
<w:r>
<w:drawing>
<wp:anchor distT="0" distB="0" distL="114300" distR="114300" simplePos="0" relativeHeight="251658240" behindDoc="0" locked="0" layoutInCell="1" allowOverlap="1">
<wp:simplePos x="0" y="0"/>
<wp:positionH relativeFrom="column">
<wp:align>center</wp:align>
</wp:positionH>
<wp:positionV relativeFrom="paragraph">
<wp:posOffset>2540</wp:posOffset>
</wp:positionV>
<wp:extent cx="5352176" cy="1837188"/>
<wp:wrapTopAndBottom/>
<wp:docPr id="9" name="media/GIUACAFYtDB.png"/>
<a:graphic xmlns:a="http://schemas.openxmlformats.org/drawingml/2006/main">
<a:graphicData uri="http://schemas.openxmlformats.org/drawingml/2006/picture">
<pic:pic xmlns:pic="http://schemas.openxmlformats.org/drawingml/2006/picture">
<pic:nvPicPr>
<pic:cNvPr id="0" name="media/GIUACAFYtDB.png"/>
<pic:cNvPicPr/>
</pic:nvPicPr>
<pic:blipFill>
<a:blip r:embed="rId9"/>
<a:stretch>
<a:fillRect/>
</a:stretch>
</pic:blipFill>
<pic:spPr>
<a:xfrm>
<a:off x="0" y="0"/>
<a:ext cx="5352176" cy="1837188"/>
</a:xfrm>
<a:prstGeom prst="rect"/>
</pic:spPr>
</pic:pic>
</a:graphicData>
</a:graphic>
</wp:anchor>
</w:drawing>
</w:r>
</w:p>
</w:r>

A paragraph with picture is inside a run. Can I read the picture using OpenXml SDK in such condition?

Hi,

I have another problem about SigninManager. when I login in like this;

[email protected]

abdc.com is reachable. but If I write wrong domain for example; [email protected] (which domain name is nonexist) I am not getting a response and my application is waiting. nothing happens. here is my sample code;

setting include username, password, domain information.

function doLogin(settings) {
return new Promise((resolve, reject) => {
window.skypeWebSDKApi.signInManager.signIn(settings).then((response) => {
resolve(response);
}, (error) => {
reject(error);
}).catch(reject);
});
}

what is the problem? what do you think?

When I use OpenXML to read the date field, it returns added number value. It comes up as 42454 instead of 03/25/2016.

This document appears to contradict itself when describing the minimum contents of a workbook.

In the "minimum workbook scenario" section, the minimum workbook is said to consist of:

A single sheet
A sheet ID
A relationship Id that points to the location of the sheet definition

However, in the "Generated SpreadsheetML" section, which is generated from code that purports to create such a minimal book, the diagram shows...

folder
workbook.xml
sheet.xml

If a workbook.xml is required, why is that not mentioned in the "minimum workbook scenario"? I believe the first part is referring to the object structure and the later to the files that represent that structure, but if this is the case it should really make that very clear.

Then a few lines later it says "The workbook.xml.rels file"... which is previously not mentioned. This file does not appear in the image of the minimal workbook. Is this file actually required? And am I correct in thinking the data earlier referred to as "A relationship Id" is stored in this .rels file?

Generally, I think it would make this document much easier to understand if the relationship between the concepts at the top and the actual files further down was clearly defined.

there is "{28A0092B-C50C-407E-A947-70E740481C1C}" what does it mean? And next Uri = "http://schemas.openxmlformats.org/drawingml/2006/picture" this url does not work, why we should use this? And next EditId = "50D07946" what Id it is?

The code of How to: Remove hidden text from a word processing document doesn't work on my computer.

Unhandled Exception: System.IO.IOException: Entries cannot be opened multiple times in Update mode.
   at System.IO.Compression.ZipArchiveEntry.OpenInUpdateMode()
   at System.IO.Compression.ZipArchiveEntry.Open()
   at System.IO.Packaging.ZipStreamManager.Open(ZipArchiveEntry zipArchiveEntry, FileMode streamFileMode, FileAccess streamFileAccess)
   at System.IO.Packaging.ZipPackagePart.GetStreamCore(FileMode streamFileMode, FileAccess streamFileAccess)
   at System.IO.Packaging.PackagePart.GetStream(FileMode mode, FileAccess access)
   at delete_hidden_text.Program.WDDeleteHiddenText(String docName) in /home/xxx/Documents/xxx/delete_hidden_text/Program.cs:line 47
   at delete_hidden_text.Program.Main(String[] args) in /home/xxx/Documents/xxx/delete_hidden_text/Program.cs:line 14