Alphanumeric LCD HD44780 - big font, big digits generator (excel sheet)

Log in or register to post comments
Go To Last Post
16 posts / 0 new
Author
Message
china92
china92's picture
Level: New Member
Joined: Fri. Sep 25, 2015
Posts: 6 View posts
#1
Posted by china92: Fri. Sep 25, 2015 - 09:50 PM
  • 1
  • 2
  • 3
  • 4
  • 5
Total votes: 2

Hi,
this is my first post here and I would like to share some of my work with you. Please change the forum section if needed.

 

I have prepared a simple excel sheet which allows to generate and preview bigger fonts for alphanumeric LCD display. I have made this tool for myself, as I was struggling few times with design of big digits (containing few lines and cells). i hope you will find it useful as well.

I'm adding sheet as an attachment, bit it can be fount on github too, because maybe I will put some more work into it. Please excuse my English - its not my native language. I hope everything will work on non Polish version of excel.

Feel free to write any comments or ideas. Also if you know any more pages where this would fit, please let me know.

 

lcd big font text digits generator hd44780

Attachment(s): 

Package icon LCD-font-generator.zip

Tags:

Tools, Compilers and General Programming
Last Edited: Thu. Apr 21, 2016 - 09:30 AM
Top
Someguy22
Someguy22's picture
Level: Posting Freak
Joined: Tue. Mar 14, 2006
Posts: 1473 View posts
Location: Near a lake, South of Boston, Massachusetts, USA
Posted by Someguy22: Fri. Sep 25, 2015 - 11:53 PM
  • 1
  • 2
  • 3
  • 4
  • 5
Total votes: 0

Hey, that looks nice. With extra work you can automate the spreadsheet to output C files directly. I did something similar that generated multiple language files from a spreadsheet. I am pretty sure I used Visual Basic for Applications.

Top
china92
china92's picture
Level: New Member
Joined: Fri. Sep 25, 2015
Posts: 6 View posts
Posted by china92: Sat. Sep 26, 2015 - 07:20 AM
  • 1
  • 2
  • 3
  • 4
  • 5
Total votes: 0

Yes, you are right but it depends on implementation and how you handle the big font displaying (usually its a structure anyway I guess). Thank you for your comment, I'll think about it.

I also used VBA for three macros, that allow you to click on cells to change a bit for them. After that the definition of signs is automatically changed.

Top
Someguy22
Someguy22's picture
Level: Posting Freak
Joined: Tue. Mar 14, 2006
Posts: 1473 View posts
Location: Near a lake, South of Boston, Massachusetts, USA
Posted by Someguy22: Sat. Sep 26, 2015 - 07:25 AM (Reply to #3)
  • 1
  • 2
  • 3
  • 4
  • 5
Total votes: 0

Actually, I thought about it a bit and you really don't need VBA to generate the C files. You really could have a second page that copies the bit pattern values into cells that have the supporting text in other cells around them and just print to a text file.

Top
Someguy22
Someguy22's picture
Level: Posting Freak
Joined: Tue. Mar 14, 2006
Posts: 1473 View posts
Location: Near a lake, South of Boston, Massachusetts, USA
Posted by Someguy22: Sat. Sep 26, 2015 - 07:33 AM
  • 1
  • 2
  • 3
  • 4
  • 5
Total votes: 1

Just adding for those who don't know, you can download Microsoft Excel Starter from here for free: http://www.techspot.com/download...

Top
Bronze Markdavid.prentice
david.prentice's picture
Level: 10k+ Postman
Joined: Sat. Feb 12, 2005
Posts: 29908 View posts
Location: Wormshill, England
Posted by david.prentice: Sat. Sep 26, 2015 - 07:53 AM
  • 1
  • 2
  • 3
  • 4
  • 5
Total votes: 0

I would agree that you can make some "fairly attractive" big digits with the 8 user-definable characters,   Note that 'w' is chr(255) on most LCDs and 'b' is the regular chr(32) or space character.    So you are only using 7 user-defined in your example.

 

At the end of the day,   you will have gaps between each block on a regular HD44780 display.    A proper 128x64 graphics display is always going to look better.    The popular ST7920 displays are pin-compatible with the most common 20x4 displays.    And can be driven by 4-bit parallel or SPI.

 

David.

Top
china92
china92's picture
Level: New Member
Joined: Fri. Sep 25, 2015
Posts: 6 View posts
Posted by china92: Sat. Sep 26, 2015 - 02:15 PM (Reply to #6)
  • 1
  • 2
  • 3
  • 4
  • 5
Total votes: 0

I know that 'w' and 'b' are usually defined in LCD's memory and that is why I provided a separate support for this chars (so that you don't have to define it by yourself). I don't know if you noticed but the sheet is made for defining new custom chars and then you can use these chars that you made to create, for example, big digit or big letter 'S'. By big I mean containing few lines and cells on alphanumeric LCD. I just created a tool that helps me create my custom big characters on alphanumeric LCD and decided to share it with other people, because I thought this problem is more common (not only I have it). I wasn't asking for advice how to display big font and which LCD should I use, but thank you for it. :)

 

As for the gaps - they are barely noticeable, at least on my LCD, and the numbers I made looks nice anyway. Please see picture for reference.

