Hi William, Thank you for your early reply. I can understand it completely. At first, I thought NAN was a forbidden-character.
Best wishes Li Meiying William said "Re: [qa-dev] forbidden-character code shows in chart data table" at 16:23:42 on 2009-05-31 : > >> >Hi Li Meiying >NAN means 'Not a Number', which is a normal requirement as a value in these >cells. Instead of deleting a value, if you replace it with 0 then scrolling >works. A blank value cannot be calculated but 0 can. Also, 'Test' is not >accepted for the same reason that it is not a number. >Regards >Bill > >2009/5/31 limeiying <[email protected]> > >> Hi all, >> >> In Writer, insert-Object-chart, this moment the chart can be edited, Right >> click on the chart - select "Chart data table" - delete any Y-values in any >> column, then scroll the middle key of the mouse, then "1.#NAN" shows in the >> data table. >> >> Note, >> If don't delete the data in the table cell and scroll the middle key of the >> mouse, values alter. >> But if enter characters like "test" or enter nothing in the cell, then >> scroll the middle key of the mouse, “1.#NAN” shows. >> >> Everyone, would you like giving me a hint? >> TIA ------------------ Beijing Redflag 2000 Software CO.,LTD MSN:[email protected] Email:[email protected] Tel:51570010-6140 Date:2009-05-31
