Topics tagged cell-format

Topic	Replies	Views	Activity
How do I indicate in 1 cell the equivalent of: =IF A2>0, A2$A$1 or IF B2>0, B2$B$1? English calc , cell-format	4	1133	May 3, 2018
Can I setup a spreadsheet to show a blank when result is zero? English calc , cell-format	9	4620	July 31, 2021
How can I use a custom background color in LibreOffice Calc (4.x)? English calc , windows-7 , color , background-color , libreoffice-43 , cell-format	4	10541	July 31, 2021
Calc: Customize 'General' number format English calc , custom , cell-format	3	9892	July 31, 2021
Paste data, NOT formats, into LO? English common , writer , calc , default , auto-format , ubuntu-1404 , cell-format , libreoffice-428	10	5045	July 31, 2021
does not retain user-defined date format (YYYY) in Calc English calc , date , date-format , cell-format	4	1392	July 31, 2021
how to change format date English calc , format , date-format , cell-format	2	1730	July 31, 2021
How to set cell color with basic English calc , ms-windows , macro , basic , cell-format , libreoffice-543	6	5538	July 31, 2021
Custom date and time formats English calc , format , date , opensuse , custom , time , cell-format , libreoffice-437	3	9516	July 31, 2021
How can I format a cell to a custom number format other than scientific notation? English calc , cell , cell-format , scientific-notation , notation	2	1104	July 31, 2021
Format for entering durations in years and months English calc , cell-format	10	2054	July 31, 2021
How can I reduce the number of cell in a sheet by taking the average of a set number of cells English calc , cell , cell-format , cell-content , reduce	6	2691	July 31, 2021
How to add a column of Hours English calc , time , addition , hour , cell-format , minute	7	3614	July 31, 2021
How to get date format DD/MM/YY for UK.? English common , cell-format	4	826	July 31, 2021
Colour alternate rows without disturbing existing format English calc , background-color , cell-format	3	1450	July 31, 2021
Calc dumps format changes English calc , cell-format , macos-10105 , libreoffice-524	2	898	July 31, 2021
Number format for "quantity of time"? English calc , time , cell-format	2	2810	July 31, 2021
Calc: formatting of trailing non-printing digits English calc , number , cell-format	3	550	July 31, 2021
How can I easily format all cell borders in a sheet with existing data English calc , cell , border , cell-format	4	3523	July 31, 2021
How can I put the command, Format > Cells > Borders on a toolbar? English calc , cell , border , button , toolbar , command , cell-format , custom-toolbar	4	2617	July 31, 2021
LibreOffice Calc cell format not saving in xlsx format English calc , xlsx , cell-format , libreoffice-523	1	729	July 31, 2021
How do I rearrange cells in calc? English calc , cell , cell-format	3	1319	July 31, 2021
What data types/format needs to be used for "remove duplicates" ? English calc , duplicate , cell-format , datatype	2	584	July 31, 2021
Cell format not applied after file reload in Calc English calc , cell-format	4	816	July 31, 2021
Convert cells to hex English calc , cell-format	3	5332	July 31, 2021
Changing cell format if it contains text from a list English calc , conditional-format , cell-format	7	5343	July 31, 2021
LO Base is not saving the field formatting when editing a table English base , input , hsqldb , mask , cell-format , no-save	4	1861	July 31, 2021
Calc. formatting cells with double line border does not save English calc , cell-format , libreoffice-522	2	1324	July 31, 2021
CALC - Two-line custom format English calc , custom , cell-format	6	1368	July 31, 2021
Calc - copy row to column English calc , format , cell-reference , copy , cell-format , multiple-cell	8	4282	July 31, 2021