Re: [libreoffice-users] file format problem?

2016-04-06 Thread Thomas Blasejewicz 

On 2016/04/07 0:16, anne-ology wrote:


[yet another program?]

SpiderOak is not a program but a cloud storage service like Dropbox.
What I save on one computer will be synchronized (AND older versions 
archived) with my other computers.




[suggestion: open LO - then attempt to open saved document, allowing it
to translate if necessary;
hopefully, your file will re-appear.]


That did not help.
I opened the .docx file with LO in the first place, upon saving accepted 
the proposed (by LO) .docx format.




The file contained originally about 4300 Japanese characters.
Even though there was nothing on my screen beyond the first 1/3 of that
file, its size did not change.
When I deleted the second 2/3 of the original file, the original size of
470 kb shrank to 130 kb.
After I retyped all the lost work and saved that first as .ODT and then
later as .docx, file size was 23 and 16 kb respectively.

[these are MsFt not LO documents.]
After the trouble occured, I copied TEXT ONLY into Writer, finished work 
there AND THEN saved first as .odt and then as .docx (same file)


Necessity for Word format: translation agencies send me those Word file 
-> expect them to be "overwritten" ->
AND expect Word files back. Which will then be sold to the clients who 
ordered the translations. (translation not of file formats, but of text: 
manuals, books, letters etc.)
If I start mumbling "I use only odt format ...", they will probably stop 
sending me work. Then I will starve to death ...




--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Re: about libreoffice and tables:

2016-04-06 Thread libreoffice-ml . mbourne 

nasrin khaksar wrote:

can you please open it with open office, save it as doc and see the
result when openning in libreoffice?
for me it opens in libreoffice 5.0.5 and also 5.1.0 without any crash!
do you think i should report a bug for it?


Which format opens in LibreOffice 5.0.5 and 5.1.0 without a crash? From 
your original message, I thought the original .docx version crashed 4.x 
versions but opened OK in 5.0.5 and 5.1.0. There's no point reporting 
bugs against older versions which are already fixed in 5.0.x and 5.1.x, 
since those older versions won't be updated anyway.


If 5.0.5 and 5.1.0 can open the .doc version but not the .docx version, 
that may be worth reporting, but you'll probably need to include an 
example file which triggers the crash for anyone to track down the 
problem. Be aware that files attached to Bugzilla will be publicly 
accessible.


--
Mark.


--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Adding decimal minutes to regular minutes and hours (calc)

2016-04-06 Thread James Knott 
On 04/06/2016 09:36 AM, John Meyer wrote:
> Hi,
>
> I have a project where I am trying to calculate the total amount of
> work hours for a project based upon the timestamp of calls throughout
> the day.  The time at which the calls is placed is in hh:mm:ss while
> the duration of the call is in decimal time.  I need to take the last
> call of the day and add the decimal time to get an accurate shift
> time.Do I just put the hh:mm:ss time in the time function and add
> that to the decimal time?
>
> Thanks.
>

While I haven't done this in a spreadsheet, I used to on a calculator. 
I did it by converting between decimal degrees and degrees, minutes &
seconds.

BTW, as an indication of how long ago I did this, I used this method to
add up the time for tracks on an LP to figure out how much time I'd need
on a cassette.  ;-)


-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] file format problem?

2016-04-06 Thread Tim---Kracked_P_P---webmaster 

On 04/06/2016 11:16 AM, anne-ology wrote:

Maybe I can help,
   [see notes interspersed below]



From: Thomas Blasejewicz 
Date: Wed, Apr 6, 2016 at 7:50 AM
Subject: [libreoffice-users] file format problem?
To: users@global.libreoffice.org


Good evening
I am not sure whether this is a LibreOffice (?) problem or just MY problem.
It happened before, but I will describe the latest episode.

I was working with Writer on a Word (.docx) file. As a translation job I
was supposed to overwrite that file.

