Difference between revisions of "User:Foral/Req"
Line 363: | Line 363: | ||
|} | |} | ||
− | ==for what,we use it and Sample of user scenario== | + | ====for what,we use it and Sample of user scenario==== |
*Justfied | *Justfied | ||
*Distributed | *Distributed | ||
− | ===Sample files=== | + | ====Sample files==== |
[[Media:Sample_Spreadsheet_format_all.xls|listed sample for cell formatting]] | [[Media:Sample_Spreadsheet_format_all.xls|listed sample for cell formatting]] | ||
− | ====Horizontal==== | + | =====Horizontal===== |
*Justfied | *Justfied | ||
[[File:Spreadsheet_Format_H_Justfied.png|200px]] | [[File:Spreadsheet_Format_H_Justfied.png|200px]] | ||
Line 384: | Line 384: | ||
[[Media:Sample_Spreadsheet_Format_H_Distributed.xls]] | [[Media:Sample_Spreadsheet_Format_H_Distributed.xls]] | ||
− | ====Vertical==== | + | =====Vertical===== |
*Justfied | *Justfied | ||
[[File:Spreadsheet_Format_V_Justfied.png|200px]] | [[File:Spreadsheet_Format_V_Justfied.png|200px]] |
Revision as of 18:51, 24 December 2009
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 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 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
Issue No | Type | Priority | Topic No | Owner | State | Component | Summary |
---|---|---|---|---|---|---|---|
i5929 | ENHANCEMENT | P3 | Topic2 | dr | NEW | framework | Make all line styles available everywhere in OO.o |
i8275 | ENHANCEMENT | P3 | Topic2 | requirements | NEW | Drawing | more border types (dashed, dotted, etc) |
i13624 | DEFECT | P3 | Topic6 | fme | STARTED | l10n | Incorrect proportional char spacing, with Kana compressed |
i18342 | FEATURE | P3 | Topic2 | bh | UNCONFIRMED | Word processor | Styles of lines (e.g. around table cells) not imported correctly |
i36408 | DEFECT | P3 | Topic3 | tora | NEW | Word processor | Requirements of Japanese Justification |
i42606 | ENHANCEMENT | P3 | Topic2 | requirements | NEW | Word processor | Microsoft Word diagonal lines in tables not displayed when opened in OOo Writer |
i53373 | DEFECT | P4 | Topic3 | tl | NEW | Word processor | Align "Justified" in Draw text box does not work very well for Japanese text |
i58813 | DEFECT | P3 | Topic3 | tl | NEW | Drawing | text align justification fails with CJK (Chinese Japanese and Korean) text |
i71824 | ENHANCEMENT | P3 | Topic1 | requirements | NEW | framework | Need a paragraph alignment Distributed in addition to Justified |
i80049 | ENHANCEMENT | P3 | Topic2 | requirements | NEW | Word processor | Diagonal_TableHeader |
i90868 | FEATURE | P3 | Topic3 | mba | NEW | Word processor | Paragraph alignment 'Distributed' and character alignment 'Fit text' |
i94297 | DEFECT | P3 | Topic7 | cl | NEW | Presentation | Distince to border resets |
i107161 | DEFECT | P3 | Topic6 | hdu | STARTED | l10n | Area over the character if enable the compressed option |
i107162 | DEFECT | P3 | Topic6 | hdu | UNCONFIRMED | l10n | Lap over the character if use proportional font and enable the compressed option |
i107467 | DEFECT | P3 | Topic1 | kohei | STARTED | Spreadsheet | Justification does not work for Japanese |
i107470 | FEATURE | P3 | Topic3 | kohei | STARTED | Spreadsheet | Add "Distributed" Text Alignment |
i107471 | DEFECT | P3 | Topic1 | sba | UNCONFIRMED | Word processor | Alignment fail if checked snap to text grid. |
i107531 | TASK | P3 | Topic5 | hbrinkm | NEW | Word processor | does not import old version documents which in versioning feature |
i107533 | TASK | P3 | Topic5 | hbrinkm | NEW | Word processor | WW8: Does not export old version documents which in versioning |
i107538 | DEFECT | P3 | Topic4 | sj | NEW | Presentation | does not import position of header and footer in Handout |
i107813 | DEFECT | P3 | Topic4 | graphicsneedsconfirm | UNCONFIRMED | Presentation | does not import text data witch in header and footer in Handout |
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
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
- We would like to use Japanese Justification and Distribution on everywhere
- We can not use Japanese Justification on text box.
- Related issues
Principles of Arrangement for Japanese
Japanese user basically use spacing furniture for title of document and title of table..etc According to 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
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
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.
1)Title:
It have "a. Fixed inter-character spacing" in here.
- Set Font-Size by point in Character Dialog->Position/Spacing.
2)Affiliation:
It have "b.Even inter-character spacing".
- select Double line layout(Character -> Asian Layout) then put a two full-space between "指定社員" and "執行役員社員".
3)Name:
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:
this is not about spacing.
Other sample
- I pick from ministry of finance in Japan.
- I pick from University(it is common business format)
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.
(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 calc.
- Related Spec form Redflag 2000
- The Spec by Diagonal_Table_Header
- i80049 Diagonal_TableHeader
- Related Spec form Redflag 2000
- We would like to use more border style especially dotted and dashed.
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.
- 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
- i13624 : Incorrect proportional char spacing, with Kana compressed
- i107162 : Lap over the character if use proportional font and enable the compressed option
- 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
- border style especially dotted and dashed.
- versioning feature
Calc
Topic 2 : Table border
- i8275 more border types (dashed, dotted, etc)
- i5929 Make all line styles available everywhere in OO.o
Topic 3 : Japanese Justification and Distribution
Format Cell
- Horizontal
- OpenOffice.org : Default setting "Default(left)"
- MS Excel:Default setting "Default(left)"
- Justsystem Sanshiro:Default setting "Farrow the sheet setting(left)"
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. | 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? 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)"
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
listed sample for cell formatting
Horizontal
- Justfied
Media:Sample_Spreadsheet_Format_H_Justfied.xls
- Center Across Selection
Media:Sample_Spreadsheet_Format_H_CAS.xls
- Distributed
Media:Sample_Spreadsheet_Format_H_Distributed.xls
Vertical
- Justfied
Media:Sample_Spreadsheet_Format_V_Justfied.xls
- Distributed
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
- i53373 Align "Justified" in Draw text box does not work very well for Japanese text
- i58813 text align justification fails with CJK (Chinese Japanese and Korean) text
- i71824 Need a paragraph alignment Distributed in addition to Justified
Topic 4 : Issue about Handout Master
- i107538 does not import position of header and footer in Handout
- i107813 does not import text data witch in header and footer in Handout
- i107815 does not export data of header and footer in Handout
Topic 6 : Issue about Asian Kerning
- i13624 : Incorrect proportional char spacing, with Kana compressed
- i107162 : Lap over the character if use proportional font and enable the compressed option
- i107161 : Area over the character if enable the compressed option