Difference between revisions of "User:Foral/Req"

From Apache OpenOffice Wiki
Jump to: navigation, search
(Situation of Distribution/Japanese Justification on Calc ,Other software(MS Excel,Justsystem Sanshiro))
(Topic 2 : Table border)
Line 247: Line 247:
 
==Calc==
 
==Calc==
 
===Topic 2 : Table border===
 
===Topic 2 : Table border===
*[http://qa.openoffice.org/issues/show_bug.cgi?id=8275 i8275  more border types (dashed, dotted, etc)]
+
*We would like to use more border style especially dotted and dashed.
*[http://qa.openoffice.org/issues/show_bug.cgi?id=5929 i5929 Make all line styles available everywhere in OO.o]
+
**Related issue
 +
***[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===
 
===Topic 3 : Japanese Justification and Distribution===

Revision as of 20:03, 24 December 2009

This Document is draft

Background

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.

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 are basic furnitures and high priority issue for Japanese user in this year. All most of the issues has found by user long time ago and it also in the Seagull Research 2006 . However it have not solved until now so We would like to find out solution and solve issues with OpenOffice.org Community.

This list has made by Good-Day, Inc

Supported by

了承済み、ただしアクション前に確認を取る必要あり

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

Topic 3 : Japanese Justification and Distribution

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.

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.


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.

  1. Set Spacing size by point in Character Dialog->Position/Spacing for all.
  2. Select justified in Paragraph dialog->Alignment->Option:Justified/Last line:Justified for "b"
  3. limited case,Double line layout(Character -> Asian Layout) for "b".
  4. 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.

Japanese text layout sample20091125.png

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

Customs go jp 2009104e.png

Case of Microsoft Word

Microsoft Office have a two furniture for solver.

  • Fit Text for all
  1. Select some character.
  2. Push the Distributed icon on the tool bar.
  3. Open the "Fit text property dialog"
  4. Set the width by number of characters.
MS Word Fit text.png
(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)
  1. High light the Line
  2. Push the Distributed icon on the tool bar.


Topic 2 : Table border

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.

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

  • 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

Calc

Topic 2 : Table border

Topic 3 : Japanese Justification and Distribution

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.

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.

Situation of Distribution/Japanese Justification on Calc ,Other software(MS Excel,Justsystem Sanshiro)

OpenOffice.org Calc does not have Distribution furniture and Does not work justification to Japanese. We need both furniture for Horizontal and Vertical.

  • Horizontal
    • OpenOffice.org : Default setting "Default(left)"
    • MS Excel:Default setting "Default(left)"
    • Justsystem Sanshiro:Default setting "Farrow the sheet setting(left)"

Cell Format Calc Horizontal.png Cell Format Excel Horizontal.png Cell Format Sanshiro-1.png Cell Format Sanshiro-2.png

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
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.
and I think OpenOffice.org does not need it.
this issue for it? i4496
Distributed 均等割り付け - X Issue:OpenOffice.org does not have this feature.if import the excel file,it change to Justified. i107470


  • Vertical
    • OpenOffice.org : Default setting "Default(bottom)"
    • MS Excel:Default setting "Middle"
    • Justsystem Sanshiro:Default setting "Farrow the sheet setting(bottom)"

Cell Format Calc Vertical.png Cell Format Excel Vertical.png Cell Format Sanshiro-1.png Cell Format Sanshiro-2.png

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 Issue:OpenOffice.org does not have this feature.
Distributed 均等割り付け - X Issue:OpenOffice.org does not have this feature.

Sample files

  • Horizontal
    • Justfied

Spreadsheet Format H Justfied.png Media:Sample_Spreadsheet_Format_H_Justfied.xls

    • Center Across Selection

Spreadsheet Format H CAS.png Media:Sample_Spreadsheet_Format_H_CAS.xls

    • Distributed

Spreadsheet Format H Distributed.png Media:Sample_Spreadsheet_Format_H_Distributed.xls

  • Vertical
    • Justfied

Spreadsheet Format V Justfied.png Media:Sample_Spreadsheet_Format_V_Justfied.xls

    • Distributed

Spreadsheet Format V Distributed.png 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

Topic 4 : Issue about Handout Master

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

Topic 7 : Issue about Table

Personal tools