https://bugs.documentfoundation.org/show_bug.cgi?id=158891
--- Comment #14 from Michael <[email protected]> --- I realize that ours is a very unique use of LibreCalc, and we are probably the only group that has needs as specific as these. We have been using Calc for this purpose since 2017, so we have found some ways of coping. We are transcribing data from logbooks that span the years from 1861 to 1955. Over the years, the colour of the pages have changed and some have faded very badly. The inks have also changed, some are much lighter than others. We have also seen blue and brown pencil marks as well as various shades of black and blue ink. This means that we have to enhance the background images to make them readable, and the enhancements often need to change when the logbook for a particular ship and year changes. There have been many changes of those 90 years, as well as the logbooks for the Coast Guard, Revenue Service and Navy also differ at times. I mention this to show that one size doesn't fit all. SO, you can see why the colours in Calc become so important to us. Our standard colours are red for the cell borders which align with the weather grids on the logbooks. We outline the Event areas on the logbooks in blue. These are the areas on the logbook where supplemental information is added. The fonts are bold red. That said, our transcribers change these colours to suit their needs. Depending on the logbook and the enhancements needed, a yellow font works better. We need to be able to proofread the entered data and the written data underneath it.Sadly, yellow doesn't show up against the Automatic Document Background which is white. This means we can't see the characters as we're typing unless we look up at the formula bar or wait until the entry is finished. Setting the Document Background to match the colour of the logbook makes the other sheets in the spreadsheet hard to read. And, blue doesn't work for one or two of our transcribers who are colorblind. They can change the outline around the Event areas, but not the colour of the border around the active cell. Considering that we have two people who are colour blind, if it is too difficult to have the colour of the border around the active cell configurable, we understand. Similarly, if it is too difficult to configure the background colour of the cell to be different than the Document Background colour, we understand that also. We are extremely impressed with Calc, and we couldn't use any other tool for this kind of work. The evolution since we started with Version 3 is remarkable. Our work with Calc has been noted in a couple of news stories, a book about the history of notebooks, a poster at a conference on data transcription,and two academics are writing a paper about it. -- You are receiving this mail because: You are the assignee for the bug.
