does not format text by format

Issue #821 invalid

Does not format text by format '# ##0'. For example, instead of the expected 1 000 000, we get 1000000.

Comments (11)

  1. Сергей Андреевич Жильников reporter

    Samir, have a good day! It may be out of place, but I would like to share some suggestions about the small improvements in your SpreadsheetView product: 1) it seems logical that if you have already allowed to change the column names, then auto-fit the width of the column by double clicking the mouse, taking into account the value of the column name. That is, in your example, when replacing the name of the first column by using the instruction spreadSheetView.getGrid().getColumnHeaders().setAll("Summary for the period»);, double clicking the mouse button has , but it would be desirable . 2) I would also like to be able to move the text in the column name to the following lines, if it does not fit in width. For example, as in the figure . 3) In addition, I did not find the opportunity to correct the next small defect: in your example, the images in the cells of the logo on the right close the cell boundary , which is a bit not beautiful. I apologize for writing to you on e-mail, but I think that the topic is of little interest to a large circle of users of your product.

    Thank you!

    Sincerely, Sergey Zhilnikov.

  2. Сергей Андреевич Жильников reporter
  3. SamirH

    Hi Serguey,

    Regarding the original problem, I do no understand it. If I set the format in the Sample like this :

    cell.setFormat("#,##0.00" + "\u20AC");

    I do have "1 000 000.00€" shown in the SpreadsheetView. Capture.PNG

    But anyway, these are samples to simply demonstrate the capabilities of the SpreadsheetView so anyone can format its cells the way he wants. If you want to use the format "# ###0" in your own Spreadsheet, you should be able to do so. I don't quite understand what the sample has to do with it.

    Regarding your last message, you seemed to have replied to the email but the images were lost in the process.

    I did not understood your problems, can you please, for each separate issue, either create a new issue in this issue tracker and follow this process:!topic/controlsfx-dev/DbjZor4buAQ

    Or post in the google group if you just need some helps.


  4. Сергей Андреевич Жильников reporter

    Samir, hello!

    I have the following problem with Spensheteviev: I have a table with a given number of rows and columns. All of them are completely placed on my form. I need only the table cells to be visible. I specify the width and height of the table, as in the picture below:

    I specify the width and height of the table, as the sum of the widths and heights of its columns and rows. Headings of columns and rows are hidden. But I still can not remove ScrollBars. And I get it only like this:

    Use in the css

    .SpreadsheetView > .table-view > .virtual-flow > .scroll-bar, .SpreadsheetView > .table-view > .virtual-flow > .scroll-bar:vertical, .SpreadsheetView > .table-view > .virtual-flow > .scroll-bar:horizontal { visibility: hidden; }

    does not give anything.

    I use the controlsfx-8.40.14.

    What do I need to do to get the required result? I will be glad to any help.

    Yours faithfully, Sergey Zhilnikov.

  5. SamirH

    Hi Serguey,

    Please consider posting in the Google group as I don't receive notifications on these issues.

    Regarding your issue, scrollbars can be a bit though to remove. Sometimes, they still appears even though they are not needed. Could you post in the google group with some sample code in order for me to look into the problem and try to find a solution for you?


  6. Log in to comment