Created attachment 122816 [details] Bug-NumberFormatChanges I have this formula: =IF(EXACT($B2,F$1), STYLE("Match"), STYLE("Default"))+5 Shows 5 as number format General. But when I copy/past it or replace the 5 with a 0 the number format gets changed to Boolean.
Tested further. This only happens with the custom "Match" style.
Hi @Lorenz25, thanks for reporting. 'Match' style has the boolean format for numbers, so it's what you can expect. I don't how C2 show '5' but after a hard recalc it shows as boolean.
No, that is not correct. I never set the number format to Boolean. And as you can read in the comment of F2 I can set it back to General, but then it goes back to Boolean after a recalc.
Maybe you don't set but 'Match' style has the boolean format for numbers.
But I if I don't set it and it changes by itself, this is a bug. I want it to be General and it won't work.
What if you modifies the 'Match' style to General?
Sorry, but I already told you, that it changes back to Boolean from General. And even if we assume, that it's the purpose of General to change to a fitting format, like if you enter a date and it becomes Date: I can set the format explicitly to Number and even then it changes to Boolean; which is not helpful. Anyway, thanks for looking into it, BTW.
Created attachment 122984 [details] Sample file modifying 'Match' style Please could you est.
Great, now it changes from every other format to General. Tested it also with background color; changes back to blue. So, can I assume that I have to define the style somewhere else than in the Properties dialog of the cell?
Created attachment 123000 [details] Two different formats in one style I still don't get it. Without a formula I can modify the style locally. But is the usage of a style not, to define a format globally?
You can find the documentation: https://wiki.documentfoundation.org/Documentation/Publications#LibreOffice_Calc_Guide Chapter 4 is about 'Using Styles and Templates.'
Got it! Thanks for the effort. But how it changed to Boolean in the first place, I still don't know.
if you're the one who made the spreadsheet, and no one else touched it, ... :) Really styles are very useful, something very interesting is the inheritance among styles, so that by changing any property of a style affects all who depend on it.
Yeah, but I must have accidentally changed the number format AND hit the update button, which I didn't know anything about. Strange...