Re: What is "permute fixation"?
Johannes Simon <[email protected]> Fri, 19 Nov 2010 13:31:53 +0100
| Newsgroups | gmane.comp.kde.devel.internationalization-and-documentation,gmane.comp.kde.devel.koffice |
|---|---|
| Message-ID | <[email protected]> |
iWorks' Numbers offers this menu btw, which I think is much nicer and more obvious. Am 19.11.2010 um 13:27 schrieb Johannes Simon: > "Show all possible references" is closer, but not entirely correct. "Permute" means "to rearrange", so this action will switch through all possible combinations of fixed (absolute) and relative configurations of a cell reference. The shortcut is F4, so hitting F4 in the cell editor will change a reference, assuming it is simply "A3", to the following every time you hit F4: > > B3 -> B$3 -> $B3 -> $B$3 -> B3 -> ... > > However, I agree with Carlos that this is probably a pure overkill of the UI options. Doing it by hand is much quicker. For a range, e.g. "B3:D10", there is 16 (instead of 4 as in the example above) possible permutations, so it would take quite long until you get what you want. > > Am 19.11.2010 um 12:37 schrieb Marek Laane: >> Hmm, I'm still not sure I can understand it correctly - does it mean "Choose correct reference" or "Show all possible references"? >> >> Marek Laane >> >> _______________________________________________ >> koffice-devel mailing list >> [email protected] >> https://mail.kde.org/mailman/listinfo/koffice-devel >
\
(image/png, 32.8 KB) - not displayed