Documentation

@kanunilabs/pivotgrid-enterprise


@kanunilabs/pivotgrid-enterprise / drillDownCsv

Function: drillDownCsv()

drillDownCsv(columns, rows, format): string

RFC 4180 CSV.

\r joins React's quote set: a lone carriage return inside a value splits the row in Excel exactly as \n does.

And a leading =, +, -, @, tab or CR makes Excel treat the cell as a FORMULA — =cmd|… in a spreadsheet a colleague opens is a remote-execution prompt, not a data problem. Core's CSV writer already prefixes those with a quote (export.worker.ts sanitizeCsvInjection); this exporter did not, so the paid drill-down was the one CSV in the product that shipped them live.

Parameters

columns

readonly DrillDownColumn[]

rows

readonly Record<string, unknown>[]

format

DrillValueFormatter

Returns

string