lino wrote:Setting horizontal alignment to Fill apart from repeating the cell's content (this is how it is supposed to work) also right aligns the content. Both are not something I want to happen.
Are you saying that setting the cell's horizontal alignment to Filled left aligns the cell's content for you? It doesn't for me.
acknak wrote:johnnybaloney wrote:... is it all what the Text Overflow option is supposed to do and everything is fine ...
Yes; I believe so.
Believe so or see so?
I'm aware that there are always higher priorities and usability is usually at the bottom of the list but for reference and perhaps clarification purposes I will file a report.
acknak wrote:Detailed formatting in a spreadsheet can be a nasty time suck because spreadsheets are designed primarily for calculating & managing data, not so much for formatting.
This was certainly the case in the times of Psion Vu-Cal. These days the longest menu item in my Calc is Format and the longest default toolbar is... Formatting, neither has much to do with managing data. I find Calc a nifty tool for quick data analysis and its formatting abilities a helpful feature. Not everyone is an accountant out there, you know.
acknak wrote:acknak wrote:But the other suggestion there will still work: ...
... filling such cells with whitespace by hand is a no-go. Unless there is some way to do it in a fairly automated manner?
Copy/paste is too much trouble?
The part of the quote you cut out was important here. Yes, copy/paste is both trouble and dangerous, one wrong paste and you lose data from a cell.
I said that filling the gaps by hand would be a no-go so is here is my first macro experiment:
Code: Select all
Sub Main
doc = ThisComponent
sheet = doc.getSheets.getByIndex(0)
usedRange = sheet.getCellRangeByPosition(0,0,0,0)
' creates a cell cursor including the whole spreadsheet
cursor = sheet.createCursorByRange(usedRange)
cursor.GotoEndOfUsedArea(false)
lastRow = cursor.RangeAddress.EndRow
lastColumn = cursor.RangeAddress.EndColumn + 1
for row = 0 to lastRow
for col = 0 to lastColumn
cell = sheet.getCellByPosition(col,row)
if (cell.Type = 0) then
cell.setFormula(" ") ' add space
endif
next col
next row
Print "Done!"
End Sub
Before and after below. Now I can see what's going on.