Date default in table cell.

["V. & B. Electric" <vi...@gmail.com>]

Hello,
I have a document made by Microsoft Office with .docx. The document is a
log file with dates. I converted in Open Office, .doc,  and when I save the
document, converted the dates I modify in the document from ( Dec.03-2015)
to (12/03/15) without to request such a modification. I modify again the
date as I want to have it and the software modify it again. Did not modify
the dates that were already there but I did not touch it.
Please let me know why it is happened like that and how I should setup the
software to save in to the document as I like to have it, (Dec.03-2015).
Also I would like to get rid of the border lines that are in any new or old
document you open. See pic.
Please let me know how to resolve the 2 problems.
Thank you!
Regards,

-- 
*Victor Brasoveanu*

Re: Date default in table cell.

[Brian Barker <b....@btinternet.com>]

At 01:53 20/11/2015 -0800, Victor Brasoveanu wrote:
>I have a document made by Microsoft Office with .docx. The document 
>is a log file with dates. I converted in Open Office, .doc, ...

If you wish to handle and edit your document in OpenOffice, you would 
be wise to save it in OpenOffice's native format - .odt - and not any 
foreign proprietary format.

>... and when I save the document, converted the dates I modify in 
>the document from (Dec.03-2015) to (12/03/15) without to request 
>such a modification. I modify again the date as I want to have it 
>and the software modify it again. Did not modify the dates that were 
>already there but I did not touch it. Please let me know why it is 
>happened like that and how I should setup the software to save in to 
>the document as I like to have it, (Dec.03-2015).

Writer tables have rudimentary calculation facilities (rather like a 
spreadsheet), and date values you enter may be recognised as such and 
formatted consistently. There are two ways to achieve what you need:

o You could set the format of your table cells appropriately. Go to 
Table | Number Format... (or right-click | Number Format...). For 
Category, select Date; and then under Format choose your preferred 
format. To get your exact requirement, you will need to enter its 
code into the "Format code" box: use "MMM.DD-YYYY".

o Alternatively, you could disable the automatic recognition and keep 
exactly what you typed. This would be appropriate if you do not need 
to calculate with your dates, and I'm guessing it is what you will 
choose. To do this, go to Tools | Options... | OpenOffice Writer | 
Table | Input in tables, and remove the tick from "Number 
recognition". (You will need to enter your data one more time, of course.)

>Also I would like to get rid of the border lines that are in any new 
>or old document you open. See pic.

There is no picture, as attached files are removed by the list 
processor before messages are distributed. There are no border lines 
in new documents (apart from the pale grey margin lines, which will 
not print, of course). If you mean borders of your table, you can 
control these at Table | Table Properties... | Borders (or 
right-click | Table... | Borders). Either click the left example 
under Line arrangement | Default or scroll up and click "- none -" 
under Line | Style. Remember that, when you are creating a table and 
get to the Insert Table dialogue at Table | Insert > | Table..., you 
can more simply remove the tick from Border under Options there.

I trust this helps.

Brian Barker


---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@openoffice.apache.org
For additional commands, e-mail: users-help@openoffice.apache.org