Topics tagged cell-reference

Topic	Replies	Views	Activity
Sort referenced cells by cell value, not content English calc , sort , cell-reference	2	664	July 31, 2021
Identifying referenced cell address on a different sheet English calc , string , cell-reference	5	796	July 31, 2021
Sorting a range that is referenced elsewhere English calc , sort , cell-reference , libreoffice-505	11	2000	July 31, 2021
Match data and EXTRACT cell ADDRESS English calc , help , cell , index , cell-reference , lookup , address , match , vlookup	5	4004	July 31, 2021
Can Calc show references in color while a formula is being entered? English calc , color , cell-reference , libreoffice-42	1	283	July 31, 2021
External reference compatibility between Excel and Calc - Err:509 English calc , ms-excel , cell-reference , external , error-509	8	5501	July 31, 2021
Named cells in hyperlinks with Calc? English calc , cell , hyperlink , cell-reference , no-work , libreoffice-500	1	242	July 31, 2021
[calc] Can I cut & paste the contents of multiple cells at once without affecting references and formats? English calc , cell-reference , macos-1075 , libreoffice-422 , cell-format	5	4960	July 31, 2021
How do I refer to a cell, address from ROW and COLUMN functions English calc , cell-reference	3	1834	July 31, 2021
In libreoffice CalcWhen copying a sheet from one worksheet to other the reference links within the sheets changes to temporary. How to avoid this? English calc , cell-reference	2	183	July 31, 2021
Feature request - "inherited" formatting for referred cells English calc , format , lost , cell-reference , inherit	2	404	July 31, 2021
full referrence a cell to another English calc , cell-reference	1	167	July 31, 2021
How to use cell value as a row number in referencing? English calc , sort , cell-reference , database , lubuntu-1404 , libreoffice-428	3	12083	July 31, 2021
Cell reference in header or footer? English calc , header , footer , cell-reference	3	976	July 31, 2021
Counting the difference between MIN and MAXC English calc , cell-reference , count , libreoffice-435	2	297	July 31, 2021
"this cell" in conditional formatting English calc , date , cell-reference , conditional-format	7	8690	July 31, 2021
Absolute reference English calc , cell-reference , absolute	7	2019	July 31, 2021
Calc: How to have two input cells convert measurment units between each other? English calc , convert , cross-reference , cell-reference , measurement , libreoffice-426	3	1937	July 31, 2021
DGET with discontinuous range English calc , cell-reference , database , dget	2	1001	July 31, 2021
LibreOffice Calc problem when referencing cells in another spreadsheet English calc , cell-reference , libreoffice-404 , centos-66	3	1790	July 31, 2021
Comments in cell. Reference to cell from another cell. Can the comments be made to appear in the referring cell? English calc , comment , cell-reference	2	374	July 31, 2021
Is there a method to reference cell contents from another sheet so that inserting/deleting/moving cells/rows/columns does not redefine the references? English calc , cell-reference	3	7283	July 31, 2021
Calc: external references of multiple files; extend selection English calc , cell-reference , external , increment	1	449	July 31, 2021
check if cell was referenced on another sheet English calc , cell-reference , sheet , search	6	555	July 31, 2021
Polling any type, 'Blank' cell to empty text (string) English calc , cell-reference , blank-cell	18	2798	July 31, 2021
Odd behaviour with cell references when inserting new columns English calc , column , insert , cell-reference , libreoffice-423	7	972	July 31, 2021
Can I use a cell reference in the sum command? English calc , cell-reference	3	584	July 31, 2021
Maintaining Formatting in Referenced Cells English calc , cell , format , cell-reference , libreoffice-357	2	3276	July 31, 2021
I have a multi-worksheet spreadsheet XLS file. This file ran fine in LibO Calc3.6 but after updating to LibO 4.2.1 references in the 'slave' sheets to cells in the 'master sheet do not work. English calc , cell-reference , libreoffice-421 , multi-sheet-file	2	272	July 31, 2021
How do I reference between OLE Embedded Calc Worksheets in same Document English calc , cell-reference , ole-object , libreoffice-414	3	425	July 31, 2021