InfoQube IM - Community

Submitted by DavidF on 2016/09/18 12:03

hi,

in one of my databases, changing the format for an item has an unwanted effect on the Item field. Here is an item in this database:

If I press ctrl-B to make it bold, it becomes like this:

It's like the item text cannot expand beyond it's original "box".

Meanwhile, in the same database, the OutlineStyles grid won't take any formatting at all. (The very place where I most want formatting to happen).

Neither of these things happen in other databases.

Using 0.9.82.

DavidF.

Comments

Strange indeed. Can you mask personal data and send the file over, or else show a screencast ?

As for the OutlineStyles grid, perhaps you've applied styles formatting to that grid ? That could prevent item formatting from showing. What does the Properties pane show for those items (Item Font properties) ?

Pierre_Admin

IQ Designer

hi Pierre,

looking at the ItemFont property - items have things like |B|, |I| - but it seems arbitrary and not to change as I press ctrl-B, ctrl-I etc. In other words, in the grid the item changes format as it should (with the problem noted above, of the "curtailment" of the text), but it has no relation to what shows in the itemFont property, which I guess reflects some value it previously had. Same goes for the OutlineStyles grid, except that there the format never actually changes.

I've made a copy of the db which I'll send to you, stripped out the items and left the grids - this leaves the problem in place... Added a few items to illustrate what's going on.

DavidF.

Thanks David,

I got the file and looked at it. The issue is with a conditional formatting on the Item field. If item <> "" then set font to Consola

I removed the conditional formatting and the issue is fixed.

HTH !

Pierre_Admin

IQ Designer

Thanks Pierre, that was indeed the problem, now fixed in the original db. Cheers!

Just to add though, the problem was not the conditional formatting as such, but that it was badly formed. I had font = "Consolas", with quotes round the font name (no idea why it was there at all, tinkering I guess). If there weren't any quotes the condtional formatting would have worked and I would have had all my item fields in Consolas - not what I wanted - but there wouldn't have been these formatting oddities. The importance of correct syntax!

You do get slightly (to me) unpredictable results if you use that kind of conditional format on the Item field, and then try to use OutlineStyles - wouldn't advise it...

DavdF.

Agreed, field level conditional formatting on the Item field is not a good idea !

Pierre_Admin

IQ Designer