There are two partial answers to your question, and which one(s) apply to you depends on many factors.
First of all, you need to separate 'document size' from 'printer size'.
It's entirely possible to design a document that exceeds your current printer's capacity. If you print it, it will 'tile' across multiple pages that need to be subsequently stitched (or taped) together for the final output.
There are applications that can automate this, managing margins, overlaps, etc. to optimize the output.
According to Corel (since you mention them), CorelDraw's maximum canvas size is 1,800 x 1,800 inches, or about 30,000 times the size of a single sheet of paper. Therefore what I think you're encountering is that Corel is querying the printer for the paper size it supports, and limiting you to that. There should be some way of overcoming that, but if your printer is limited to F4-sized paper, there's going to be some work involved in stitching pages together after printing.
The alternative (and what's normally used for large-scale banner printing) is a large format printer which uses rolls of paper that are cut to length. I'm going to go out on a limb and suggest that if you had one of these, CorelDraw would scale up to support whatever size paper roll the printer supports (typically these come in 24", 36" and 48" wide formats that are, potentially, hundreds of feet long).
So the question is how do you expect to print a 1m long banner if your printer can only handle A4-sized sheets?
You might want to look in the App Store for 'Poster Maker' or 'Banner maker' tools. They might be better suited to non-standard page sizes, and have some extra hooks for tiling multiple smaller pages.
