Text objects in spreadsheet

cie shared this problem 10 years ago
Answered

Hi,


I found a problem with Text[<Object>,<Point>] in spreadsheets.

If you type

    =Text["Hello", (0, 0)]

in A1, it does not appear. Now if you type

    A1=Text["Hello", (0, 0)]

in the input line, nothing happens, however, after deleting A1, it works.


Bernát

Comments (10)

photo
1

Properties -> Show Object


(by default, text objects in the spreadsheet are not shown in the Graphics View)

photo
1

:) thanks! Yeah, it's clear.


But I still have a problem: If you autocomplete in the file from D1 to D2 and D3, the D2 and D3 texts don't appear. After turning off and on Show object, they appear but in the same place as D1.


Thanks for your help!

Bernát

https://ggbm.at/540481

photo
1

Hi,


In the same Properties, use the Position tab, or the Advanced tab. You can put the position in the spreadsheet. The Advanced tab allows you to decide when to show the text.


Kathryn

photo
1

they appear but in the same place as D1.


Nice bug! 3.1.287.0 online now :)

photo
1

Thanks very much!


I've encountered a similar problem: I'd like to autocomplete sliders so that their animation speeds are determined by numbers in another column. I can set slider min, max, increment, and repeat mode on the property page by selecting them all, but for animation speed I'd need autocompletion.


The example might help you.


Many thanks,

Bernát

https://ggbm.at/540491

photo
1

I suggest that you make A2, A3, A4, etc. depend on one single animated slider A1. As far as I understand you want these values to change at the same time at different speeds and possibly in different intervals. You can do that by simply specifying formulas for A2, A3, A4, etc. depending on A1 and possibly other values (like speeds in the B column).


All the best,

Markus

photo
1

Hi Markus,


Unfortunately I need the sliders to be independent. What I was trying to do is to use slider animations for simulation, especially to simulate a rubber string hung between two points. I have finished it by setting the speeds by hand, here it is: http://www.geogebra.org/en/...

(I was inspired by this post.) I know it's beyond GeoGebra's current purposes. By the way, I was amazed that even automatic colours worked with autocompletion -- and it would be very cute if every property did. But, I have no reason to complain, GeoGebra is already really really good :D .


Kind regards,

Bernát

photo
1

I put 1,2,3, ... 10 in A1:A10, and then I let B1=""+A1, set B1's position corner 1 to (A1,0), and autocompleted B2:B10, and hoped Text objects "1", "2", ..., "10" would be positioned accordingly, but in vain. Corner 1 of B2:B10 were all set to (A1,0)!


It seems that autocompletion doesn't work for the position property of Text objects, I can't see why. :cry:

photo
1

Try:

A1=(2,3)

B1=Text["1",A1]

photo
1

Try:

A1=(2,3)

B1=Text["1",A1]

Thanks, murkle.


I found that these two different ways for setting the position of text objects make the texts behave differently:


B1=Text["1",A1]

  • autocompletion works.
  • the text object is not draggable.


B1=""+A1, then set Corner 1 of B1 to be (A1,0)

  • autocompletion doesn't work.
  • the text object is draggable.

© 2020 International GeoGebra Institute