Spreadsheet range name bug

Asked by Chuck

Using Ubuntu 15.04, LibreOffice 4.4.6.3
A simple test case:

I create a data/range named DataSet1 (at A1:C1 through A3:C3)
I create another data/range named DataSet2 (at D1:F1 through D3:F3)
I fill in some data into each range.

Elsewhere in the spreadsheet I enter these formulas (in separate cells):

A20 has =sum(DataSet1)
D20 has =sum(DataSet2)

yet, when I look at the second one (D20), it has DataSet1 in it. No matter how many times I enter DataSet2, it changes it to DataSet1

On the other hand, if I use names like "DataSetOne" and "DataSetTwo" it works ok. Apparently, it's having problems with range names containing digits.
So, for now, I have a workaround, BUT I have many legacy spreadsheets that may be using names that get corrupted.

Question information

Language:
English Edit question
Status:
Answered
For:
Ubuntu Edit question
Assignee:
No assignee Edit question
Last query:
Last reply:
Revision history for this message
actionparsnip (andrew-woodhead666) said :
#1

I suggest you report a bug

Can you help with this problem?

Provide an answer of your own, or ask Chuck for more information if necessary.

To post a message you must log in.