LCD big font big digits

Last Edited: Sat. Sep 26, 2015 - 02:29 PM
Top
Bronze Markdavid.prentice
david.prentice's picture
Level: 10k+ Postman
Joined: Sat. Feb 12, 2005
Posts: 29908 View posts
Location: Wormshill, England
Posted by david.prentice: Sat. Sep 26, 2015 - 02:38 PM
  • 1
  • 2
  • 3
  • 4
  • 5
Total votes: 0

Yes, I think that your display looks attractive. Personally I would prefer 333 for the bottom row of the TWO.
Yes, 3-deep big characters are a happy compromise. I have played with 2-deep and 4-deep digits. You can get a reasonable "clock" but nothing else. Your example has a useful amount of information.

The big FOUR or big SEVEN are more difficult. Of course you can build many graphics.

David.

Top
china92
china92's picture
Level: New Member
Joined: Fri. Sep 25, 2015
Posts: 6 View posts
Posted by china92: Sat. Sep 26, 2015 - 03:25 PM
  • 1
  • 2
  • 3
  • 4
  • 5
Total votes: 0

If you want me to put here a whole image with the design of 3x3 digits I have invented for my clock I surely can do it. The thing is that IMHO we are getting slightly off-topic, as I wanted to share my tool with others and get some feedback for it. smiley

 

There are a lot of possibilities for making big digits on alphanumeric LCD (although they may do not differ that much from each other). And with this sheet you can make your own, with the preview included. I'm attaching the design I used for the project from previous picture (4 and 7 included). I wanted them to be 'roundy' in this case.

 

3x3 big digits LCD design

Last Edited: Sat. Sep 26, 2015 - 03:28 PM
Top
lsmodavr
lsmodavr's picture
Level: New Member
Joined: Thu. Apr 25, 2013
Posts: 8 View posts
Posted by lsmodavr: Sat. Sep 26, 2015 - 03:46 PM
  • 1
  • 2
  • 3
  • 4
  • 5
Total votes: 1

Really nice idea!

Thanks!

Top
Silver Markclawson
clawson's picture
Level: Moderator
Joined: Mon. Jul 18, 2005
Posts: 99691 View posts
Location: (using avr-gcc in) Finchingfield, Essex, England
Posted by clawson: Sat. Sep 26, 2015 - 04:14 PM
  • 1
  • 2
  • 3
  • 4
  • 5
Total votes: 0

But most HD44780 only allow 8 user defined characters on screen at any time? 

Top
china92
china92's picture
Level: New Member
Joined: Fri. Sep 25, 2015
Posts: 6 View posts
Posted by china92: Sat. Sep 26, 2015 - 04:21 PM
  • 1
  • 2
  • 3
  • 4
  • 5
Total votes: 0

Yes, thats true, in sheet there is place for 9 though. In this way it is more symmetric, there is no more reason behind that.

You can create all big digits with 7... maybe even 6 or less user-defined chars. Depends on level of details you want to have in each digit, etc.

@lsmodavr Thank you! smiley

Last Edited: Sat. Sep 26, 2015 - 04:44 PM
Top
Bronze Markjs
js's picture
Level: Moderator
Joined: Wed. Mar 28, 2001
Posts: 29579 View posts
Location: Sydney, Australia (Gum trees, Koalas and Kangaroos, No Edelweis, but plenty of Corona beer)
Posted by js: Sat. Sep 26, 2015 - 09:57 PM
  • 1
  • 2
  • 3
  • 4
  • 5
Total votes: 0

I tried to move this thread to off topic yesterday but I got an error so I gave up.

John Samperi

Ampertronics Pty. Ltd.

www.ampertronics.com.au

* Electronic Design * Custom Products * Contract Assembly

Top
china92
china92's picture
Level: New Member
Joined: Fri. Sep 25, 2015
Posts: 6 View posts
Posted by china92: Sat. Sep 26, 2015 - 10:08 PM
  • 1
  • 2
  • 3
  • 4
  • 5
Total votes: 0

Maybe "Compilers and General Programming" would be better? I wasn't sure where to put it.

Top
edward_yamunaque
edward_yamunaque's picture
Level: New Member
Joined: Mon. Jan 7, 2019
Posts: 8 View posts
Location: PERU
Posted by edward_yamunaque: Sat. Mar 16, 2019 - 12:17 AM
  • 1
  • 2
  • 3
  • 4
  • 5
Total votes: 0

I already made the big numbers, now as I call each 3x3 matrix depending on the number in binary, for example:
in binary 010 as I represent it on the LCD using the defined patterns. and for decimal numbers?

EDWARD JOSE/https://programaciondeavr.blogspot.com/

Top
supriokundu
supriokundu's picture
Level: New Member
Joined: Sun. Dec 23, 2018
Posts: 2 View posts
Location: Kolkata, IN
Posted by supriokundu: Sat. Mar 16, 2019 - 01:20 PM
  • 1
  • 2
  • 3
  • 4
  • 5
Total votes: 0

Wow, excellent effort dude......I'll try it myself

 

Thanks for the Excel file, it helped me lot creating new fonts.

 

Now the result.......

 

16x2 LCD Custom Font

Last Edited: Mon. Mar 18, 2019 - 12:58 AM
Top