Function: org-table-convert-refs-to-an

org-table-convert-refs-to-an is a byte-compiled function defined in org-table.el.gz.

Signature

(org-table-convert-refs-to-an S)

Documentation

Convert spreadsheet references from to @7$28 to AB7.

Works for single references, but also for entire formulas and even the full TBLFM line.

Leave the relative references unchanged.

Source Code

;; Defined in /usr/src/emacs/lisp/org/org-table.el.gz
(defun org-table-convert-refs-to-an (s)
  "Convert spreadsheet references from to @7$28 to AB7.
Works for single references, but also for entire formulas and even the
full TBLFM line.

Leave the relative references unchanged."
  (while (string-match "@\\([0-9]+\\)\\$\\([0-9]+\\)" s)
    (setq s (replace-match
	     (format "%s%d"
		     (org-number-to-letters
		      (string-to-number (match-string 2 s)))
		     (string-to-number (match-string 1 s)))
	     t t s)))
  (while (string-match "\\(^\\|[^0-9a-zA-Z]\\)\\$\\([1-9][0-9]*\\)" s)
    (setq s (replace-match (concat "\\1"
				   (org-number-to-letters
				    (string-to-number (match-string 2 s))) "&")
			   t nil s)))
  s)