https://bugs.documentfoundation.org/show_bug.cgi?id=158700
--- Comment #2 from ady <[email protected]> --- (In reply to Aleksandr from comment #0) > 3.Click on the formula input line in the first Calc. > 4.Click on the formula input line in the second Calc. I might be wrong but I think that once you click on the formula input line in the first file, then you are effectively in edit mode. For instance: A.0. Save both files (so they are clearly identified/named). A.1. On an empty cell of the first file, click on the formula input line. A.2. Type-in the equal sign "=". A.3. Click on some cell (preferably with content and some format) on the second file. A.4. Press [ENTER]. A.5. Go back to the first file and review the content of the same cell of step A.1. You should have a formula in the input line referring to the second file, and the cell itself should show the same content of the cell of the second file you clicked on. This is more clear when both files are already saved before starting the whole procedure (hence, step A.0.). Therefore, since you are (still) on (cell's) "edit" mode after your step 3 (or after my step A.1.), you cannot also enter into edit mode in the second file simultaneously (i.e. your step 4); otherwise the kind of alternative steps I just described would not be possible. If you want to enter into (cell's) edit mode in the second file, you need to exit edit mode from the first file before that (e.g press [ESC], or [ENTER], depending on the result you want in the first file). I doubt there is some realistic solution, as Calc is not capable of preemptively knowing whether: * you want to related the first file to the second one, or instead, * you want to abort the first edit mode and enter into edit mode in the second file. -- You are receiving this mail because: You are the assignee for the bug.
