Column widths incorrect for 2nd and 3rd published ranges

Column widths incorrect for 2nd and 3rd published ranges

I have 3 publish ranges in this Zoho spreadsheet that I have arranged side-by-side (horizontally) with a couple of empty columns in between each range.  The first range begins in column A and ends in column G and when I insert that range into this web page page, the columns are the widths set in the spreadsheet. 

The problem is the column widths of the 2nd and 3rd published ranges do NOT display on a web page with the correct widths.  And, if I leave the ranges in their current positions, there does not appear to be anything that I can do with either the spreadsheet or the HTML code to fix this problem.

There does appear to be one "work around", albeit a very unsatisfactory one ...
If the published ranges are arranged vertically, in the same columns, starting with column A, then all of them have the correct widths when published on a web page.  I know this because I have this spreadsheet where I have two published ranges arrange in just that way and they are displayed on this web page.

However, because each range is simply the same data with different sorting, this "work around" is unsatisfactory.
Here's why:

  • When adding/or deleting entries from the first range, the number of rows in each range needs to be kept "in sync".
    So, ideally, by arranging the ranges horizontally, on the same rows, adding or deleting rows becomes a one step operation and has a much greater assurance that the ranges will stay in sync.
    Arranging them vertically means that adding/deleting the same number of rows has to be done as a separate step to each range and means there is a greater chance for error or for the ranges to become out of sync.

  • The code for the macros becomes more complicated. 
    This spreadsheet uses macros so that, when updating scores or adding new scores... the user simply edits the first range, then uses macros to update and format the 2nd and 3rd published ranges.  If the ranges are horizontal, then the beginning of each range is already known.  But when they're arranged vertically, the beginning of the 2nd and 3rd range has to be determined programatically. which is more error prone and also causes the macros to run that much longer.

I hope the sheets I've given you access to give your support team something "concrete" to go on when researching this problem.  And I would be very appreciative if you could address this  as soon as possible.

    Access your files securely from anywhere

        All-in-one knowledge management and training platform for your employees and customers.






                              Zoho Developer Community




                                                    • Desk Community Learning Series


                                                    • Digest


                                                    • Functions


                                                    • Meetups


                                                    • Kbase


                                                    • Resources


                                                    • Glossary


                                                    • Desk Marketplace


                                                    • MVP Corner


                                                    • Word of the Day


                                                    • Ask the Experts



                                                              • Sticky Posts

                                                              • Introducing a smarter, faster, and more flexible charting experience

                                                                Hello Zoho Sheet users, We're delighted to share the latest news about a major update to charts in Zoho Sheet! The new version supports dynamic data ranges, granular styling options, faster loading, and other interesting enhancements that allow you to
                                                              • What's new in Zoho Sheet: Simplify data entry and collaboration

                                                                Hello, Zoho Sheet community! Last year, our team was focused on research and development so we could deliver updates that enhance your spreadsheet experience. This year, we’re excited to deliver those enhancements—but we'll be rolling them out incrementally
                                                              • New Features: Repeat Last Action, Insert Cut/Copied Rows/Columns and Hyperlink

                                                                You might have noticed the constant updates to Zoho Sheet of late. Here are 3 more features that have been added to Zoho Sheet recently: F4 - Repeat Last Action Insert Cut/Copied Rows and Columns Insert Hyperlink Here is a screen cast demonstrating each of these features. Read further below to learn more about these new features. F4 - Repeat Last Action: You can now repeat the last action you made on your spreadsheet by using the keyboard shortcut, F4. It is quite handy and helps you get your work
                                                              • Introducing Forms in Zoho Sheet

                                                                We hereby bring you the power of ​forms in Zoho Sheet. ​Now, build and create your own customized forms using Zoho Sheet. Be it compiling a questionnaire or rolling out a survey, Zoho Sheet can do it all for you. Forms is an excellent feature that helps you collect information in the simplest of ways and having it in Zoho Sheet takes it a notch higher. Build Simple yet Powerful forms Building forms using Zoho Sheet is fairly simple. The exclusive 'Form' tab lets you create one quickly. Whether you
                                                              • Slicers are now available in Zoho Sheet—filter your data interactively

                                                                At Zoho Sheet, we diligently track user requests and feedback. In line with this, based on extensive user requests, we've integrated Slicers to pivot tables and are delighted to announce its release. Slicers are interactive visual filters that have add,


                                                              Manage your brands on social media



                                                                    Zoho TeamInbox Resources



                                                                        Zoho CRM Plus Resources

                                                                          Zoho Books Resources


                                                                            Zoho Subscriptions Resources

                                                                              Zoho Projects Resources


                                                                                Zoho Sprints Resources


                                                                                  Qntrl Resources


                                                                                    Zoho Creator Resources



                                                                                        Zoho CRM Resources

                                                                                        • CRM Community Learning Series

                                                                                          CRM Community Learning Series


                                                                                        • Kaizen

                                                                                          Kaizen

                                                                                        • Functions

                                                                                          Functions

                                                                                        • Meetups

                                                                                          Meetups

                                                                                        • Kbase

                                                                                          Kbase

                                                                                        • Resources

                                                                                          Resources

                                                                                        • Digest

                                                                                          Digest

                                                                                        • CRM Marketplace

                                                                                          CRM Marketplace

                                                                                        • MVP Corner

                                                                                          MVP Corner









                                                                                            Design. Discuss. Deliver.

                                                                                            Create visually engaging stories with Zoho Show.

                                                                                            Get Started Now


                                                                                              Zoho Show Resources

                                                                                                Zoho Writer

                                                                                                Get Started. Write Away!

                                                                                                Writer is a powerful online word processor, designed for collaborative work.

                                                                                                  Zoho CRM コンテンツ




                                                                                                    Nederlandse Hulpbronnen


                                                                                                        ご検討中の方