Bug 85063

Summary:	EDITING: Excel structured references returns error 508 on Calc
Product:	LibreOffice	Reporter:	Zeki Bildirici <kobzeci>
Component:	Spreadsheet	Assignee:	Not Assigned <libreoffice-bugs>
Status:	NEW ---	QA Contact:
Severity:	enhancement
Priority:	medium	CC:	ign_christian, jananikumar2k8, mariosv
Version:	4.3.0.4 release
Hardware:	Other
OS:	All
See Also:	https://bugs.freedesktop.org/show_bug.cgi?id=84819
Whiteboard:	BSA
i915 platform:		i915 features:
Attachments:	Sample Invoice file Sample Invoice file 2 Expense Report -1 for bug report

Description Zeki Bildirici 2014-10-15 14:59:18 UTC

Problem description: 

Hi,

I've grabbed some templates from MS Office template site(https://store.office.live.com/templates/templates-for-Excel), opening this xls files are ok with Excel, however some of the formulas return with 508 error. 

I'm uploading two invoices and a expense report as sample files.

Steps to reproduce:
1. Go to Office Templates https://store.office.live.com/templates/templates-for-Excel (You need MS Office account to open them via office Onlinei then save to your local machine, thus i'm uploading prepared samples)
2. Open it with Calc
3. It will ask for updating fields(i think it has no external link but has link to second worksheet on the spreadsheet)

For more compatibility issues, templates site is a good resource imho.

Current behavior:

Some formulas return with 508 error

Expected behavior:

Having no errors

Best regards,
              
Operating System: All
Version: 4.3.0.4 release

Comment 1 Zeki Bildirici 2014-10-15 15:00:12 UTC

Created attachment 107883 [details]
Sample Invoice file

Comment 2 Zeki Bildirici 2014-10-15 15:00:53 UTC

Created attachment 107884 [details]
Sample Invoice file 2

Comment 3 Zeki Bildirici 2014-10-15 15:01:32 UTC

Created attachment 107885 [details]
Expense Report -1 for bug report

Comment 4 m.a.riosv 2014-10-15 21:51:08 UTC

Hi Zeki, thanks for reporting.

Sample files use "Referencing cells in a table (structured referencing)" that are no supported by LibreOffice.

If you like, report a bug asking for enhancement (change the importance from normal to enhancement).

Please don't set up your own bug as NEW, is needed a confirmation by someone else.

Comment 5 Zeki Bildirici 2014-10-16 13:51:56 UTC

(In reply to m.a.riosv from comment #4)
> Hi Zeki, thanks for reporting.
hİ
> Sample files use "Referencing cells in a table (structured referencing)"
> that are no supported by LibreOffice.
> 
> If you like, report a bug asking for enhancement (change the importance from
> normal to enhancement).
Yes, sure and done. Thanks.

Comment 6 ign_christian 2014-10-16 14:31:48 UTC

Looks similar with Bug 84819. I just knew it called "Referencing cells in a table (structured referencing)" :D

Perhaps both reports can be merged?

Comment 7 m.a.riosv 2014-10-16 16:52:36 UTC

Hi @ign_christian, sure.

As this is now as enhancement maybe it's easier resolved the other one as duplicate of this one. Or change the other and resolve this as duplicate.
In any case perhaps could be redone the title.
At your choice :)

Comment 8 ign_christian 2014-10-17 02:23:56 UTC

*** Bug 84819 has been marked as a duplicate of this bug. ***

Use of freedesktop.org services, including Bugzilla, is subject to our Code of Conduct. How we collect and use information is described in our Privacy Policy.