I have a multi-worksheet spreadsheet, and I am trying to reference the value of one cell on one sheet in another. When I type "=" in the destination cell, and click on the cell to reference on the other sheet, the sheet:cell reference (i.e. ='Monthly Plan'.B53), nothing happens. I get a red border around the target cell, but the reference is not made. Further more, I can make this operate as expected from other cells on this and other worksheets, it is just certain cells that will not work. I have tried adding and deleting rows, to no avail - it seems that certain columns on this worksheet will not let me reference cells from other worksheets. I upgraded to 3.5.6.2, but that has not changed anything.
As @moggi notes above:
Please file a bug about this problem, and provide a test document and a list of steps that can reproduce it. The QA team will be happy to help you track down this issue!
Please post a link to any bugs you file in a comment below using the format "fdo#123456".
Thanks!
LibreOffice is made available by volunteers around the globe, backed by a charitable Foundation. Please support our efforts: Your donation helps us to deliver a better product!
Asked: 2012-08-26 20:19:33 +0200
Seen: 614 times
Last updated: Feb 22
Content on this site is licensed under a Creative Commons Attribution Share Alike 3.0 license.
Please open a bug report for it with a test document and a detailed instruction how to reproduce your problem. https://www.libreoffice.org/get-help/bug/
moggi ( 2012-08-30 21:51:39 +0200 )edit