<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<title></title>
</head>
<body>
<div name="messageBodySection">
<div dir="auto"><span style="font-size: 13px">Excel limitations, see </span><a href="https://support.microsoft.com/en-us/office/excel-specifications-and-limits-1672b34d-7043-467e-8e27-269d656771c3" target="_blank">https://support.microsoft.com/en-us/office/excel-specifications-and-limits-1672b34d-7043-467e-8e27-269d656771c3</a><br>
<br>
ODS: <a href="https://wiki.openoffice.org/wiki/Documentation/FAQ/Calc/Miscellaneous/What%27s_the_maximum_number_of_rows_and_cells_for_a_spreadsheet_file%3F" target="_blank">https://wiki.openoffice.org/wiki/Documentation/FAQ/Calc/Miscellaneous/What%27s_the_maximum_number_of_rows_and_cells_for_a_spreadsheet_file%3F</a></div>
</div>
<div name="messageSignatureSection"><br>
<div class="matchFont">Hälsningar<br>
<br>
Andreas Oxenstierna<br>
T-Kartor Geospatial AB<br>
Olof Mohlins väg 12 Kristianstad<br>
mobile: +46 733 206831<br>
mailto: <a href="mailto:andreas.oxenstierna@t-kartor.com">andreas.oxenstierna@t-kartor.com</a><br>
<a href="http://www.t-kartor.com">www.t-kartor.com</a></div>
</div>
<div name="messageReplySection">On 10 Jan 2022, 11:42 +0100, Even Rouault <even.rouault@spatialys.com>, wrote:<br>
<blockquote type="cite" style="border-left-color: grey; border-left-width: thin; border-left-style: solid; margin: 5px 5px;padding-left: 10px;">
<p>Marta,</p>
<p>What is the bug exactly ?<br>
</p>
<p>"2 billion records" : by record, you mean cells, like a sheet with 2048 columns and 1048576 rows ? By quickly looking at the code I can't see an obvious limitation, but that doesn't mean anything. Closer investigation would be needed. Please file an issue
at <a class="moz-txt-link-freetext" href="https://github.com/OSGeo/gdal/issues/new">
https://github.com/OSGeo/gdal/issues/new</a> with exact details how to reproduce (number of rows/features, and columns/fields in particular).<br>
</p>
<p>But even if the writer side would work, the OGR reader side would probably have issues as the whole spreadsheet will be loaded into RAM and for 2 billion cells, I would expect at least 32 or more GB of RAM to be needed. Perhaps spreadsheet software are able
to cope with that in a smarter way.<br>
</p>
<p>Even<br>
</p>
<div class="moz-cite-prefix">Le 10/01/2022 à 11:27, Kopszak Marta - Partner Hurt a écrit :<br>
</div>
<blockquote type="cite" cite="mid:df5f49efbe3644ce9883b2f9ab065a0b@orange.com">
<meta name="Generator" content="Microsoft Word 15 (filtered medium)">
<div class="WordSection1">
<p class="MsoNormal">Dear Sirs,</p>
<p class="MsoNormal">I ran into an error when exporting data through the OGR library to the .xlsx and .ods format. The bug occurs when there are more than 2 billion records in the database. I know the problem was solved for other formats, e.g. csv. Will the
problem be solved also for other formats (e.g. xlsx, .ods)? If this is not the correct e-mail, please forward this e-mail to the appropriate person.</p>
<p class="MsoNormal"> </p>
<p class="MsoNormal">Kind regards,</p>
<p class="MsoNormal">Marta Kopszak</p>
<table class="MsoNormalTable">
<tbody>
<tr>
<td>
<p class="MsoNormal"><a href="https://www.orange.pl/" target="_blank" moz-do-not-send="true"><span><img id="_x0000_i1025" alt="Logo Orange" moz-do-not-send="true" width="40" height="40"></span></a><span></span></p>
</td>
</tr>
<tr>
<td>
<p class="MsoNormal"><b><span>Marta Kopszak</span></b><span><br>
Współpracownik</span></p>
</td>
</tr>
<tr>
<td>
<p class="MsoNormal"><span>Rozwój Sieci Stacjonarnej, Wydział Rozwoju Planowania<br>
Orange Polska, gen. Romualda Traugutta 55, 50-416 Wrocław | <a href="https://www.orange.pl/zobacz/rodo" moz-do-not-send="true">
<span>RODO - informacja o danych</span></a></span></p>
</td>
</tr>
</tbody>
</table>
<p class="MsoNormal"> </p>
</div>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<pre class="moz-quote-pre" wrap="">_______________________________________________
gdal-dev mailing list
<a class="moz-txt-link-abbreviated" href="mailto:gdal-dev@lists.osgeo.org">gdal-dev@lists.osgeo.org</a>
<a class="moz-txt-link-freetext" href="https://lists.osgeo.org/mailman/listinfo/gdal-dev">https://lists.osgeo.org/mailman/listinfo/gdal-dev</a>
</pre>
</blockquote>
<pre class="moz-signature" cols="72">--
<a class="moz-txt-link-freetext" href="http://www.spatialys.com">http://www.spatialys.com</a>
My software is free, but my time generally not.</pre>
</blockquote>
</div>
</body>
</html>