Description: In Libreoffice Calc, I want to make cell data from another sheet show up in the primary sheet. I found the =sheet function in the help section online and followed the process but it doesn't work. I created a brand new spreadsheet to test with and followed the directions precisely yet it still doesn't return any results. The function must be broken somehow. Example in sheet1 cell A1 I input =sheet2.a1 and then in sheet 2 I wrote 5. On sheet 1 I should see 5 there but instead I see #REF! Steps to Reproduce: 1.Type =Sheet2.A1 into Sheet1 cell A1 2.Type 5 into Sheet2 cell A1 3.Return to Sheet1 cell A1 and you will see it says #REF! Actual Results: #REF! Expected Results: 5 Reproducible: Always User Profile Reset: No Additional Info: This may not sound major but I have a spreadsheet with nearly 45 sheets that I want to extract data from to place into a sortable table in the primary sheet.
no repro with Version: 6.3.3.2 Build ID: a64200df03143b798afd1ec74a12ab50359878ed CPU threads: 8; OS: Linux 4.19; UI render: default; VCL: gtk3; Locale: nl-BE (en_US.UTF-8); UI-Language: en-US Calc: threaded
I discovered the problem. A) My sheet titles have spaces in them which doesn't work so underscores were used to fix the problem. B) In testing with a fresh spreadsheet, I was getting an error because I created the formula in sheet1 before sheet2 existed. Once sheet2 was created the formula worked after I cleared the cell and started over in sheet1.