[GNC] Style Sheets - general questions

[Adrien Monteleone]

> On Jun 19, 2020 w25d171, at 12:14 AM, flywire <flywire0 at gmail.com> wrote:
> 
>> How is it interfering with adding columns in LO Calc?
> 
> Only different formatting.
> 
>> select the entire sheet (clicking that empty cell in both row/column
> headers) and remove *all* styling.
> 
> No luck with that, Just selected cells and set to Background colour (No
> Fill).

Hmm.  I just tried it by exporting to HTML, ‘insert sheet from file’ in LO Calc, selected all cells (via that empty header cell), and in ‘Cell Appearance > Background’ clicked ’No Fill’ and it worked as expected.

I tested this with LO 6.4.3.2 on MacOS. I suppose mileage may vary.

If you don’t need the other styles, simply selecting all cells and using the right-click ‘Clear Direct Formatting’ should also do the trick.

I also tested with copy/paste, but then I recalled I’ve set my normal paste in LO Calc to be ‘Paste Special > Unformatted Text’ so I can’t test with the defaults that probably bring in styling. I should think once pasted though you should be able to manipulate like any other cells.

Regards,
Adrien