[Issue 81233] MS Excel 2003 SpreadsheetML import corrupts references to columns that are multiples of 26 (eg. Z)

[bugzilla]

https://bz.apache.org/ooo/show_bug.cgi?id=81233

--- Comment #24 from alex6684 <alex.plant...@xs4all.nl> ---
(In reply to alex6684 from comment #23)

Here's the correct version:

columncharacters := "";
while columnnumber > 0 do
  columncharacters := concat (chr ((columnnumber - 1) mod 26 + 65);
columncharacters);
  columnnumber := floor ((columnnumber - 1) div 26)
end;

-- 
You are receiving this mail because:
You are on the CC list for the issue.
You are the assignee for the issue.