I suppose you have lots of rows and columns.
I don't think it is a bug in writer not to overwrite letters in a
"layer" but you may achieve the visual effect you are wanting by making
each column a text box, each wide enough for the full number, right
aligned, overlaying to the left, text boxes spaced 0.5".
steve
On 10/08/2022 07:05, Dave Liesse wrote:
Looks like I accidentally sent my response to one respondent instead of to the
list. Here's what I said:
----------
Using v7.3.4.2, so pretty well up to date. Language is English (USA) and
commas/decimals are set correctly.
Tab stops are .5 inches apart, so the numbers definitely overflow (seven digits
plus commas, 11 point type). However, in my expectations (a) right tabs should
work the same as left tabs, regardless of length, and (b) in a word processing
document I don't expect numbers to be treated any differently from plain text
-- except in the case of a decimal tab. I'm using only whole numbers, though.
I need the columns to overlap because of the nature of the report. I don't
have space to have three 1.25-inch columns at the right edge of the page and
the corresponding left tabs on the left side (this is a financial report with
subaccounts).
Similar problem in the spreadsheet, though it's more expected there. I need the
columns to be .5" wide, not wide enough to hold the whole number. Text would
overflow into the cell on the right (if it's empty), and I hoped -- but didn't
really expect -- numbers to do the same to the left.
The problem is that I need numbers to line up properly in right-justified
columns, without resorting to a fixed-space font (so the leading spaces are the
same width) and using left tabs.
Dave
On Mon, Aug 8, 2022, at 7:00 PM, Steve Edmonds wrote:
Does not occur for me in 7.3.4.2
What text language shows at the bottom of the window frame. (mine is
English(UK)
What decimal separator is shown in Tools>Options>Language settings
Steve
On 09/08/2022 12:18, Dave Liesse wrote:
Hi, all. It's been a long time since I've run into a problem of any
significance, so posting here before I look up how to report a bug (partly to
see if this really is one).
In a Writer document, I have three Right tab stops set, to show staggered
columns of numbers. When I type a large number, though, with commas separating
the thousands, the tab stop starts acting as a Decimal stop instead of Right.
For example, if I type 1,234,567 it acts as though the tab stop is a Decimal
stop and the comma between the 4 and the 5 is a decimal point. Might this be a
bug?
As a secondary note: I don't think this one is a bug, but it's certainly
unexpected behavior. Because I was in a hurry to get a report out to a client
I tried the same numbers in a spreadsheet, again expecting the columns would be
overlapping. Numeric values, though, won't overflow the cell the way text
does, even when the cell is specifically right-justified. Again, I was in a
hurry so I just entered all the numbers as text, but then had to do my own
calculations to show totals (no biggie, since I would have had to do that
anyway in the Writer document, but annoying in a spreadsheet).
The question is really about the first item -- the second one is just a minor
gripe. Do y'all think this is a bug, or is there some rational reason the
program should behave this way?
Dave
--
To unsubscribe e-mail to: [email protected]
<mailto:users%[email protected]>
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy
--
To unsubscribe e-mail to: [email protected]
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy
