https://bz.apache.org/ooo/show_bug.cgi?id=81233
alex6684 <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |[email protected] --- Comment #23 from alex6684 <[email protected]> --- In the new version references to columns 677 to 702 don't work. What's the purpose of applying FLOOR to the result of a MOD operation? Please delete my e-mail address from comment 10. Here's a way to obtain the column characters, not limited to 3, in pseudocode: columncharacters := ""; while columnnumber > 0 do columncharacters := concat (chr ((columnnumber - 1) mod 26) + 65; columncharacters); columnnumber := floor ((columnnumber - 1) div 26) end; (Then add $ for absolute references.) -- You are receiving this mail because: You are on the CC list for the issue. You are the assignee for the issue.
