Summary: | FILEOPEN: imported dropdown menu from excel does not work | ||
---|---|---|---|
Product: | LibreOffice | Reporter: | claytonpresco |
Component: | Spreadsheet | Assignee: | Not Assigned <libreoffice-bugs> |
Status: | NEW --- | QA Contact: | |
Severity: | trivial | ||
Priority: | medium | CC: | barta, markus.mohrhard, qubit |
Version: | Inherited From OOo | ||
Hardware: | x86-64 (AMD64) | ||
OS: | Windows (All) | ||
Whiteboard: | |||
i915 platform: | i915 features: | ||
Attachments: |
work sheet for entering data about cell site stuff
excel spreadsheet with dropdown menu libo with no drop down and office build number VERSION XX of cell site spreadsheet |
which LibO version are you using? would you please post a comparative screenshot of the file opened in Excel and LibO to spot the difference? Comment on attachment 112577 [details]
work sheet for entering data about cell site stuff
fix mimetype
(In reply to tommy27 from comment #1) > which LibO version are you using? > would you please post a comparative screenshot of the file opened in Excel > and LibO to spot the difference? Status -> NEEDINFO (Please change status back to UNCONFIRMED after you answer tommy's questions. Thanks!) Created attachment 112581 [details]
excel spreadsheet with dropdown menu
Created attachment 112582 [details]
libo with no drop down and office build number
Sorry too many choices with the posting and status. can you see what I am talking about with the drop down menu, let me know if I can give more info Clayton -- please put the version of LibreOffice in the field above. Thanks Version: 4.3.5.2 Build ID: 3a87456aaa6a95c63eea1c1b3201acedf0751bd5 bug confirmed. those dropdown menus are not shown in LibO. bug is present in any LibO releases I tested (including 3.3.3, 4.3.2 and 4.5.0 alpha) and in AOO 4.1.0 and OOo 3.3.0 as well. hence the bug is inherited from OOo. I add a Calc developer to CC list to see what he thinks about. Created attachment 112693 [details]
VERSION XX of cell site spreadsheet
I have an update on the spreadsheet I gave you to work with.
I feel the original I have been having so much trouble working with may be corrupt from its original source, version XX is one I have been playing with all day and have had no issues with the saving or the dropdowns.
I have been saving the original as an xlsx. it has been nothing but difficult.
I saved it in libo as an ods file and opened it in excell it said it had deleted something. excell stripped all the drop downs. I resaved it as an ods in excell made new drop downs. since then have had no pop up asking to link to anything and drop downs are working fine.
before I was having issues saving as an xslx file from Libo (it would strip cell colors and fonts and have conflicts with excell)
I have added my new spreadsheet version XX I hope this helps
|
Use of freedesktop.org services, including Bugzilla, is subject to our Code of Conduct. How we collect and use information is described in our Privacy Policy.
Created attachment 112577 [details] work sheet for entering data about cell site stuff when work sheet is opened in excell drop down menus on the columns f,j n and so on work fine in excell when opened in libre says "this file contains links to other files should they be updated" yes or no still no dropdowns. added my own dropdowns, saved as xlsm, opened in excell, it asked if I wanted to repair the document cause the libre dropdown was interfering with excells dropdown data