Header Problem when Uploading xlsx files

Issues with installing under all versions of MS Windows
Post Reply
ggreen4077
Posts: 2
Joined: Thu Nov 17, 2016 5:08 pm

Header Problem when Uploading xlsx files

Post by ggreen4077 »

Opening an xlsx file in calc. File has preformatted headers for data entry. When I open the file, the preloaded header titles in row 1 replicate in the cell by repeating the titles over and over. If I make the header row larger by dragging it down, the header data continues to repeat until the expanded cells are filled. This is what Row 1, Column A looks like.

Item Number (101-999) (Un-Assigned items do not require a number)
Item Number (101-999) (Un-Assigned items do not require a number)
Item Number (101-999) (Un-Assigned items do not require a number)
Item Number (101-999) (Un-Assigned items do not require a number)
Item Number (101-999) (Un-Assigned items do not require a number)
Item Number (101-999) (Un-Assigned items do not require a number)
Item Number (101-999) (Un-Assigned items do not require a number)
Item Number (101-999) (Un-Assigned items do not require a number)
Item Number (101-999) (Un-Assigned items do not require a number)
Item Number (101-999) (Un-Assigned items do not require a number)
Item Number (101-999) (Un-Assigned items do not require a number)

When opened in Excel, there is a single entry in each title cell. Is there some Calc setting I'm missing?
Openoffice Ver 4.1.2 on Windows 10
User avatar
Zizi64
Volunteer
Posts: 11353
Joined: Wed May 26, 2010 7:55 am
Location: Budapest, Hungary

Re: Header Problem when Uploading xlsx files

Post by Zizi64 »

Please upload your sample file here.
Tibor Kovacs, Hungary; LO7.5.8 /Win7-10 x64Prof.
PortableApps/winPenPack: LO3.3.0-7.6.2;AOO4.1.14
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.
Post Reply