https://bz.apache.org/ooo/show_bug.cgi?id=112940
[email protected] changed: What |Removed |Added ---------------------------------------------------------------------------- Summary|Vlookup in password |VLOOKUP into another |protected calc files not |spreadsheet does not copy |possible |formatting Latest|--- |4.2.0-dev Confirmation in| | Keywords| |needmoreinfo CC| |[email protected] --- Comment #2 from [email protected] --- You can VLOOKUP into password protected spreadsheets. And if you clicked "Cancel" on the password dialog, you'll get the "#REF!" error in affected cells, until you go Edit -> Links, select the spreadsheet and click "Update", when it will ask for the password again, and then the references will work. The problem in the original bug report was the 0 in VLOOKUP's last argument. If the only error is that the wrong formatting is used - "font is Times New Roman 6.8 instead of Arial 10 in File2" - then the bug summary should be updated to say so. But then again that seems to be the general way references work. If you put "value" into A1 and make it italic, and then put "=A1" into another cell, the "value" shown in that other cell won't be italic. Same for font, font size, etc. So is the bug relative to VLOOKUP or is it about references in general? -- You are receiving this mail because: You are the assignee for the issue. You are on the CC list for the issue.
