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: 2020-06-04 09:20 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.