Integer overflow in Calc lcl_getSingleCellAddressFromXMLString nColumn computation

[Kohei Yoshida]

On 08.03.2021 18:00, Kohei Yoshida wrote:
> On 08.03.2021 11:09, Stephan Bergmann wrote:
> 
>> On recent master, if I create a bare-bones pivot.ods containing a
>> pivot chart (in a fresh Calc document, type "A" into A1 and "2" into
>> A2, click into A1, then "Insert - Pivot Table... - OK" and drag "A"
>> from "Available Fields" to "Column Fields" and "OK", then "Insert -
>> Chart... - Finish", then save):  The resulting pivot.ods "Object
>> 1/content.xml" sub-file contains a chart:plot-area XML element with a
>> table:cell-range-address="PivotChart" attribute as above, but which
>> appears to be nonsense according to the ODF standard as quoted below.
>> 
>> Maybe some Calc expert can shed some light on what is going on here, 
>> and if that
>> 
>>   <chart:plot-area table:cell-range-address="PivotChart" ...>
>> 
>> is legitimate, and should legitimately be processed with
>> lcl_getSingleCellAddressFromXMLString as is done here.
> 
> Added Tomaz to the CC list since (I believe) he has worked on pivot
> chart and may have a fresher memory on this topic.

Also, since ODF v1.2 was approved in 2011, and the pivot chart feature 
was added sometime around 2017, it's possible that we are doing 
something "ahead" of the latest standard.

Kohei