Remy,
Thanks for your reply. When I set table contents to single the table
suddenly looked correct. So my problem is solved, but I am still
confused. Both tables look correct now, but note below how the settings
are different:
Table 1
Everything set to Default Paragraph Style, which is set to 16
Greetings,
I do this to get my tables the way I want them to be.
1) Normally, table content has the style "Table Contents" assigned to
it. Edit that style (View > Styles, then right click on Table Contents
and select Modify... in the style list) and make sure the spacing
before and after the
Hi,Even more simple:Just create a number format equal to 'nnn" "d'
(without the single quotes) and set the content of the cell to
$January.A5. The nnn is the day of the week and the d is the day in the
month in a date format.
The only thing to remember is that the "d" is valid for English-similar
This is driving me nuts.
LO 7.0.2.2 on Xubuntu 20.04, up to date.
I have two tables in a Writer document, each with about 25 rows. After
hours spent poking at dozens of different settings I finally got one of
them with 16 point rows, but after applying all the same settings to
the second one the
At 09:27 29/12/2020 -0500, Peter Dutton wrote:
In cell A4 is the following code;
="Monday"+January.$A5
Do you mean that plus sign - or perhaps an ampersand?
January.$A5 has the number 27 in it (December 27).
I'm not sure what you think you mean by adding "(December 27)"! What
I suspect
Peter,
Not sure what you are trying to accomplish.
1- The date in January.$A5 is 12/27/2021. You can see that by formatting cell
January.$A5 as date.
2- The date is internally represented as number 44557. You can see this by
formatting January.$A5 as number.
3- To get the day of the month
Put that number in E1 and formated it to a date field.
Comes up as December 27, 2021
Used this formula
="Monday "(DAY(E1),"##")
Using a + I get an error since you are adding a number to a string?
="Monday " seems to give the number value of the date.
On 29 Dec 2020 at 9:27, Peter Dutton
In cell
A4 is the following code;
="Monday
"+January.$A5
January.$A5
has the number 27 in it (December 27)
What
appears in cell A4 as a result is- Monday 44557
What is
needed is- Monday 27
I've
tried reformatting
