Summary: | Anchor To Cell position drifts as file opened and re-saved over time | ||
---|---|---|---|
Product: | LibreOffice | Reporter: | jasonkres <jason> |
Component: | Calc | Assignee: | Not Assigned <libreoffice-bugs> |
Status: | UNCONFIRMED --- | ||
Severity: | normal | CC: | himajin100000, ilmari.lauhakangas, rb.henschel |
Priority: | medium | ||
Version: | 7.1.0.2 rc | ||
Hardware: | All | ||
OS: | Windows (All) | ||
Whiteboard: | |||
Crash report or crash signature: | Regression By: |
Description
jasonkres
2021-01-23 19:21:12 UTC
The problem is not your locale or measurement unit, but the internal units. Size and position of the cells are in unit "Twips", with 1pt = 20 Twips. The unit for drawing objects is 1/100 mm. Both are integer. When a drawing object is anchored to cell, its absolute position (in 1/100 mm) has to be converted in an offset (in 1/100mm) from left-top corner of cell (Twips). So rounding errors are unavoidable. Bug 138109 is related to these rounding errors. Besides that there might be off-by-one errors because the 'size' of a rectangle can be including or excluding edge. In mathematics the length of [..[ is the same as for [..], but in an integer grid not. Note that the rounding doesn't seem to stabilize... the errors accumulate to the point that it is very noticeable on screen and in print on frequently opened and modified documents. In other words, it can grow to over a quarter of an inch off, etc. over time. (In reply to Regina Henschel from comment #1) > The problem is not your locale or measurement unit, but the internal units. > Size and position of the cells are in unit "Twips", with 1pt = 20 Twips. The > unit for drawing objects is 1/100 mm. Both are integer. When a drawing > object is anchored to cell, its absolute position (in 1/100 mm) has to be > converted in an offset (in 1/100mm) from left-top corner of cell (Twips). So > rounding errors are unavoidable. > > Bug 138109 is related to these rounding errors. So should we leave this bug open or...? |