Bug 101312 - Referencing cells from another Calc window results in error 508 or 509 when file name contains an apostrophe
Summary: Referencing cells from another Calc window results in error 508 or 509 when f...
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected)
Inherited From OOo
Hardware: All All
: low minor
Assignee: Not Assigned
: 108774 (view as bug list)
Depends on:
Blocks: Cell-Reference
  Show dependency treegraph
Reported: 2016-08-05 00:32 UTC by Scott Jodoin
Modified: 2022-06-05 03:40 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:


Note You need to log in before you can comment on or make changes to this bug.
Description Scott Jodoin 2016-08-05 00:32:39 UTC
Tested on the most recent release (
To produce the bug:
Open two instances (Windows) of Calc, one with data in it, one empty. Save both in the directory named "bug's". eg data1.xlsx empty.xslx
Select a cell on the empty window, press '=' on the keyboard.
Using the mouse, select a data cell from the data1.xlsx window.
When the enter key is pressed, the function is set to lowercase, and an error 509 or 508 is displayed.

Maybe I shouldn't have put an apostrophe in my main work directory!
Comment 1 Joel Madero 2016-08-07 16:09:05 UTC
Confirmed on:
LibreOffice 3.3.0 
OOO330m19 (Build:6)
tag libreoffice-

Also tested on:
Build ID: fc305bb6d656736bedc2f89789e18d8c9a3bbf2c
CPU Threads: 2; OS Version: Linux 3.16; UI Render: default; 
Locale: en-US (en_US.UTF-8); Calc: group

Same behavior on both. Updating version to inherited from OOo

Setting to:
New (confirmed)
Minor - can slow down but will not prevent high quality work;
Low - default for minor bugs.
Comment 2 Jacques Guilleron 2017-06-26 13:50:43 UTC
*** Bug 108774 has been marked as a duplicate of this bug. ***
Comment 3 QA Administrators 2018-07-24 02:37:40 UTC Comment hidden (obsolete)
Comment 4 Mike Kaganski 2020-06-04 09:13:27 UTC
A workaround (and what Calc should do when selecting ranges with mouse) is to escape the apostrophe in file name to be two apostrophes - like "bug''s" for original directory "bug's" from comment 0.
Comment 5 QA Administrators 2022-06-05 03:40:15 UTC
Dear Scott Jodoin,

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 with the latest version of LibreOffice from https://www.libreoffice.org/download/

If the bug is present, please leave a comment that includes the information from Help - About LibreOffice.
If the bug is NOT present, please set the bug's Status field to RESOLVED-WORKSFORME and leave a comment that includes the information from Help - About LibreOffice.

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) from https://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: https://web.libera.chat/?settings=#libreoffice-qa

Thank you for helping us make LibreOffice even better for everyone!

Warm Regards,
QA Team