Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

Let me see if I can explain this differently. I don't believe it's a bug, but I need to know the format to link cell name data when cell name is set to "Sheet" focus.

If you open a Libreoffice Calc v.3.4.ish spreadsheet and look toward the upper left side of the window, there is a field for cell location which Help Tips labels as "Name Box" defaulting to the format of ColumnRow, i.e. A1.

On this version (3.4.xx) this name box data, when entering text, is considered global to the spreadsheet file. In other words, a text name in this field, other than the ColumnRow format, could not be duplicated on any sheet within this spreadsheet file. I would link these cells to a different spreadsheet file with the format:

=DDE("soffice","C:\programdata\spreadsheet.ods","CELLNAME")

This =DDE entry is assuming the "CELLNAME" as global. I have pre existing files, supplied by a third part source, that use cell names.

If I use a Calc v4.0.2.2 installation and open a spreadsheet, this cell name field now has a downward pointing arrow button just the right of this field. Entering data in this field seems to require setting the focus to either global or sheet. The older Calc versions did not seem to offer this flexibility and seemed to assume global.

Now, all links do not work because my "=DDE("soffice","C:\programdata\spreadsheet.ods","CELLNAME")" does not specify a specific sheet and the third party file's cell names NOW are considered as sheet focus.

My question is: What DDE format can I use to access the cell by name and specify the sheet. Also, what may be the best way to replace these links as I have 100's of link entries?

Thank you very much... Paul