How to transform a table in OpenOffice Calc?

Question

openoffice

Hello, there is a large table for several tens of thousands of lines with a clear structure. How to transform it?

That is, I need to build vertically from a horizontal column into 1 column.
Thanks in advance!

Answer 1

Copy-paste in sublime will save the father of Russian democracy, but the Toaster is no longer a cake. Eh.

Answer 2

because

$('.field_email').val()

returned undefined

Answer 3

$('.field__email').blur(function() {
    $(this).removeClass('form__error form__accept');
    var nameLngth = $(this).val().length;
    if(nameLngth <= 1){
        $('.field__email').addClass('form__error');
    } else {
        $('.field__email').addClass('form__accept');
    }
});

Answer 4

Because the expression $('.field__email').val()returns 'undefined'. This is because there is no such element with class 'field_email' because you removed all classes from elements with class 'field__email' in the line above. Most likely, this code will work:

$('.field__email').blur(function(){
    var field = $('.field__email');
    field.removeClass();
    var nameLngth = field.val().length;
    if(nameLngth <= 1){
        field.addClass('.form__error');
    } else {
        field.addClass('.form__accept');
    }
});