I'm trying to make edits to a basic spread sheet of information.
Sometimes the sheet will try to fill in what it thinks I want. Other times I change the case of certain characters in a cell, and as soon as I click off that cell they revert back to their previous case.
For example: The existing text might be 987564PLdt. I change the letters to plDT, but it reverts as soon as I hit enter or click away.
If I add a space before the letters it stays, but this is not optimal.
[Solved] Cell edit reverts to previous value
[Solved] Cell edit reverts to previous value
Last edited by MrProgrammer on Tue Mar 05, 2024 4:42 pm, edited 1 time in total.
Reason: Tagged ✓ [Solved] -- MrProgrammer, forum moderator
Reason: Tagged ✓ [Solved] -- MrProgrammer, forum moderator
Open Office 4.1.2 on Windows 7
Re: Calc Edit Reverts to previous
Try turning off the menu selection Tools -> Cell Contents -> AutoInput
OpenOffice 4.1 on Windows 10 and Linux Mint
If your question is answered, please go to your first post, select the Edit button, and add [Solved] to the beginning of the title.
If your question is answered, please go to your first post, select the Edit button, and add [Solved] to the beginning of the title.