InlineString vs String - what's the difference?

2

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")?

    
asked by anonymous 05.09.2016 / 18:20

1 answer

2

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>

Documentation .

    
05.09.2016 / 18:35