134 reputation
16
bio website
location Barcelona, Spain
age
visits member for 3 years
seen Sep 6 '13 at 8:45

Feb
25
awarded  Notable Question
Dec
8
accepted Connecting to virtual machine when no connection to internet
Nov
26
awarded  Popular Question
Jul
25
comment Connecting to virtual machine when no connection to internet
In the end I found a solution myself, see my answer below. If you have another/better solution, or can explain why this works or won't work in some situations, please share!
Jul
25
answered Connecting to virtual machine when no connection to internet
Jul
25
comment Connecting to virtual machine when no connection to internet
I'm not sure how the ip is assigned, but I think it's VirtualBox managing it, and it always stays the same. Why should it not be static?
Jul
25
awarded  Commentator
Jul
25
comment Connecting to virtual machine when no connection to internet
I tried removing the NAT adapter and restarted the vm. The ip address to the vm is the same. I still cannot connect, but instead of "Can't connect" / "No route to host" I now get put on hold: "Server is taking too long" / "Operation timed out". This even happens while AirPort is on and connected, so it's kind of a step backwards ;-) Thanks for the help so far, hope you have a few more ideas up your sleeve!
Jul
25
comment Connecting to virtual machine when no connection to internet
I have both a NAT adapter and a Bridged adapter, and now I tried to add a Host-only adapter. It didn't help. Are you saying I should only keep the Host-only, and remove the others?
Jul
25
asked Connecting to virtual machine when no connection to internet
Jul
13
awarded  Supporter
Jul
13
comment How to reference variable sheet in OpenOffice Calc?
Yeah, I just edited the answer first so other people don't have to look in the comments for the solution :-)
Jul
13
accepted How to reference variable sheet in OpenOffice Calc?
Jul
12
revised How to reference variable sheet in OpenOffice Calc?
Fixed example, added explanation.
Jul
12
suggested suggested edit on How to reference variable sheet in OpenOffice Calc?
Jul
12
comment How to reference variable sheet in OpenOffice Calc?
Not a duplicate, but related in the use of INDIRECT for the solution. But this question is specific to referencing another sheet, for which special syntax seems to be needed.
Jul
12
comment How to reference variable sheet in OpenOffice Calc?
Thanks, that's what I needed! Here's the formula that worked in the end for my example: INDIRECT(B3&".A2") - where B3 is the cell in the current sheet that contains the name of the sheet to look for A2, which has the value I'm looking for.
Jul
11
asked How to reference variable sheet in OpenOffice Calc?
May
4
accepted Virtualbox shared folder reading problems from Apache
Apr
27
comment Virtualbox shared folder reading problems from Apache
Though you pointed me in the right direction I am not sure I can accept yours as an answer, as it would be misleading to other users. What is common practice in such case?