| Summary: | FILEOPEN: imported dropdown menu from excel does not work | ||
|---|---|---|---|
| Product: | LibreOffice | Reporter: | claytonpresco |
| Component: | Calc | Assignee: | Not Assigned <libreoffice-bugs> |
| Status: | RESOLVED WORKSFORME | ||
| Severity: | trivial | CC: | 79045_79045, barta, markus.mohrhard, robinson.libreoffice |
| Priority: | medium | Keywords: | filter:xls |
| Version: | Inherited From OOo | ||
| Hardware: | x86-64 (AMD64) | ||
| OS: | Windows (All) | ||
| Whiteboard: | |||
| Crash report or crash signature: | Regression By: | ||
| Bug Depends on: | |||
| Bug Blocks: | 108988, 109072 | ||
| 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
** Please read this message in its entirety before responding ** To make sure we're focusing on the bugs that affect our users today, LibreOffice QA is asking bug reporters and confirmers to retest open, confirmed bugs which have not been touched for over a year. There have been thousands of bug fixes and commits since anyone checked on this bug report. During that time, it's possible that the bug has been fixed, or the details of the problem have changed. We'd really appreciate your help in getting confirmation that the bug is still present. If you have time, please do the following: Test to see if the bug is still present on a currently supported version of LibreOffice (5.0.5 or 5.1.0) https://www.libreoffice.org/download/ If the bug is present, please leave a comment that includes the version of LibreOffice and your operating system, and any changes you see in the bug behavior If the bug is NOT present, please set the bug's Status field to RESOLVED-WORKSFORME and leave a short comment that includes your version of LibreOffice and Operating System Please DO NOT Update the version field Reply via email (please reply directly on the bug tracker) Set the bug's Status field to RESOLVED - FIXED (this status has a particular meaning that is not appropriate in this case) If you want to do more to help you can test to see if your issue is a REGRESSION. To do so: 1. Download and install oldest version of LibreOffice (usually 3.3 unless your bug pertains to a feature added after 3.3) http://downloadarchive.documentfoundation.org/libreoffice/old/ 2. Test your bug 3. Leave a comment with your results. 4a. If the bug was present with 3.3 - set version to "inherited from OOo"; 4b. If the bug was not present in 3.3 - add "regression" to keyword Feel free to come ask questions or to say hello in our QA chat: http://webchat.freenode.net/?channels=libreoffice-qa Thank you for your help! -- The LibreOffice QA Team This NEW Message was generated on: 2016-02-21 ** Please read this message in its entirety before responding ** To make sure we're focusing on the bugs that affect our users today, LibreOffice QA is asking bug reporters and confirmers to retest open, confirmed bugs which have not been touched for over a year. There have been thousands of bug fixes and commits since anyone checked on this bug report. During that time, it's possible that the bug has been fixed, or the details of the problem have changed. We'd really appreciate your help in getting confirmation that the bug is still present. If you have time, please do the following: Test to see if the bug is still present on a currently supported version of LibreOffice (5.2.5 or 5.3.0 https://www.libreoffice.org/download/ If the bug is present, please leave a comment that includes the version of LibreOffice and your operating system, and any changes you see in the bug behavior If the bug is NOT present, please set the bug's Status field to RESOLVED-WORKSFORME and leave a short comment that includes your version of LibreOffice and Operating System Please DO NOT Update the version field Reply via email (please reply directly on the bug tracker) Set the bug's Status field to RESOLVED - FIXED (this status has a particular meaning that is not appropriate in this case) If you want to do more to help you can test to see if your issue is a REGRESSION. To do so: 1. Download and install oldest version of LibreOffice (usually 3.3 unless your bug pertains to a feature added after 3.3) http://downloadarchive.documentfoundation.org/libreoffice/old/ 2. Test your bug 3. Leave a comment with your results. 4a. If the bug was present with 3.3 - set version to "inherited from OOo"; 4b. If the bug was not present in 3.3 - add "regression" to keyword Feel free to come ask questions or to say hello in our QA chat: http://webchat.freenode.net/?channels=libreoffice-qa Thank you for helping us make LibreOffice even better for everyone! Warm Regards, QA Team MassPing-UntouchedBug-20170306 there is drop-down list in Version: 6.3.0.0.alpha0+ Build ID: 51af3179cf972809d6495c7d58033e069f647bbf CPU threads: 4; OS: Linux 4.18; UI render: default; VCL: kde5; TinderBox: Linux-rpm_deb-x86_64@86-TDF, Branch:master, Time: 2019-02-01_00:15:00 Locale: ru-RU (ru_RU.UTF-8); UI-Language: en-US Calc: threaded Status->WFM |
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