https://bugs.documentfoundation.org/show_bug.cgi?id=143225
--- Comment #8 from Nenad Antic <libreoff...@famantic.net> --- Since this bug was reported last year a number of updates have happened to Calc. I haven't checked all the variants that I used when I was trying to work around the problem, but one is sort of working now. However, there is still a funny problem remaining. There are 2 files. 'basefile.ods' and 'workfile.ods'. 'basefile.ods' contains the data I want to insert using Sheet > 'Insert Sheet from File...' into 'workfile.ods'. Inserting the sheet 'import.2208' from 'basefile.ods' into 'workfile.ods' now kind of keeps the path and filename (which previously completely disappeared) in the sheet formulas. BUT, part of the external filename is changed! And it differs from time to time how it's changed. When I'm writing this, the filename in all the formulas is changed from 'Export_GCal_to_GSheet.202208.ods' in 'basefile.ods' to 'Export_GCal_to_GSheet.2022084.ods' after it's in 'workfile.ods'. This is very weird. Noting some things though. The filename that it's changed into actually does exist. The existing filenames only differ in the numbers indicating the month. The filename is never changed to something random that is not in the filesystem. So, this seems to indicate that something happens when fetching or checking for the existence of the referred file and picking the wrong one. There are also other '.ods' files in the same directory but the filename never changes to one that is completely different. Only the "date suffix" is changed. I have attached additional example files. - basefile.ods - workfile.ods - Export_GCal_to_GSheet.202208.ods Obviously they need to be placed in the correct path locations and manipulate the existing formulas accordingly to reproduce the behavior. -- You are receiving this mail because: You are the assignee for the bug.
