I'm having problems getting the contents of a cell to display where there's text and numbers in the cell. It's a problem that I've never come across before, and I've no idea what the problem is.
I have a table with column headings that I need to display in another table. Simply using =K4, L4, M4, N4 etc., where these are the column headings, in the second table to get them to display in the table seemed to be working fine, until I noticed that not all the column headings were displaying in the second table. I've been trying to figure out why for hours now, and finally noticed that column headings containing both text and numbers are the ones that aren't displaying. The column headings are the names of projects that users are working on in a spreadsheet that calculates the amount of time they work on each project for each month. Users enter the project names themselves, and it's highly likely they could be working on projects specific to a financial year or spanning two years, so column headings that don't display are a real problem.
The first table's set up in the following format:
[TABLE="class: grid, width: 500, align: center"]
<tbody>[TR]
[TD][/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[TD]E[/TD]
[TD]F[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD][/TD]
[TD]General repairs[/TD]
[TD]Stairlifts[/TD]
[TD]Window contract 2017[/TD]
[TD]Door contract[/TD]
[TD]123456[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]8/1/18[/TD]
[TD]5:00[/TD]
[TD]2:30[/TD]
[TD]7:45[/TD]
[TD]1:30[/TD]
[TD]9:15[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]9/1/18[/TD]
[TD]2:30[/TD]
[TD]1:00[/TD]
[TD]3:00[/TD]
[TD]1:00[/TD]
[TD]3:15[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]10/1/18[/TD]
[TD]1:00[/TD]
[TD]0:45[/TD]
[TD]1:15[/TD]
[TD]6:30[/TD]
[TD]2:10[/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]11/1/18[/TD]
[TD]6:15[/TD]
[TD]1:30[/TD]
[TD]1:10[/TD]
[TD]1:30[/TD]
[TD]0:45[/TD]
[/TR]
</tbody>[/TABLE]
This is what displays in the second table though if I use the cell references =A1, =B1, =C1, =D1, etc.
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]A[/TD]
[TD]B[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Project[/TD]
[TD]Category[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]General repairs[/TD]
[TD]Repairs & servicing[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]Stairlifts[/TD]
[TD]Repairs & servicing[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]Door contract[/TD]
[TD]Capital programmes[/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]123456[/TD]
[TD]Generic activities[/TD]
[/TR]
</tbody>[/TABLE]
I've tried changing the format of the cells to 'text' rather than 'general' but that makes no difference. Text on it's own displays fine, and numbers on their own display fine, but where the column heading's something like 'Window contract 2017' the cell is left blank.
I've never encountered this behaviour before, and I'm at a loss as to what might be causing it as it's not as though I'm trying to do any calculations or anything with the contents of the cells - I just need to display them!
Any guidance gratefully received!
I have a table with column headings that I need to display in another table. Simply using =K4, L4, M4, N4 etc., where these are the column headings, in the second table to get them to display in the table seemed to be working fine, until I noticed that not all the column headings were displaying in the second table. I've been trying to figure out why for hours now, and finally noticed that column headings containing both text and numbers are the ones that aren't displaying. The column headings are the names of projects that users are working on in a spreadsheet that calculates the amount of time they work on each project for each month. Users enter the project names themselves, and it's highly likely they could be working on projects specific to a financial year or spanning two years, so column headings that don't display are a real problem.
The first table's set up in the following format:
[TABLE="class: grid, width: 500, align: center"]
<tbody>[TR]
[TD][/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[TD]E[/TD]
[TD]F[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD][/TD]
[TD]General repairs[/TD]
[TD]Stairlifts[/TD]
[TD]Window contract 2017[/TD]
[TD]Door contract[/TD]
[TD]123456[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]8/1/18[/TD]
[TD]5:00[/TD]
[TD]2:30[/TD]
[TD]7:45[/TD]
[TD]1:30[/TD]
[TD]9:15[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]9/1/18[/TD]
[TD]2:30[/TD]
[TD]1:00[/TD]
[TD]3:00[/TD]
[TD]1:00[/TD]
[TD]3:15[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]10/1/18[/TD]
[TD]1:00[/TD]
[TD]0:45[/TD]
[TD]1:15[/TD]
[TD]6:30[/TD]
[TD]2:10[/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]11/1/18[/TD]
[TD]6:15[/TD]
[TD]1:30[/TD]
[TD]1:10[/TD]
[TD]1:30[/TD]
[TD]0:45[/TD]
[/TR]
</tbody>[/TABLE]
This is what displays in the second table though if I use the cell references =A1, =B1, =C1, =D1, etc.
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]A[/TD]
[TD]B[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Project[/TD]
[TD]Category[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]General repairs[/TD]
[TD]Repairs & servicing[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]Stairlifts[/TD]
[TD]Repairs & servicing[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]Door contract[/TD]
[TD]Capital programmes[/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]123456[/TD]
[TD]Generic activities[/TD]
[/TR]
</tbody>[/TABLE]
I've tried changing the format of the cells to 'text' rather than 'general' but that makes no difference. Text on it's own displays fine, and numbers on their own display fine, but where the column heading's something like 'Window contract 2017' the cell is left blank.
I've never encountered this behaviour before, and I'm at a loss as to what might be causing it as it's not as though I'm trying to do any calculations or anything with the contents of the cells - I just need to display them!
Any guidance gratefully received!
Last edited: