Issue 123977 - Negative value is generated when set the indent to 99pt in a cell
Summary: Negative value is generated when set the indent to 99pt in a cell
Status: UNCONFIRMED
Alias: None
Product: Calc
Classification: Application
Component: code (show other issues)
Version: 4.1.0-dev
Hardware: All All
: P3 Normal (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords: needmoreinfo
Depends on:
Blocks:
 
Reported: 2014-01-06 09:52 UTC by fanyuzhen
Modified: 2017-05-20 10:44 UTC (History)
3 users (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---

Attachments
Sample ODS File with Indent in a Cell (6.82 KB, application/x-vnd.oasis.opendocument.spreadsheet)
2014-01-06 09:52 UTC, fanyuzhen 		no flags Details
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
Description fanyuzhen 2014-01-06 09:52:44 UTC 
Created attachment 82226 [details]
Sample ODS File with Indent in a Cell

Steps:
1. Open the attached test file(Story29245.ods) in AOO
2. Check the cell which has 99 indents before the text

Problem: negative value is generated in XML when set the indent to 99 pt, although it can display correctly for this cell
Comment 1 Edwin Sharp 2014-01-06 11:29:51 UTC 
In what real life application such an indent will be necessary?
IMHO only problem is non smooth horizontal scrolling due to column width.
Comment 2 Shenfeng Liu 2014-01-20 02:45:35 UTC 
(In reply to Edwin Sharp from comment #1)
> In what real life application such an indent will be necessary?
> IMHO only problem is non smooth horizontal scrolling due to column width.

My opinion:
(1) It is not a critical defect for Apache OpenOffice itself, since it can be handled correctly now, and it is a rare user case to set such a big indent.
(2) It is a real defect, since we are saying we support open standard format, and the purpose is that other vendors (e.g. ODF Toolkit) can also develop their applications to open and edit on the same document. But if we are writing some thing wrong in the document, it may lead all other vendors to handle it incorrectly, unless they add special code to deal with this exception.
Comment 3 Edwin Sharp 2014-02-02 13:49:44 UTC 
Confirmed with
AOO410m1(Build:9750)  -  Rev. 1560934
2014-01-27_04:11:25 - Rev. 1561585
Debian
Comment 4 Rainer Bielefeld 2014-03-28 16:30:54 UTC 
I haven't a clue what has been confirmed here, I will do some further research
Comment 5 Rainer Bielefeld 2014-03-28 17:42:55 UTC 
Here definitively some things are going wrong, I am only trying to find out the details.
I am a little astonished - Indents in content.xml really are in "inch"?!

@fanyuzhen
When I open your attachment In AOO I see indents ten times bigger than text is showing. Can your please check?
Of course it would be interesting to see the switch between 2 different indent values when the problem appears. Can you contribute a modified sample document?
Comment 6 Rainer Bielefeld 2014-03-28 18:02:07 UTC 
Additinal info:
(a) Smaller indents < 100 or so: cells look equal after indent applied and 
    save / reopen
(b) bigger indents > 900 (I did not check where that starts): indent looks 
    plausible, test is visible somewhere at column M. After save / Reopen:
    Cell contents visible in column AI
Comment 7 Marcus 2017-05-20 10:44:36 UTC 
Reset the assignee to the default "issues@openoffice.apache.org".