ValueOnly option truncating break xml about xlsx HOT 3 CLOSED

Origin xml

<row r="3" spans="4:8">
<c r="D3" s="26" t="s"><v>2189</v></c>
<c r="E3" s="26" t="str"><f t="shared" si="0"/><v>sometext</v></c>
<c r="G3" s="26" t="s"><v>2186</v></c>
<c r="H3" s="26" t="s"><v>2190</v></c>
</row>

After truncateSheetXMLValueOnly

<row r="3" spans="4:8">
<c r="D3" s="26" t="s"><v>2189</v></c>
<v>sometext</v></c>
<c r="G3" s="26" t="s"><v>2186</v></c>
<c r="H3" s="26" t="s"><v>2190</v></c>
</row>

It seems that the bug was wrong regex in

It's matched with the tag f

from xlsx.

regex can be change to
(?s)<c [^>]*?/[>|c>]

from xlsx.

btw, func truncateSheetXMLValueOnly was quite low efficiency because replace iteration by row and cell.

the logic was detecting rows or cells without value (v tag), why we just using regex to matched them, and replace all

It tasks 20 second on my mac to truncate a xml with 100,0000 rows

from xlsx.