Colorizing a record?

Is there a way to change the font and/or the font size of the records in the DataSheet?

Nope, you only have the default font and size right now. I did notice that Jim filed a Bitbucket issue #64 two years ago titled “Cannot change font or font size of data sheet” so I expect this might change somewhere down the road.

Well then, time for a direct message to Jim.
Why have you eliminated 2 of the most basic DataSheet formatting options, font size and coloring a record, in Panorama X. I really find this extraordinary,
and even potentially harmful to a person’s eyesight. Being a natural vision teacher since 1983, perhaps I can educate you that the larger the typesize is, the more harmful it can be to one’s vision. The anatomical fact is: the human eye can only see one point clearly at any moment. 99% of the visual field (peripheral vision) is unclear. When a person tries to see a large area perfectly clear, that is a strain—simply because it is impossible to do. For this reason I always keep my font size as small as possible as long as it is comfortable. You can read the chapter entitled Centralization in my book “Relearning to See” if you want more information on this scientific fact.
Please bring back at least font size changes to the DataSheet as soon as possible!!!

I am only guessing, but I would think Jim did not do this on purpose, rather that it is a code thing that needs to be worked out. Sometimes what seems easy, isn’t. As I said, just guessing, as it would seem to me with all the flexibility that Pan has, not having font size or color doesn’t seem to be something to be left out. Although I have seen this problem in Blue Griffon, where there are no menu items to change font size on the menu bar…
Keep in mind the PanX is still a beta product not yet for use by the general public.

Font size and coloring individual data cells are two different topics.

Most likely the ability to change the overall font size in the data sheet will be added at some point. Until now not a single person has brought this up, so it has been a very low priority item. I’ll probably add this ability, but if you ask what Steve Jobs would say, I think he would leave it out. As far as I know you can’t change the font size in the Finder, for example. If/when this does get added, it will probably be limited two three choices: Regular, Small and Mini.

Changing the style of individual data cells, records, and columns is another matter. I never liked the way this worked in earlier versions of Panorama, the feature was little used, and it has been removed. I have no plans to put it back, and it would require a major change to the database file format. Of course every feature was used by someone, so there will always be complaints when anything is removed.

If there is ever an ability to style individual cells in the future, it would not work the way it did before. There might someday be an ability to style text based on some sort of formula, for example to automatically display all negative values in a column in red. I think this would be much better than the old feature. By the way, you can do this right now with Panorama X’s new Text List capabilities (you can change the font size also).

Font size in the Finder is an option that can be found in the View/Show View Options menu item.

Robert Ameeti
(949) 422-6866

Generally I have no interest in giving a color or style to just an individual cell in the Data Sheet and I could see how that might br difficult, programming-wise.
I had given many records in the Data Sheet colors and styles, e.g., Blue Bold, to easily differentiate records. Now they are all lost. I don’t understand why coloring and/or stylizing individual records in the Data Sheet should be difficult. I am not a programmer.

Regarding font size, I would just like to be able to adjust all of the text in the Data Sheet, not individual cells. Again, this would seem not difficult, and, actually, an obviously natural option.

Steve Jobs was in fact very much the instigator of all things accessible on the iPhone. His push for accessibility was renown.

Robert Ameeti
(949) 422-6866

It is possible to change the text size of the Finder desktop and Finder folders

I for one would love to be able to change the color of numbers. For years in Panorama 6 in looking at golfers scores for each hole you can tell the story of how a golfer does through different colors. So if a person makes an eagle 3 on a hole, that 3 is blue. If he makes a birdie 4, the 4 is red. If he makes a par 5, the 5 is black and if he makes a bogey 6, the 6 is black.
So by changing the value of the color of the number, people can read the scoreboard and see by the color how a golfer was doing.
I can’t do that now in Pan X and it’s a bummer.
Jim it would really me nice to be able to change colors in Panorama again.

Sal, are you just dealing with one tournament at a time, say somewhere between one and four rounds for 50 players? If so, you could probably do the job even better with a well-designed form. It’s hard to suggest much more without knowing more about your data.

i often find in useful to view data in a monospaced font, to compare length easily.
i really miss monaco in the datasheet.
lucinda, or whatever we’re currently stuck with, uses the identical gliph for uc i and lc L. see: lI. this isnt entirely trivial.

You have the tools to create a form that will act the way you want. I created a sample database with a text list using Monaco, and which will change the font color if the data has more than a certain number of characters. You could use other rich text attributes and change the appearance based on the data.You cannot directly edit in the text list, but you can create a form that will allow you to edit a row in response a click or double-click on the row. If you used a matrix object instead of a text list, you could have even more options for the layout and editing options. Attached is a screen shot of the data sheet and one of the form with a text list.

I have used the following formula in Pan 6 to create alternating white and grey records for easier viewing:

Field greybox FormulaFill ?(int(seq()/2)=seq()/2,“greybox”,"")

This works in Pan X, but it does not print this way on a form like it did in Pan 6. All rows are white on the form while they alternate white and grey on the data sheet. Does anyone know how to make it print this way on a form in Pan X?

I would love to have the ability to adjust the font size of the datasheet.

I read it was very difficult for you to add the changing of font size in the database. So, thanks a lot for doing that, Jim. Excellent!

Now if we can change the color and style of individual records, that would be very helpful also. Here you can see why:

Thanks, Tom Q

Has there been any movement on this over the last year?

You can now change text size with Window: Text size:
No colors anymore

Hello Everybody,

I just noted tomq’s response above, and I hope he doesn’t speak for the Pan X community. The loss of color in the Data Sheet is a MAJOR deficiency in Pan X - a deficiency that I had hoped would be addressed once Jim got some time to concentrate on it. Losing the ability to color Data Sheet records is like losing a sense (such as hearing, or sight) and imagining that things are not so different from before. Or eliminating a 3rd dimension, and working in a 2-dimension plane.

Imported records (using a variable) from several different databases can be distinguished from one another by coloring them differently, so you know where each record came from and whether adjustments need to be made. And since you’re already in the Data Sheet window, the adjustments can be done directly.

And that is just one minor trivial example of the power of this feature. Given the intellectual heft of contributors to this forum, I can’t believe this isn’t widely used in complex (or even simple) macros.

The Text List object is not remotely a comparable option to this loss. The Text List object requires actual programming to set up properly, instead of having built-in commands from a menu, which the Macro Recorder can write for you. Not to mention the help colored records can give to tired old eyes like mine, when looking over and analyzing the Data Sheet records.

Jim, can you let the community know, via the forum, at least a rough estimate of when you will implement this feature. We all know you have to set priorities on what you work on first, but my 2 cents is that this one is pretty important.

Best regards,