Difference between revisions of "User:Foral/Req"

From Apache OpenOffice Wiki
Jump to: navigation, search
(for what,we use it and Sample of user scenario)
(Blanked the page)
 
(21 intermediate revisions by one other user not shown)
Line 1: Line 1:
= Background =
 
Good-Day, Inc located in Osaka/Japan is a company that develop and support Open Source Software. We are contributing to OpenOffice.org since 2002. At the moment, we are concentrating to OpenOffice.org in QA and Localize.
 
One of the big company have researched furniture of OpenOffice.org since 2008 and [http://www.ipa.go.jp/software/open/forum/index-e.html the Japan OSS Promotion Forum] started to joint trial use OpenOffice.org from 3.1.1 which we provide. The trial has some companies that represents Japan. please see the detail on website. </nowiki>
 
According to result of research , trial use and [http://ooo-research.good-day.net/?en_top Seagull Research 2006], We found some big baggage to use / migrate for enterprise user. We picked up 7 topic which </nowiki>are basic furniture and high priority issue for Japanese user in this year. We would like to find out solution and solve it with OpenOffice.org Community.
 
  
= Topic list  =
 
* Topic 1 : Grid layout for Japanese(Writer)
 
* Topic 2 : Table border(All especially Calc and Writer)
 
* Topic 3 : Japanese Justification and Distribution(Impress,Calc,Writer)
 
* Topic 4 : Issue about Handout Master(Impress)
 
* Topic 5 : version feature(Writer)
 
* Topic 6 : Issue about Asian Kerning(Impress , Calc ,Writer)
 
* Topic 7 : Issue about Table(Impress)
 
 
= Issue List =
 
 
{| class="prettytable sortable" border="2" cellpadding="4" cellspacing="0" style="margin: 1em 1em 1em 0; background: #ccccee; border: 1px #aaa solid; border-collapse: collapse;"
 
|-
 
!Issue No ||Type||Priority||Topic No||Owner||State||Component||Summary
 
|-
 
| [http://qa.openoffice.org/issues/show_bug.cgi?id=5929 i5929]||ENHANCEMENT||P3||Topic2||dr||NEW||framework||Make all line styles available everywhere in OO.o
 
|-
 
| [http://qa.openoffice.org/issues/show_bug.cgi?id=8275 i8275]||ENHANCEMENT||P3||Topic2||requirements||NEW||Drawing||more border types (dashed, dotted, etc)
 
|-
 
| [http://qa.openoffice.org/issues/show_bug.cgi?id=13624 i13624]||DEFECT||P3||Topic6||fme||STARTED||l10n||Incorrect proportional char spacing, with Kana compressed
 
|-
 
| [http://qa.openoffice.org/issues/show_bug.cgi?id=18342 i18342]||FEATURE||P3||Topic2||bh||UNCONFIRMED||Word processor||Styles of lines (e.g. around table cells) not imported correctly
 
|-
 
| [http://qa.openoffice.org/issues/show_bug.cgi?id=36408 i36408]||DEFECT||P3||Topic3||tora||NEW||Word processor||Requirements of Japanese Justification
 
|-
 
| [http://qa.openoffice.org/issues/show_bug.cgi?id=42606 i42606]||ENHANCEMENT||P3||Topic2||requirements||NEW||Word processor||Microsoft Word diagonal lines in tables not displayed when opened in OOo Writer
 
|-
 
| [http://qa.openoffice.org/issues/show_bug.cgi?id=53373 i53373]||DEFECT||P4||Topic3||tl||NEW||Word processor||Align "Justified" in Draw text box does not work very well for Japanese text
 
|-
 
| [http://qa.openoffice.org/issues/show_bug.cgi?id=58813 i58813]||DEFECT||P3||Topic3||tl||NEW||Drawing||text align justification fails with CJK (Chinese Japanese and Korean) text
 
|-
 
| [http://qa.openoffice.org/issues/show_bug.cgi?id=71824 i71824]||ENHANCEMENT||P3||Topic1||requirements||NEW||framework||Need a paragraph alignment Distributed in addition to Justified
 
|-
 
| [http://qa.openoffice.org/issues/show_bug.cgi?id=80049 i80049]||ENHANCEMENT||P3||Topic2||requirements||NEW||Word processor||Diagonal_TableHeader
 
|-
 
| [http://qa.openoffice.org/issues/show_bug.cgi?id=90868 i90868]||FEATURE||P3||Topic3||mba||NEW||Word processor||Paragraph alignment 'Distributed' and character alignment 'Fit text'
 
|-
 
| [http://qa.openoffice.org/issues/show_bug.cgi?id=94297 i94297]||DEFECT||P3||Topic7||cl||NEW||Presentation||Distince to border resets
 
|-
 
| [http://qa.openoffice.org/issues/show_bug.cgi?id=107161 i107161]||DEFECT||P3||Topic6||hdu||STARTED||l10n||Area over the character if enable the compressed option
 
|-
 
| [http://qa.openoffice.org/issues/show_bug.cgi?id=107162 i107162]||DEFECT||P3||Topic6||hdu||UNCONFIRMED||l10n||Lap over the character if use proportional font and enable the compressed option
 
|-
 
| [http://qa.openoffice.org/issues/show_bug.cgi?id=107467 i107467]||DEFECT||P3||Topic1||kohei||STARTED||Spreadsheet||Justification does not work for Japanese
 
|-
 
| [http://qa.openoffice.org/issues/show_bug.cgi?id=107470 i107470]||FEATURE||P3||Topic3||kohei||STARTED||Spreadsheet||Add "Distributed" Text Alignment
 
|-
 
| [http://qa.openoffice.org/issues/show_bug.cgi?id=107471 i107471]||DEFECT||P3||Topic1||sba||UNCONFIRMED||Word processor||Alignment fail if checked snap to text grid.
 
|-
 
| [http://qa.openoffice.org/issues/show_bug.cgi?id=107531 i107531]||TASK||P3||Topic5||hbrinkm||NEW||Word processor||does not import old version documents which in versioning feature
 
|-
 
| [http://qa.openoffice.org/issues/show_bug.cgi?id=107533 i107533]||TASK||P3||Topic5||hbrinkm||NEW||Word processor||WW8: Does not export old version documents which in versioning
 
|-
 
| [http://qa.openoffice.org/issues/show_bug.cgi?id=107538 i107538]||DEFECT||P3||Topic4||sj||NEW||Presentation||does not import position of header and footer in Handout
 
|-
 
| [http://qa.openoffice.org/issues/show_bug.cgi?id=107813 i107813]||DEFECT||P3||Topic4||graphicsneedsconfirm||UNCONFIRMED||Presentation||does not import text data witch in header and footer in Handout
 
|-
 
| [http://qa.openoffice.org/issues/show_bug.cgi?id=107815 i107815]||DEFECT||P3||Topic4||graphicsneedsconfirm||UNCONFIRMED||Presentation||does not export data of header and footer in Handout
 
|-
 
|}
 
 
= Detail of each Application =
 
==Writer==
 
===Topic 1 : Grid layout for Japanese===
 
*We would like to solver some issue about grid layout
 
** [http://qa.openoffice.org/issues/show_bug.cgi?id=107471 i107471 Alignment fail if checked snap to text grid.]
 
 
===Topic 3 : Japanese Justification and Distribution===
 
* We would like to use Distribution furniture by more easy way.
 
**like the Specification by Takamichi Akiyama <tora@openoffice.org> : [[Alignment_Distributed]]
 
**Releated issues
 
*** [http://qa.openoffice.org/issues/show_bug.cgi?id=90868 i90868 Paragraph alignment 'Distributed' and character alignment 'Fit text']
 
 
* We would like to use Japanese Justification and Distribution on everywhere
 
** We can not use Japanese Justification on text box.
 
** Related issues
 
*** [http://qa.openoffice.org/issues/show_bug.cgi?id=53373 i53373 Align "Justified" in Draw text box does not work very well for Japanese text]
 
*** [http://qa.openoffice.org/issues/show_bug.cgi?id=58813 i58813 text align justification fails with CJK (Chinese Japanese and Korean) text]
 
*** [http://ja.openoffice.org/issues/show_bug.cgi?id=71067 i71067 Justify Text not for Last Line]
 
*** [http://qa.openoffice.org/issues/show_bug.cgi?id=71824 i71824 Need a paragraph alignment Distributed in addition to Justified]
 
 
====Principles of Arrangement for Japanese====
 
Japanese user basically use spacing furniture for title of document and title of table..etc
 
According to [http://en.wikipedia.org/wiki/Japanese_Industrial_Standards Japanese Industrial Standards],There are three type of spacing.
 
It call "Fixed inter-character spacing","Even inter-character spacing" and "Tsumegumi".
 
 
Office software should be able to use it.
 
 
*Please see the detail in Requirements for Japanese Text Layout
 
**[http://www.w3.org/TR/2009/NOTE-jlreq-20090604/#en-subheading1_2_3 2.1.3 Principles of Arrangement of Kanji and Kana Characters]
 
**[http://www.w3.org/TR/2009/NOTE-jlreq-20090604/#en-subheading2_7_3 3.7.3 Jidori Processing]
 
 
a.''Fixed inter-character spacing'':
 
Text set with a fixed size space between each character frame (see [Fig.6]).
 
 
b. ''Even inter-character spacing'':
 
Text set with equal inter-character spacing between characters on a given line,
 
so that each line is aligned to the same line head and line end (see [Fig.7]).
 
 
Even inter-character space setting is used in books for unifying the length of table headings with Japanese text (see [Fig.8]).
 
There are also examples (e.g. lists of names) in which parts of a person names receive inter-character spacing.
 
 
c.''Tsumegumi (kerning / tracking)'': Text is set with negative inter-character space by arranging characters
 
so that a portion of two character frames overlap each other. This is divided further into two types,
 
depending on the methods used for inter-character space reduction. One method involves reducing by the
 
same amount of inter-character space (even tsumegumi or tracking, see [Fig.9]) and the other involves
 
determining the amount of space to reduce based on the distance between the two letter faces of adjacent
 
characters (face tsumegumi or letter face kerning, see [Fig.10]).
 
 
====Japanese Justification====
 
Justification is basically furniture.
 
Japanese Justification is unique.
 
please see some blow Reference.
 
 
* Reference
 
** [[Writer/CJK_Justification|CJK Justification]]
 
** [http://qa.openoffice.org/issues/show_bug.cgi?id=36408 i36408 Requirements of Japanese Justification]
 
** [http://www.w3.org/TR/1999/WD-i18n-format-19990910/#a5 International Layout in CSS]
 
** [http://www.w3.org/TR/2009/NOTE-jlreq-20090604/ Requirements for Japanese Text Layout]( more detail)
 
 
 
====Situation of Distribution on Writer====
 
OpenOffice.org Writer is supported enough furniture for make spacing except Text box.
 
But it is not easy to use.
 
 
* a. Fixed inter-character spacing
 
* b. Even inter-character spacing
 
* c. Tsumegumi (kerning / tracking)
 
 
Writer can do all of them by blow ways.
 
 
# Set Spacing size by point in Character Dialog->Position/Spacing for all.
 
# Select justified in Paragraph dialog->Alignment->Option:Justified/Last line:Justified for "b"
 
# limited case,Double line layout(Character -> Asian Layout) for "b".
 
# Type and Put the full and half space manually for "a" and "b"
 
 
However,
 
There are hard to use "1" for "b" and "c".
 
because user have to mind font size ,calculate themselves and set .
 
of cause, they have to recalculate again if change font size.
 
 
also difficult to find  "2" furniture.
 
 
====for example====
 
I made a sample paper.This is common business layout for Japanese.
 
 
[[File:Japanese text layout sample20091125.png|200px]]
 
 
1)''Title'':<BR>
 
It have "a. Fixed inter-character spacing" in here.
 
* Set Font-Size by point in Character Dialog->Position/Spacing.
 
 
2)''Affiliation'':<BR>
 
It have "b.Even inter-character spacing".
 
* select Double line layout(Character -> Asian Layout) then put a two full-space between "指定社員" and "執行役員社員".
 
 
3)''Name'':<BR>
 
It have  "b.Even inter-character spacing" and sometimes this place need "c. Tsumegumi (kerning / tracking)" if the name is long.
 
 
*Calculate and Set Font-Size by point in Character Dialog->Position/Spacing each line.
 
 
4)''stamp place'':<BR>
 
this is not about spacing.
 
*about this isssue [http://qa.openoffice.org/issues/show_bug.cgi?id=105888 i105888 fenced character lost when I use fenced character function on ms-word]
 
 
=====Other sample=====
 
**I pick from ministry of finance in Japan.
 
***http://www.customs.go.jp/toukei/shinbun/trade-st_e/2009/2009104e.pdf
 
[[File:Customs_go_jp_2009104e.png]]
 
**I pick from University(it is common business format)
 
***http://www.osaka-u.ac.jp/migr/pdf/jp/annai/information/joho/pdf/zaimu/dokuritsukansa(h18).pdf
 
 
====Case of Microsoft Word====
 
Microsoft Office have a two furniture for solver.
 
* Fit Text for all
 
#Select some character.
 
#Push the Distributed icon on the tool bar.
 
#Open the "Fit text property dialog"
 
#Set the width by number of characters.
 
[[File:MS_Word_Fit_text.png|200px]]<BR>(Fit text property dialog)
 
 
If they do not have enough space in the font,
 
They change the font size by scale width furniture.
 
 
*c) Distributed Paragraph for "b" ( it is same way as Select justified in Paragraph dialog->Alignment->Option:Justified/Last line:Justified for "b" in OpenOffice.org)
 
#High light the Line
 
#Push the Distributed icon on the tool bar.
 
 
 
===Topic 2 : Table border===
 
* We would like to use Diagonal like [http://specs.openoffice.org/calc/compatibility/diagonalborders.sxw calc].
 
** Related Spec form Redflag 2000
 
*** The Spec by [[Diagonal_Table_Header]]
 
*** [http://qa.openoffice.org/issues/show_bug.cgi?id=80049 i80049 Diagonal_TableHeader]
 
 
* We would like to use more border style especially dotted and dashed.
 
** Related issue
 
*** [http://www.openoffice.org/issues/show_bug.cgi?id=932 i932 Table border style]
 
*** [http://www.openoffice.org/issues/show_bug.cgi?id=5929 i5929 Make all line styles available everywhere in OO.o]
 
*** [http://qa.openoffice.org/issues/show_bug.cgi?id=18342 i18342 Styles of lines (e.g. around table cells) not imported correctly]
 
 
====Situation of Table on Writer====
 
We usually use Diagonal line on the table and dot line.
 
It mean of diagonal that is same as N/A and also use head of the table.
 
 
[[File:Sample_writer_table1.png]]
 
 
* currently version of openoffice.org writer can not use Diagonal so we have to draw by my self.
 
* currently version of openoffice.org writer can not use dot line so we are deception by gray line.
 
 
===Topic 6 : Issue about Asian Kerning===
 
*[http://qa.openoffice.org/issues/show_bug.cgi?id=13624 i13624]  : Incorrect proportional char spacing, with Kana compressed
 
*[http://qa.openoffice.org/issues/show_bug.cgi?id=107162 i107162] : Lap over the character if use proportional font and enable the compressed option
 
*[http://qa.openoffice.org/issues/show_bug.cgi?id=107161 i107161] : Area over the character if enable the compressed option
 
 
===Other : MS-Word file filter===
 
* We would like to improve ms-filter(Ms-word binary file).
 
** Diagonal
 
*** [http://qa.openoffice.org/issues/show_bug.cgi?id=42606 i42606 Microsoft Word diagonal lines in tables not displayed when opened in OOo Writer]
 
** border style especially dotted and dashed.
 
*** [http://qa.openoffice.org/issues/show_bug.cgi?id=18342 i18342 Styles of lines (e.g. around table cells) not imported correctly]
 
** versioning feature
 
***[http://qa.openoffice.org/issues/show_bug.cgi?id=107533 i107533:Does not export old version documents which in versioning feature to Word File]
 
***[http://qa.openoffice.org/issues/show_bug.cgi?id=107531 i107531:Does not import old version documents which in versioning feature]
 
 
==Calc==
 
===Topic 2 : Table border===
 
*[http://qa.openoffice.org/issues/show_bug.cgi?id=8275 i8275  more border types (dashed, dotted, etc)]
 
*[http://qa.openoffice.org/issues/show_bug.cgi?id=5929 i5929 Make all line styles available everywhere in OO.o]
 
 
===Topic 3 : Japanese Justification and Distribution===
 
*[http://qa.openoffice.org/issues/show_bug.cgi?id=107470 i107470 Add "Distributed" Text Alignment]
 
*[http://qa.openoffice.org/issues/show_bug.cgi?id=107467 i107467 Justification does not work for Japanese]
 
 
===Format Cell===
 
*Horizontal
 
** OpenOffice.org : Default setting "Default(left)"
 
** MS Excel:Default setting "Default(left)"
 
** Justsystem Sanshiro:Default setting "Farrow the sheet setting(left)"
 
[[File:Cell_Format_Calc_Horizontal.png|200px]]
 
[[File:Cell_Format_Excel_Horizontal.png|200px]]
 
[[File:Cell_Format_Sanshiro-1.png|200px]]
 
[[File:Cell_Format_Sanshiro-2.png|200px]]
 
 
{| border=1
 
!feature
 
!feature(japanese)
 
!Calc
 
!MS-Excel(japanese version)
 
!Comment
 
!Issue Track
 
|-
 
|Default
 
|標準
 
|X
 
|X
 
|No problem
 
|-
 
|Left
 
|左
 
|X
 
|X
 
|No problem
 
|-
 
|Center
 
|中央
 
|X
 
|X
 
|No problem
 
|-
 
|Right
 
|右
 
|X
 
|X
 
|No problem
 
|-
 
|Justfied
 
|両揃え
 
| -
 
|X
 
|Issue:does not work correctly for Asian Character,work fine for English Character.
 
|[http://qa.openoffice.org/issues/show_bug.cgi?id=107467 i107467](need to one more report for Vertical)
 
|-
 
|Filled
 
|塗り潰し/繰り返し
 
|X
 
|X
 
|No problem
 
|-
 
|Center Across Selection
 
|選択範囲内で中央
 
| -
 
|X
 
|No problem :OpenOffice.org does not have this feature.but if import the excel file,it change to merge cell. It seems no problem.
 
|this issue for it? [http://qa.openoffice.org/issues/show_bug.cgi?id=4496 i4496]
 
|-
 
|Distributed
 
|均等割り付け
 
| -
 
|X
 
|Issue:OpenOffice.org does not have this feature.if import the excel file,it change to Justified. there is big difference between Justified and Distributed.
 
|need report
 
|}
 
 
 
*Vertical
 
** OpenOffice.org : Default setting "Default(bottom)"
 
** MS Excel:Default setting "Middle"
 
** Justsystem Sanshiro:Default setting "Farrow the sheet setting(bottom)"
 
 
[[File:Cell_Format_Calc_Vertical.png|200px]]
 
[[File:Cell_Format_Excel_Vertical.png|200px]]
 
[[File:Cell_Format_Sanshiro-1.png|200px]]
 
[[File:Cell_Format_Sanshiro-2.png|200px]]
 
 
{| border=1
 
!feature
 
!feature(japanese)
 
!Calc
 
!MS-Excel(japanese version)
 
!Comment
 
|-
 
|Default
 
|標準
 
|X
 
| -
 
|MS-Excel does not have this.
 
|-
 
|Top
 
|上
 
|X
 
|X
 
|No problem
 
|-
 
|Middle
 
|中央
 
|X
 
|X
 
|No problem/
 
|-
 
|bottom
 
|下
 
|X
 
|X
 
|No problem
 
|-
 
|Justfied
 
|両揃え
 
| -
 
|X
 
|OpenOffice.org does not have this feature.
 
|-
 
|Distributed
 
|均等割り付け
 
| -
 
|X
 
|OpenOffice.org does not have this feature.
 
|}
 
 
====for what,we use it and Sample of user scenario====
 
*Justfied
 
*Distributed
 
 
====Sample files====
 
[[Media:Sample_Spreadsheet_format_all.xls|listed sample for cell formatting]]
 
=====Horizontal=====
 
*Justfied
 
[[File:Spreadsheet_Format_H_Justfied.png|200px]]
 
 
[[Media:Sample_Spreadsheet_Format_H_Justfied.xls]]
 
 
*Center Across Selection
 
[[File:Spreadsheet_Format_H_CAS.png|200px]]
 
 
[[Media:Sample_Spreadsheet_Format_H_CAS.xls]]
 
*Distributed
 
[[File:Spreadsheet_Format_H_Distributed.png|200px]]
 
 
[[Media:Sample_Spreadsheet_Format_H_Distributed.xls]]
 
 
=====Vertical=====
 
*Justfied
 
[[File:Spreadsheet_Format_V_Justfied.png|200px]]
 
 
[[Media:Sample_Spreadsheet_Format_V_Justfied.xls]]
 
 
*Distributed
 
[[File:Spreadsheet_Format_V_Distributed.png|200px]]
 
 
[[Media:Sample_Spreadsheet_Format_V_Distributed.xls]]
 
 
====Other : MS-Excel file filter====
 
* We would like to improve ms-filter(Ms-excel binary file).
 
** border style especially dotted and dashed.
 
** Japanese Justification and Distribution
 
 
==Graphics(Draw/Impress)==
 
===Topic 3 : Japanese Justification and Distribution===
 
*[http://qa.openoffice.org/issues/show_bug.cgi?id=53373 i53373 Align "Justified" in Draw text box does not work very well for Japanese text]
 
*[http://qa.openoffice.org/issues/show_bug.cgi?id=58813 i58813 text align justification fails with CJK (Chinese Japanese and Korean) text]
 
*[http://qa.openoffice.org/issues/show_bug.cgi?id=71824 i71824 Need a paragraph alignment Distributed in addition to Justified]
 
===Topic 4 : Issue about Handout Master===
 
*[http://qa.openoffice.org/issues/show_bug.cgi?id=107538 i107538 does not import position of header and footer in Handout]
 
*[http://qa.openoffice.org/issues/show_bug.cgi?id=107813 i107813 does not import text data witch in header and footer in Handout]
 
*[http://qa.openoffice.org/issues/show_bug.cgi?id=107815 i107815 does not export data of header and footer in Handout]
 
===Topic 6 : Issue about Asian Kerning===
 
*[http://qa.openoffice.org/issues/show_bug.cgi?id=13624 i13624]  : Incorrect proportional char spacing, with Kana compressed
 
*[http://qa.openoffice.org/issues/show_bug.cgi?id=107162 i107162] : Lap over the character if use proportional font and enable the compressed option
 
*[http://qa.openoffice.org/issues/show_bug.cgi?id=107161 i107161] : Area over the character if enable the compressed option
 
===Topic 7 : Issue about Table===
 
*[http://qa.openoffice.org/issues/show_bug.cgi?id=94297 i94297 Distince to border resets]
 

Latest revision as of 02:03, 21 January 2010

Personal tools