[Libreoffice-bugs] [Bug 53244] EDITING: Referencing cell on other sheet changed from 3.5.x to 3.6.0.0 release

2013-07-08 Thread bugzilla-daemon
https://bugs.freedesktop.org/show_bug.cgi?id=53244 QA Administrators changed: What|Removed |Added Status|NEEDINFO|RESOLVED Resolution|---

[Libreoffice-bugs] [Bug 53244] EDITING: Referencing cell on other sheet changed from 3.5.x to 3.6.0.0 release

2013-05-29 Thread bugzilla-daemon
https://bugs.freedesktop.org/show_bug.cgi?id=53244 QA Administrators changed: What|Removed |Added QA Contact||qa-ad...@libreoffice.org --- Comment

[Libreoffice-bugs] [Bug 53244] EDITING: Referencing cell on other sheet changed from 3.5.x to 3.6.0.0 release

2012-09-19 Thread bugzilla-daemon
https://bugs.freedesktop.org/show_bug.cgi?id=53244 Rainer Bielefeld changed: What|Removed |Added Status|UNCONFIRMED |NEEDINFO CC|

[Libreoffice-bugs] [Bug 53244] EDITING: Referencing cell on other sheet changed from 3.5.x to 3.6.0.0 release

2012-09-05 Thread bugzilla-daemon
https://bugs.freedesktop.org/show_bug.cgi?id=53244 mondane.woodwor...@gmail.com changed: What|Removed |Added Status|RESOLVED|UNCONFIRMED Resolu

[Libreoffice-bugs] [Bug 53244] EDITING: Referencing cell on other sheet changed from 3.5.x to 3.6.0.0 release

2012-08-29 Thread bugzilla-daemon
https://bugs.freedesktop.org/show_bug.cgi?id=53244 --- Comment #9 from mondane.woodwor...@gmail.com 2012-08-29 22:18:01 UTC --- I looked up the formula used to built the items for the drop downs: INDIRECT("'"&ALS(A28="-";"";PROPER(TEXT(A28;"")))&"'!$A$2:$A$30") As you can see, the formula is

[Libreoffice-bugs] [Bug 53244] EDITING: Referencing cell on other sheet changed from 3.5.x to 3.6.0.0 release

2012-08-29 Thread bugzilla-daemon
https://bugs.freedesktop.org/show_bug.cgi?id=53244 --- Comment #8 from mondane.woodwor...@gmail.com 2012-08-29 22:13:05 UTC --- I mean, unable to open it with correct cell references. See sheet 'Invoer', column B. Every cell has a range defined for the drop down referencing the other sheets -- C

[Libreoffice-bugs] [Bug 53244] EDITING: Referencing cell on other sheet changed from 3.5.x to 3.6.0.0 release

2012-08-29 Thread bugzilla-daemon
https://bugs.freedesktop.org/show_bug.cgi?id=53244 --- Comment #7 from mondane.woodwor...@gmail.com 2012-08-29 22:10:24 UTC --- (In reply to comment #6) > (In reply to comment #5) > > (In reply to comment #4) > > > Using the Excel delimiters is only supported when you choose ExcelA1 as > > > form

[Libreoffice-bugs] [Bug 53244] EDITING: Referencing cell on other sheet changed from 3.5.x to 3.6.0.0 release

2012-08-29 Thread bugzilla-daemon
https://bugs.freedesktop.org/show_bug.cgi?id=53244 Markus Mohrhard changed: What|Removed |Added Status|UNCONFIRMED |RESOLVED Resolution|

[Libreoffice-bugs] [Bug 53244] EDITING: Referencing cell on other sheet changed from 3.5.x to 3.6.0.0 release

2012-08-29 Thread bugzilla-daemon
https://bugs.freedesktop.org/show_bug.cgi?id=53244 --- Comment #5 from mondane.woodwor...@gmail.com 2012-08-29 17:51:01 UTC --- (In reply to comment #4) > Using the Excel delimiters is only supported when you choose ExcelA1 as > formula > grammar in Extras->Options->Libreoffice Calc->Formula othe

[Libreoffice-bugs] [Bug 53244] EDITING: Referencing cell on other sheet changed from 3.5.x to 3.6.0.0 release

2012-08-28 Thread bugzilla-daemon
https://bugs.freedesktop.org/show_bug.cgi?id=53244 --- Comment #4 from Markus Mohrhard 2012-08-29 06:45:35 UTC --- Using the Excel delimiters is only supported when you choose ExcelA1 as formula grammar in Extras->Options->Libreoffice Calc->Formula otherwise the default is Calc A1 which of cours

[Libreoffice-bugs] [Bug 53244] EDITING: Referencing cell on other sheet changed from 3.5.x to 3.6.0.0 release

2012-08-13 Thread bugzilla-daemon
https://bugs.freedesktop.org/show_bug.cgi?id=53244 --- Comment #3 from mondane.woodwor...@gmail.com 2012-08-13 11:48:29 UTC --- (In reply to comment #1) > Change the formula syntax to Excel A1 and you should be fine. It looks like > your user profile has been deleted. What do you mean by 'It look

[Libreoffice-bugs] [Bug 53244] EDITING: Referencing cell on other sheet changed from 3.5.x to 3.6.0.0 release

2012-08-13 Thread bugzilla-daemon
https://bugs.freedesktop.org/show_bug.cgi?id=53244 --- Comment #2 from mondane.woodwor...@gmail.com 2012-08-13 11:48:01 UTC --- (In reply to comment #1) > Change the formula syntax to Excel A1 and you should be fine. It looks like > your user profile has been deleted. Could you explain this? Sinc

[Libreoffice-bugs] [Bug 53244] EDITING: Referencing cell on other sheet changed from 3.5.x to 3.6.0.0 release

2012-08-11 Thread bugzilla-daemon
https://bugs.freedesktop.org/show_bug.cgi?id=53244 --- Comment #1 from Markus Mohrhard 2012-08-12 01:14:03 UTC --- Change the formula syntax to Excel A1 and you should be fine. It looks like your user profile has been deleted. -- Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?ta

[Libreoffice-bugs] [Bug 53244] EDITING: Referencing cell on other sheet changed from 3.5.x to 3.6.0.0 release

2012-08-08 Thread bugzilla-daemon
https://bugs.freedesktop.org/show_bug.cgi?id=53244 mondane.woodwor...@gmail.com changed: What|Removed |Added Version|unspecified |3.6.0.4 -- Configure bugm