What to do when user-defined dictionary not working ?

General discussion on OpenOffice Writer and its documents.

What to do when user-defined dictionary not working ?

Postby JackSMT » Sat Oct 18, 2014 9:17 am

Hello,

I imported a table with several columns. One was START TIME 06/01/2013 12:30 PM where the /0l/ is the month. I managed to separate into two columns = START DATE | START TIME. I then managed to format the Start Date. I cannot format the START TIME.

CURRENT FORMAT = ' 06:27 PM instead of 06:27 PM.
How do I strip the apostrophe that is making it a label instead of time? Search & Replace failed. Formatting the cell failed. I have another column that is the end time so there's 143 entries x 2.

DESIRED OUTCOME:
A B C D
START DATE START TIME END TIME HOURS
01 JAN 2013 12:00 PM 1:00 AM 13:00 <<<==(C2<B2)+C2-B2 this is in HELP(Calculating Time Differences ) but untested formula

Thanks in advance,
JackSMT
 
Posts: 20
Joined: Tue Mar 25, 2014 6:29 am

Re: What to do when user-defined dictionary not working ?

Postby FoxalTO » Mon Oct 20, 2014 5:31 am

Hi,

When you renamed your user profile your standard.dic remained with the old one. Copy standard.dic from C:\Users\username\AppData\Roaming\LibreOffice\4\user.old\wordbook to C:\Users\username\AppData\Roaming\LibreOffice\4\user\wordbook.

thanks,
FoxalTO
 
Posts: 26
Joined: Tue Mar 25, 2014 6:25 am


Return to OpenOffice.org Writer

Who is online

Users browsing this forum: No registered users and 0 guests

cron