Animate Gif In Librecalc. Now click ok to print the spreadsheet cells. Imagemagick will convert them to gif.
7) give it name autocolor (see animation above) and save how to run it: But a better way to fit text in cells is to wrap it. @pedro1 i meant that there is a quick and easy way to replace the formula in the cell at the result.
LibreOffice Calc Macro Example Simple Cash Register
Sometimes, it is enough to zoom in. Here an animated gif showing both of your issues: A dark line should appear on the spreadsheet, as in the shot below, which highlights where you placed the freeze. And then press the four buttons and the formula changed to just a number (or text, or date)