[MsFt does not necessarily recognize LO; had you opened this in LO or
MsFt? (docx is one of MsFt's files)]


Is there any requirement to use MS's .docx format instead of the more 
compatible .doc format?


I do not do any translation between languages, but if you do not need to 
use .docx for the translated file, then I would not do so.


To be honest, the .docx format have compatibility issues between MS's 
Word versions.  Last year, I finally convinced a MS Office user that it 
would be better to use .doc over .docx for the files emailed out to many 
users that have various versions of MS Office, and for me LO.


For me, I make all my word processing documents using .odt and then save 
it in .doc format for the MS Word users.






The file contained images, tables and objects.
After being 2/3 finished, I saved the file, went downstairs and wanted
to continue working while having a coffee.
However, when I opened the file, saved in SpiderOakOne, I noticed, that
the latter 2/3 of the file were gone.

[yet another program?]

Including 1/2 day of work.
Even archived earlier versions of the same file showed only the first 1/3.
Trying to open that file with MS Word, resulted in the following error:
"File Format error at
SAXParse Exception:
[word/document.xml line 2]:
Attribute w:hAnsi redefined
Stream word/document.xml line 2, column 73305 (row,col)"

[suggestion: open LO - then attempt to open saved document, allowing it
to translate if necessary;
hopefully, your file will re-appear.]

The file contained originally about 4300 Japanese characters.
Even though there was nothing on my screen beyond the first 1/3 of that
file, its size did not change.
When I deleted the second 2/3 of the original file, the original size of
470 kb shrank to 130 kb.
After I retyped all the lost work and saved that first as .ODT and then
later as .docx, file size was 23 and 16 kb respectively.

[these are MsFt not LO documents.]

A different translator translating the same file (probably using MS
Word) into a different language had apparently no problems.

What is happening here?
Does this mean Writer has problems handling MS Word files?
Is it the incomprehensible .docs format?

[that's a good word to describe MsFt  ;-)]

Do I HAVE to use Word for such file? Something I really do not want to do!
Is there anything to PREVENT this kind of event? (retyping my work all
the time will get me into real trouble!)

[suggestion: use LO to open documents ... work with documents ... then
if necessary, save as MsFt to send to others
   - although if they too have LO, then no translation would be
necessary  ;-)]

Thomas




--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] file format problem?

2016-04-06 Thread anne-ology 
   Maybe I can help,
  [see notes interspersed below]



From: Thomas Blasejewicz 
Date: Wed, Apr 6, 2016 at 7:50 AM
Subject: [libreoffice-users] file format problem?
To: users@global.libreoffice.org


Good evening
I am not sure whether this is a LibreOffice (?) problem or just MY problem.
It happened before, but I will describe the latest episode.

I was working with Writer on a Word (.docx) file. As a translation job I
was supposed to overwrite that file.

   [MsFt does not necessarily recognize LO; had you opened this in LO or
MsFt? (docx is one of MsFt's files)]

The file contained images, tables and objects.
After being 2/3 finished, I saved the file, went downstairs and wanted
to continue working while having a coffee.
However, when I opened the file, saved in SpiderOakOne, I noticed, that
the latter 2/3 of the file were gone.

   [yet another program?]

Including 1/2 day of work.
Even archived earlier versions of the same file showed only the first 1/3.
Trying to open that file with MS Word, resulted in the following error:
"File Format error at
SAXParse Exception:
[word/document.xml line 2]:
Attribute w:hAnsi redefined
Stream word/document.xml line 2, column 73305 (row,col)"

   [suggestion: open LO - then attempt to open saved document, allowing it
to translate if necessary;
   hopefully, your file will re-appear.]

The file contained originally about 4300 Japanese characters.
Even though there was nothing on my screen beyond the first 1/3 of that
file, its size did not change.
When I deleted the second 2/3 of the original file, the original size of
470 kb shrank to 130 kb.
After I retyped all the lost work and saved that first as .ODT and then
later as .docx, file size was 23 and 16 kb respectively.

   [these are MsFt not LO documents.]

A different translator translating the same file (probably using MS
Word) into a different language had apparently no problems.

What is happening here?
Does this mean Writer has problems handling MS Word files?
Is it the incomprehensible .docs format?

   [that's a good word to describe MsFt  ;-)]

Do I HAVE to use Word for such file? Something I really do not want to do!
Is there anything to PREVENT this kind of event? (retyping my work all
the time will get me into real trouble!)

   [suggestion: use LO to open documents ... work with documents ... then
if necessary, save as MsFt to send to others
  - although if they too have LO, then no translation would be
necessary  ;-)]

Thomas

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

[libreoffice-users] Re: Adding decimal minutes to regular minutes and hours (calc)

2016-04-06 Thread Andreas Säger 
Am 06.04.2016 um 15:36 schrieb John Meyer:
> Hi,
> 
> I have a project where I am trying to calculate the total amount of work
> hours for a project based upon the timestamp of calls throughout the
> day.  The time at which the calls is placed is in hh:mm:ss while the
> duration of the call is in decimal time.  I need to take the last call
> of the day and add the decimal time to get an accurate shift time.Do
> I just put the hh:mm:ss time in the time function and add that to the
> decimal time?
> 
> Thanks.
> 

Spreadsheet dates are formatted numbers in unit "Days".
0.0 <==> 00:00
0.25 <==> 06:00 1/4 of a day
0.5 <==> 12:00 1/2 of a day
0.75 <==> 18:00 3/4 of a day
1.0 <==> 24:00 (with number format [HH]:MM)

There is no difference between the day fraction on the left and the
formatted number on the right. Both sides yield the exact same results
for all kinds of calculations and comparisons.
Multiply by 24 in order to convert days to hours and switch to some
decimal format when the result looks wrong.

Number format [HH]:MM displayes hours beyond 24 as full hours. This
number format should be used when you want to express time spans in
hours. A time span of 2 days and 3 hours (value 2.125) formatted as
HH:MM shows 03:00 (the hours at a point of time) whereas [HH]:MM shows
51:00.

The first method actually calculates the amount of hours, the formatting
solution provides a more adequate representation of time spans without
any conversion.


-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

[libreoffice-users] Adding decimal minutes to regular minutes and hours (calc)

2016-04-06 Thread John Meyer 

Hi,

I have a project where I am trying to calculate the total amount of work 
hours for a project based upon the timestamp of calls throughout the 
day.  The time at which the calls is placed is in hh:mm:ss while the 
duration of the call is in decimal time.  I need to take the last call 
of the day and add the decimal time to get an accurate shift time.Do 
I just put the hh:mm:ss time in the time function and add that to the 
decimal time?


Thanks.

--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

[libreoffice-users] file format problem?

2016-04-06 Thread Thomas Blasejewicz 
Good evening
I am not sure whether this is a LibreOffice (?) problem or just MY problem.
It happened before, but I will describe the latest episode.

I was working with Writer on a Word (.docx) file. As a translation job I
was supposed to overwrite that file.
The file contained images, tables and objects.
After being 2/3 finished, I saved the file, went downstairs and wanted
to continue working while having a coffee.
However, when I opened the file, saved in SpiderOakOne, I noticed, that
the latter 2/3 of the file were gone.
Including 1/2 day of work.
Even archived earlier versions of the same file showed only the first 1/3.
Trying to open that file with MS Word, resulted in the following error:
"File Format error at
SAXParse Exception:
[word/document.xml line 2]:
Attribute w:hAnsi redefined
Stream word/document.xml line 2, column 73305 (row,col)"

The file contained originally about 4300 Japanese characters.
Even though there was nothing on my screen beyond the first 1/3 of that
file, its size did not change.
When I deleted the second 2/3 of the original file, the original size of
470 kb shrank to 130 kb.
After I retyped all the lost work and saved that first as .ODT and then
later as .docx, file size was 23 and 16 kb respectively.

A different translator translating the same file (probably using MS
Word) into a different language had apparently no problems.

What is happening here?
Does this mean Writer has problems handling MS Word files?
Is it the incomprehensible .docs format?
Do I HAVE to use Word for such file? Something I really do not want to do!
Is there anything to PREVENT this kind of event? (retyping my work all
the time will get me into real trouble!)

Thomas

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted