Celly
Board Regular
- Joined
- Jan 29, 2015
- Messages
- 84
- Office Version
- 2016
- Platform
- Windows
Hello!
This may seem odd but I'm getting into the nitty gritty of Open Office XML (OOXML) and have a question. I'm looking at one of the sheet xml files under xl/worksheets/. I see a lot of churn on these "s" attributes on cell elements. Here is an XML fragment:
<sheetData>
<row r="3" spans="1:16" x14ac:dyDescent="0.25">
<c r="E3" s="286" t="s">
<v>839</v>
</c>
</row>
</sheetData>
So this is cell E3 which has a value of 839. I get that part, but what is the s="286" element? These "s" elements move up or down in small increments when a workbook is saved, even if no changes are made. I could sift through the OOXML specification but I'm not intimately familiar with it. Any ideas?
This may seem odd but I'm getting into the nitty gritty of Open Office XML (OOXML) and have a question. I'm looking at one of the sheet xml files under xl/worksheets/. I see a lot of churn on these "s" attributes on cell elements. Here is an XML fragment:
<sheetData>
<row r="3" spans="1:16" x14ac:dyDescent="0.25">
<c r="E3" s="286" t="s">
<v>839</v>
</c>
</row>
</sheetData>
So this is cell E3 which has a value of 839. I get that part, but what is the s="286" element? These "s" elements move up or down in small increments when a workbook is saved, even if no changes are made. I could sift through the OOXML specification but I'm not intimately familiar with it. Any ideas?