Description: I have a model to make quotations that uses links to an address book and a price list. Making a new file: all functions using a link give the correct result. I have changed some functions in the model. Now if I edit an existing file, some function results in some rows give #VALUE as result and other rows not. I have 50 rows in the quote and, of course, SEARCH.VALUE have correct references. On opening to edit, a pop-up informs me that the mode has change and lets me choose between "Keep old styles" and "Update styles" (sorry translated from Italian) and I do not understand why this happens. No matter what I choose, error persists. Actual Results: See description. Expected Results: Correct result while editing. Reproducible: Always User Profile Reset: Yes Additional Info: See description.
Version: 7.1.5.2 (x64) / LibreOffice Community Build ID: 85f04e9f809797b8199d13c421bd8a2b025d52b5 CPU threads: 4; OS: Windows 6.1 Service Pack 1 Build 7601; UI render: Skia/Raster; VCL: win Locale: it-IT (it_IT); UI: it-IT Calc: threaded
some reporter writes that some functions don't work...guessing that some folks at LO will somehow guess what it is about? You need to attach minimal sample and write exact steps with that sample.
Hi! I've made a new file today using the model and all is OK. No changes in model. Opening to edit: - "Automatic link update disabled" message - some cells have #VALUE! - "Update OK" button in the message bar - all is correct I have Java 1.8.0_301. Furthermore: - model has seven different sheets - errors are in the first sheet that has not been changed in the model Can someone explain why the pop-up message of "changed styles" appears if I open a file for editing after changing/adding some formula in the model? What's the difference between the two options given? Will attach .png what happened in "Opening to edit".
Created attachment 175046 [details] Opening to edit 01
Created attachment 175047 [details] Opening to edit 02
Created attachment 175048 [details] Opening to edit 03
This doesn't look like a proper bug with sample and steps: https://wiki.documentfoundation.org/QA/BugReport If you can write reproducible steps and attach sample, status should be Unconfirmed. Here is no place to help, for that you should use ask.libreoffice.org.
Created attachment 175053 [details] Model
Created attachment 175054 [details] Address file. Used in sheets "Mat", "Prev" and "Ft".
Created attachment 175055 [details] Locations. Used in sheet "Mat"
Created attachment 175056 [details] Price-list (confidential) Used in sheet "Mat".
Created attachment 175057 [details] Issued invoices (highly confidential) Used in sheet "Ft".
I've added the files. Data are confidential. For me it's not a help request (creating a new file all is OK), but a bug as errors only if editing existing file after changing/adding a formula in the model file even if these are not affecting formulas with an error as result. I have set paths in "Macro security". Still keeps asking update Yes/No new styles even with no model change in the meantime. These neither clicking on "Update" nor "Keep". Hope to get an answer.
(In reply to Arnaldo from comment #13) > I've added the files. > > Data are confidential. > Files in bugzilla are accessible for everyone. Links in your file are in exact paths D:\... , so cannot test in Linux. "some function results in some rows give #VALUE" - do you mean sheet "Prev", cell L32?
(In reply to raal from comment #14) > "some function results in some rows give #VALUE" - do you mean sheet "Prev", > cell L32? Set to NEEDINFO. Change back to UNCONFIRMED after you have provided the information.
Dear Arnaldo, This bug has been in NEEDINFO status with no change for at least 6 months. Please provide the requested information as soon as possible and mark the bug as UNCONFIRMED. Due to regular bug tracker maintenance, if the bug is still in NEEDINFO status with no change in 30 days the QA team will close the bug as INSUFFICIENTDATA due to lack of needed information. For more information about our NEEDINFO policy please read the wiki located here: https://wiki.documentfoundation.org/QA/Bugzilla/Fields/Status/NEEDINFO If you have already provided the requested information, please mark the bug as UNCONFIRMED so that the QA team knows that the bug is ready to be confirmed. Thank you for helping us make LibreOffice even better for everyone! Warm Regards, QA Team MassPing-NeedInfo-Ping
Dear Arnaldo, Please read this message in its entirety before proceeding. Your bug report is being closed as INSUFFICIENTDATA due to inactivity and a lack of information which is needed in order to accurately reproduce and confirm the problem. We encourage you to retest your bug against the latest release. If the issue is still present in the latest stable release, we need the following information (please ignore any that you've already provided): a) Provide details of your system including your operating system and the latest version of LibreOffice that you have confirmed the bug to be present b) Provide easy to reproduce steps – the simpler the better c) Provide any test case(s) which will help us confirm the problem d) Provide screenshots of the problem if you think it might help e) Read all comments and provide any requested information Once all of this is done, please set the bug back to UNCONFIRMED and we will attempt to reproduce the issue. Please do not: a) respond via email b) update the version field in the bug or any of the other details on the top section of our bug tracker Warm Regards, QA Team MassPing-NeedInfo-FollowUp