Hi Li Meiying A pleasure. Thanks for your kind reply. Bill 2009/5/31 limeiying <[email protected]>
> 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] <msn%[email protected]> > Email:[email protected] <email%[email protected]> > Tel:51570010-6140 > Date:2009-05-31 >
