Re: [Semibug] saving libre office often [was: is there any office package (especially spreadsheet) that lets me choose a PEN color

Years ago my spreadsheet often got into a non-working condition, but not in several years and I save often enough I don't need your special tool, which I don't understand from a quick read. --Carey > On 05/23/2024 1:26 AM CDT Steve Litt wrote: > ... > > Yes. If you *must* use LibreOffice, s

[Semibug] re tracking changes in libre office spreadsheet [was: OT: is there any office package (especially spreadsheet) that lets me choose a PEN color]

see also response to "comments" suggestin below --Carey > On 05/22/2024 9:43 PM CDT Ron / BCLUG wrote: > > ... > > Perhaps version tracking would help with this? > > All changes can be tracked and reviewed. > ok, found this page: https://itsfoss.com/libreoffice-version-control/ it says...

Re: [Semibug] OT: is there any office package (especially spreadsheet) that lets me choose a PEN color

Ron / BCLUG said on Wed, 22 May 2024 19:43:34 -0700 >CAREY SCHUG wrote on 2024-05-22 15:34: > >> I would like to choose a PEN color, e.g. red, no matter what I enter >> or change, no matter where, it will be in the pen color. > >As Carl mentioned, LibreOffice supports colourizing text. > > >> so

Re: [Semibug] internal number storage in libre office calc [was: LibreOffice is summing incorrectly]

(1) the home page for gnucalc implies there is a way to force single precision instead of double precision, which would cut space for numbers in half, but since the numbers themselves are not all of the space, I don't know how much that would help. I have made errors, like deleting a large bloc

Re: [Semibug] LibreOffice is summing incorrectly

CAREY SCHUG wrote on 2024-05-22 14:27: I typed 4.73 into a cell, it was actually stored that way LibreOffice Calc (which uses 64-bit double-precision numbers internally) https://help.libreoffice.org/latest/en-US/text/scalc/01/calculation_accuracy.html never have more than 5 (actually 4.5,

Re: [Semibug] OT: is there any office package (especially spreadsheet) that lets me choose a PEN color

CAREY SCHUG wrote on 2024-05-22 15:34: I would like to choose a PEN color, e.g. red, no matter what I enter or change, no matter where, it will be in the pen color. As Carl mentioned, LibreOffice supports colourizing text. so I can make a group of changes, then go back and verify them, when

Re: [Semibug] OT: is there any office package (especially spreadsheet) that lets me choose a PEN color

LibreOffice Calc can do that.  There's an icon on the toolbar that lets you select a color.  When you've confirmed everything, just highlight the entire document and choose the color black. c On 5/22/24 06:34 PM, CAREY SCHUG wrote: I have a document I want to make changes to. I would like to

[Semibug] OT: is there any office package (especially spreadsheet) that lets me choose a PEN color

I have a document I want to make changes to. I would like to choose a PEN color, e.g. red, no matter what I enter or change, no matter where, it will be in the pen color. so I can make a group of changes, then go back and verify them, when confirmed, change everything to black. This is prima

Re: [Semibug] LibreOffice is summing incorrectly

looking at gnumeric...it claims all numbers are stored in double precision, and yet there can be rounding error. First, I thought behavior I observed implied if I typed 4.73 into a cell, it was actually stored that way, was not converted to machine format till a calculation was done, is that c

Re: [Semibug] LibreOffice is summing incorrectly

I suggest you check Gnumeric. I don't know how it does rounding, but I suspect you will like it. I don't use spreadsheets but have written Gnumeric extensions, and therefore I read on the Gnumeric mailing list that, while LibreOffice copies mistakes from Microsoft Excel for compatibility, Gnumeric

Re: [Semibug] LibreOffice is summing incorrectly

On Wed, May 22, 2024 at 04:41:04PM +, an...@buskvekster.mooo.com wrote: > I suggest you check Gnumeric. I don't know how it does rounding, > but I suspect you will like it. > > I don't use spreadsheets but have written Gnumeric extensions, > and therefore I read on the Gnumeric mailing list th