[Libreoffice-bugs] [Bug 100043] import filter MS Works

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=100043

--- Comment #13 from Bernard Robins  ---
Created attachment 125377
  --> https://bugs.documentfoundation.org/attachment.cgi?id=125377=edit
LO inport from Works 6 DB

Works DB6 allows you to save a file as .cvs which seems to have solved the
basic problem of dates and large amounts of text.

I have attached LO Calc of the updated file.

LO FORMATTING: It seems you have to go into "View - Toolbars - Text formatting"
to get the text format bar to show. There were dots to the left of the bar, I
right clicked and selected "lock" the toolbar. I expected this to then remain
on the top of the page but it does not. If you select "print option" the text
format bar is removed and you have to go through the above each time you select
a different option and want to return to text formatting. The "lock toolbar"
dots have now disappeared. BUG or ME ?

Some of the records in LO were showing a red arrow on the right side of the
cell after "Wrap Text" had been selected. To format this correctly you have to
select the column then go to "Format - Row - Optimal Height - Take out default
value tick mark - Select OK". 
Could this be incorporated into the "format cells" option automatically when
selecting the "Wrap Text" box ?

You will note in the attached file that some boxes still have the "red arrow",
even after being formatted as above. This seems to be when the cell holds 3 or
more lines of text and the bottom line is just one word. The only way I have
found to get round this is to insert extra text into the cell to make the
sentence longer.

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 100043] import filter MS Works

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=100043

--- Comment #12 from Urmas  ---
Created attachment 125370
  --> https://bugs.documentfoundation.org/attachment.cgi?id=125370=edit
Long text and linebreaks testcase

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 100043] import filter MS Works

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=100043

--- Comment #11 from Urmas  ---
Created attachment 125369
  --> https://bugs.documentfoundation.org/attachment.cgi?id=125369=edit
Dates testcase

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 100043] import filter MS Works

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=100043

Urmas  changed:

   What|Removed |Added

 Status|NEEDINFO|NEW

--- Comment #10 from Urmas  ---
Tested with May 10 version:

All dates earlier than 1970-01-01 are corrupted and appear as 1899-12-30.
All text fields larger than 255 characters are cut at this value (Works
Database stores the rest of the text in a record with id 0x36, which is
apparently not supported).

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 100043] import filter MS Works

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=100043

--- Comment #9 from Cor Nouws  ---
Hi Bernard,

I simply do File > Open and then your WDB (thanks for attaching).

(In reply to Bernard Robins from comment #0)
> I have a lot of dates in 1944 and this is
> defaulting to 30 December 1899. (The 2 character date field is set to 1920).

I do not see date 1889 after importing.

(In reply to Bernard Robins from comment 100044 / #0)
> some of the text
> from MW6 is not being fully imported, this seems to happen if the field
> being imported contains more than around 200 characters.

Can you point to some fields where that is the case?

> being imported contains more than around 200 characters. After import the
> "word wrap" is not working correctly, displaying some boxes correctly and

You have to set that yourself (and may want to use cell styles for this)

> others with a small red arrow pointing to the right (I can't find any
> reference to what this means).

that means that the cell is not wide enough to display the contents.

Maybe it's good to try to get help on a user forum too/first?
See some suggestions here
  http://www.libreoffice.org/get-help/community-support/

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 100043] import filter MS Works

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=100043

--- Comment #8 from Bernard Robins  ---
Created attachment 125288
  --> https://bugs.documentfoundation.org/attachment.cgi?id=125288=edit
Copy of Works 6 Database that does not copy correctly

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 100043] import filter MS Works

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=100043

--- Comment #7 from V Stuart Foote  ---
*** Bug 100044 has been marked as a duplicate of this bug. ***

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 100043] import filter MS Works

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=100043

V Stuart Foote  changed:

   What|Removed |Added

Summary|FORMATTING  |import filter MS Works

--- Comment #6 from V Stuart Foote  ---
(In reply to Bernard Robins from comment #0)
Here is the related Works database import issue from bug 10044...

>Importing a Microsoft Works 6 database into LO spreadsheet, 
>some of the text from MW6 is not being fully imported, this 
>seems to happen if the field being imported contains more 
>than around 200 characters. After import the "word wrap" is
>not working correctly, displaying some boxes correctly and 
>others with a small red arrow pointing to the right (I can't 
>find any reference to what this means).

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs