In creating some spreadsheets with OpenXML, I came to doubt the difference between:
-
CellValues.InlineString
-
CellValues.String
Is there any practical difference at the time of inserting texts (eg "hello world", "stackoverflow")?
In creating some spreadsheets with OpenXML, I came to doubt the difference between:
CellValues.InlineString
CellValues.String
Is there any practical difference at the time of inserting texts (eg "hello world", "stackoverflow")?
I found a answer in SO that speaks of this:
CellValues.String
Used to store the text of the formula used in the cell. The XML would look like:
<x:c r="C6" s="1" vm="15" t="str">
<x:f>CUBEVALUE("xlextdat9 Adventure Works",C$5,$A6)</x:f>
<x:v>2838512.355</x:v>
</x:c>
CellValues.InlineString
Used to store formatted text in the cell as opposed to being the cell code. Note that the normal would be to use SharedStringTable
for this. The XML would look like:
<x:c r="B2" t="inlineStr">
<is><t>test string</t></is>
</c>